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)
You might also like to view...
What mark is placed on an engine block or other cast engine components for identification?
A) Casting number B) VIN number C) Both A and B D) Neither A nor B
The ____________________ is the back half of an animal.
Fill in the blank(s) with the appropriate word(s).
A parallel circuit has three resistances: 10, 2, and 5 ohms. Circuit voltage is 14.5 volts. What is the total circuit resistance of this parallel circuit?
Fill in the blank(s) with the appropriate word(s).
The ____ approach to design and construction provides contractors and future homeowners with a comprehensive methodology for creating healthy, comfortable, and durable homes.
A. Total System B. Total House System C. House as a System D. Systematic Housing