Morris Glass Company has decided to invest funds for the next 5 years so that de

Question

Morris Glass Company has decided to invest funds for the next 5 years so that development of "smart" glass is well funded in the future. This type of new-technology glass uses electrochrome coating to allow rapid adjustment to sun and dark in building glass, as well as assisting with internal heating and cooling cost reduction. The financial plan is to invest first, allow appreciation to occur, and then use the available funds in the future. All cash flow estimates are in $1000 units, and the interest rate expectation is 9% per year. Years 1 through 5: Invest $7000 in year 1, decreasing by $1000 per year through year 5 Years 6 through 10: No new investment and no withdrawals. Years 11 through 15: Withdraw $20,000 in year 11, decreasing 20% per year through year 15. Determine if the anticipated withdrawals will be covered by the investment and appreciation plans. If the withdrawal series is over- or underfunded, what is the exact amount available in year 11, provided all other estimates remain the same?

Explanation / Answer

The exact amount available for withdrawal at the beginning of year 11 is  $51908056

year 1 2 3 4 5 Total Investment $   70,00,000 $   60,00,000 $   50,00,000 $   40,00,000 $ 30,00,000 Number of years 5 4 3 2 1 FV factor @ 9% 1.5386 1.4116 1.295 1.1881 1.09 FV $ 107,70,200 $   84,69,600 $   64,75,000 $   47,52,400 $ 32,70,000 $ 337,37,200 FV factor @ 9% for 5 years (year 6-10, $33737200 remained invested @ 9%) 1.5386 Total of investment and appreciation at the end of 10th year $ 519,08,056 Calculation of present value of withdrawal at the end of 10th year Year 1 2 3 4 5 Withdrawal $ 200,00,000 $ 160,00,000 $ 128,00,000 $ 102,40,000 $ 81,92,000 PV factor @ 9% 0.9174 0.8417 0.7722 0.7084 0.6499 PV of withdrawal $ 183,48,000 $ 134,67,200 $   98,84,160 $   72,54,016 $ 53,23,981 Total PV of withdrawals $ 542,77,357 Excess of withdrawal over investment and appreciation $ -23,69,301

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.