« previous next »

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

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

IgA antibodies protect body surfaces exposed to outside foreign substances. IgG antibodies are found in all body fluids. IgM antibodies are the first type of antibody made in response to an infection. IgE antibody levels are often high in people with allergies. IgD antibodies are found in tissues lining the abdomen and chest.

Effects of excluding Helicopsyche borealis on benthic algal biomass: (a) two sets of tiles at the be Effects of excluding Helicopsyche borealis on benthic algal biomass: (a) two sets of tiles at the be
Louisiana Purchase Louisiana Purchase
That politics was always a rough business is shown in this cartoon, which shows Lincoln, assisted by That politics was always a rough business is shown in this cartoon, which shows Lincoln, assisted by
In 1891 William Dean Howells championed the poetry of Emily Dickinson: “This poetry is as characteri In 1891 William Dean Howells championed the poetry of Emily Dickinson: “This poetry is as characteri
Teresa Hubbard and Alexander Birchler, Detached Building. Teresa Hubbard and Alexander Birchler, Detached Building.
Legal Environment of Business: Online Commerce, Ethics, and Global Issues (Cheeseman) Legal Environment of Business: Online Commerce, Ethics, and Global Issues (Cheeseman)
Video: Mechanisms for chromosome movement Animation

For a complete list of videos, visit our video library