(FV annuity) Michael is considering his consumption habits, trying to figure out how to save money. He realizes that he could save $10 every week by ordering regular coffee instead of latte at the local coffee shop. Since he buys a cup of coffee every work day (5 days a week), every week (52 weeks a year), this works out to be quite a sum.

a. If Michael is 25 today and retires at age 65, how much money will he have accumulated from savings on coffee versus latte? Assume that the weekly interest rate is 0.1% and that the savings occur at the end of each week.

b. Michael was astounded at the answer to part a of this problem. He realized he had more wasteful habits, and he made a list of possible savings to see how much richer he could be at age 65.

What are the rewards to Michael’s frugality?

Transcribed Image Text:

10 11 12 A B C D Exercise 13 b Weekly interest rate 0.10% FFV($B$11,52,-B15) Weekly Yearly Future value at age 13 34 Item savings savings 65 14 15 Latte versus regular coffee 16 Deli versus brown bag lunch 17 Excess alcohol 10.00 533.48 25.00 10.00 18 Cigarettes 11.00 19 Candy 5.00 20 Excess junk food 10.00 21 Cell phone (chat vs. needed calls) 6.00 22 Wasted groceries 7.00 23 Restaurant: fast food vs. eat at home 30.00 24 Wasted energy: heat, AC, lights 12.00 25 Movies versus books 10.00 26 Expensive cable TV 13.00 27 Wasted gasoline on excessive trips, etc. 28 Wasteful spending at mall 8.00 10.00 29 Money saved by time Michael is 65 167.00