« previous next »

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

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Teresa Hubbard and Alexander Birchler, Detached Building. Teresa Hubbard and Alexander Birchler, Detached Building.
How to expand a polynomial (Part 2) How to expand a polynomial (Part 2)
Romans Crossing The Danube and Building A Fort Romans Crossing The Danube and Building A Fort
International Business: The Challenges of Globalization International Business: The Challenges of Globalization
Business Math Question Solution Business Math Question Solution
A graphical representation of correlations in IQ measurements in different sets of individuals. The A graphical representation of correlations in IQ measurements in different sets of individuals. The
Video: Fractures Animation

For a complete list of videos, visit our video library