« previous next »

Author Question: A restaurant owner sets up a sinking fund to purchase a new building to expand its business. The ... (Read 68 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?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Building competency in patient centered care Building competency in patient centered care
Earth’s history is divided into nested sets of time--eons, eras, periods, and epochs--and is called Earth’s history is divided into nested sets of time--eons, eras, periods, and epochs--and is called
Frank Gehry and Vlado Milunić, Rasin Building (a.k.a. the "Dancing House" or ... Frank Gehry and Vlado Milunić, Rasin Building (a.k.a. the "Dancing House" or ...
Business Math Business Math
Business Math Business Math
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: Eczema

For a complete list of videos, visit our video library