Dakota Hi-C Steel signed a contract that will generate revenue of $210,000 now, $226,800 in year 1, and amounts increasing by 8% per year through year 5. Calculate the future worth of the contract at an interest rate of 8% per year. Also, develop the FV function that will correctly determine F for revenues placed in cells B2 through B7.
What will be an ideal response?
(a) Find P in year –1 and then move to year 5
P -1 = 210,000[6/(1 + 0.08)]
= 210,000(0.92593)
= $1,166,667
F = 1,166,667(F/P,8%,6)
= 1,166,667(1.5869)
= $1,851,383
(b) Spreadsheet function: = -FV(8%,5,,NPV(8%,B3:B7)+B2)
You might also like to view...
Plant cells have a large central vacuole, a cell wall, and organelles called _________
Fill in the blank(s) with correct word
California's building energy code, Title ____, requires specific energy efficiency measures in all residential new construction and renovation projects requiring a building permit.
A. 13 B. 18 C. 24 D. 32
Select the component (part) that is not a component or part of the GTAW torch assembly
A) Cup nozzle B) Torch body C) Back cap D) Gas diffuser E) None of the above
The resistance wire used in electric heating elements is usually ____.
A. copper B. nickel steel C. nickel chromium D. aluminum