Calculate the equivalent future cost in year 10 for the following series of disbursements at an interest rate of 10% per year. Also, write a single-cell spreadsheet function that will determine the future worth.





What will be an ideal response?


F = 4000(F/A,10%,9)(F/P,10%,1) + 1000(F/A,10%,4)(F/P,10%,1)
= 4000(13.5795)(1.1000) + 1000(4.6410)(1.1000)
= 59,750 + 5105
= $64,855
Spreadsheet function: = (-FV(10%,9,4000)-FV(10%,4,1000))*(1.1)

Trades & Technology

You might also like to view...

A transistor is made by joining how many layers of semiconductor material?

a. Two b. Three c. Four d. Five

Trades & Technology

Lift with your _____, not your back.

What will be an ideal response?

Trades & Technology

Using the drawings of Billy’s Convenience Store found in Appendix D, determine the quantity of concrete and reinforcing required for the spread footings.

What will be an ideal response?

Trades & Technology

Which mineral, required by goats, is toxic to sheep?

A. sodium B. phosphorus C. calcium D. copper

Trades & Technology