year 5? e. How long will it take for a $2,000 investment to double in value? f.
ID: 2799955 • Letter: Y
Question
year 5? e. How long will it take for a $2,000 investment to double in value? f. What will be the value in 20 years of $1,000 invested at the end of each year for the next 20 years? g. A couple wishes to save $250,000 over the next 18 years for their child's college education. What uniform annual amount must they deposit at the end of each year to accomplish their objective? h. How long must a stream of $600 payments last to justify a purchase price of $7,500.00? Suppose the stream lasted only five years. How large would the salvage value (liquidating payment) need to be to justify the investment of $7,500.00?Explanation / Answer
e) No of years = NPER(rate = 8%, pmt = 0, pv = -2,000, fv = 4,000, 0) = 9.00 years
f) Value = FV(rate = 8%, nper = 20, pmt = -1,000, pv = 0, 0) = $45,761.96
g) Annual Deposit = PMT(rate = 8%, nper = 18, pv = 0, fv = -250,000, 0) = $6,675.52
h) For a perpetuity, Value = Stream / Rate = 600 / 8% = $7,500. Hence, that stream would last forever.
If it last only for five years, its value at the end of year 5 = 7,500 because it is a perpetuity.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.