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