« previous next »

Author Question: A restaurant owner sets up a sinking fund to purchase a new building to expand its business. The ... (Read 82 times)

jake

  • Hero Member
  • *****
  • Posts: 538
on: Jun 24, 2018
A restaurant owner sets up a sinking fund to purchase a new building to expand its business. The factor from the sinking fund table is stored in Cell B4 and the cost is in Cell B3. Which is the correct way to enter the formula for the periodic deposit using an absolute cell reference?
 A) =B3B4
  B) =B3B4
  C) =B3B4
  D) =B3B4

Question 2

An Excel spreadsheet contains the following information about annuities: Column A: Payment, Column B: Rate, Column C: Compounded, Column D: Years, Column E: Total Annuity Investment, Column F: Present Value Factor, Column G: Present Value of Annuity Investment, Column H: Total Interest. Which is the formula needed in Column G to calculate the Present Value of Annuity Investment?
 A) =ROUND((B6E6),2)
  B) =ROUND((A6F6),2)
  C) =ROUND((A6B6D6),2)
  D) =ROUND((E6F6),2)


jojobee318

  • Sr. Member
  • ****
  • Posts: 298
Reply #1 on: Jun 24, 2018
Answer to Question 1

D

Answer to Question 2

D


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Ludwig Mies van der Rohe and Philip Johnson, Seagram Building, New York City. Ludwig Mies van der Rohe and Philip Johnson, Seagram Building, New York City.
Do not interact with a service dog unless you have permission from its owner. Do not interact with a service dog unless you have permission from its owner.
Private Practice Massage Therapy Business Plan Private Practice Massage Therapy Business Plan
Human Relations: The Art and Science of Building Effective Relationships Human Relations: The Art and Science of Building Effective Relationships
Business Analytics, 2nd Edition Business Analytics, 2nd Edition
Math for Business and Finance: an Algebraic Approach, 3rd Edition Jeffrey Slater Math for Business and Finance: an Algebraic Approach, 3rd Edition Jeffrey Slater
Video: Morphology of a tomato plant

For a complete list of videos, visit our video library