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

jake

  • Hero Member
  • *****
  • Posts: 538
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
Answer to Question 1

D

Answer to Question 2

D



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

For a complete list of videos, visit our video library