Problem: Two plans have been proposed for accumulating money for capital projects at Thunder Bay Lighting. One idea is to put aside $10000 per year, independent of growth. The second is to start with a smaller amount, $8000 per year, but to increase this in proportion to the expected company growth. The money will accumulate interest at 10%, and the company is expected to grow about 5% per year. Which plan will accumulate more money in 10 years?
Illustrate all intermediate computations and transfer results from Excel to Word but include both files.