« previous next »

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

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Famous people who died from poisoning or drug overdose include, Adolf Hitler, Socrates, Juan Ponce de Leon, Marilyn Monroe, Judy Garland, and John Belushi.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Building competency Building competency
Building competency in safety Building competency in safety
This painting depicts New Orleans in 1803, when the city was acquired—along with much of the modern This painting depicts New Orleans in 1803, when the city was acquired—along with much of the modern
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.
Human Relations: The Art and Science of Building Effective Relationships Human Relations: The Art and Science of Building Effective Relationships
One year ago, Christos bought 1000 units of the Dominion Aggressive Growth Fund at $20.35 per ... One year ago, Christos bought 1000 units of the Dominion Aggressive Growth Fund at $20.35 per ...
Video: ribosome

For a complete list of videos, visit our video library