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.


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...

The number of ewes that a ram can breed depends on the size of the ram

Indicate whether the statement is true or false.

Trades & Technology

Incubation time for ostrich eggs ranges from _____ to _____ days

a. 21, 39 c. 60, 79 b. 39, 59 d. 80, 89

Trades & Technology

What does a speed indicator do?

What will be an ideal response?

Trades & Technology

Which type of glove should be used if prolonged contact with liquid or gas is expected?

A) PVA B) Cloth C) Leather D) Plastic

Trades & Technology