Hello,

I would like to know if I'm doing this correctly (I calculated yearly savings) and how do I calculate Savings at age 65 (future value, top in excel) ans Future Value at age 65 (bottom of excel) please explain step by step

13. (FV annuity) Michael is considering his consumption habits, trying out how to save money. He realizes that he could save $10 every week ordering regular coffee instead of latte at the local coffee shop. Since been a cup of coffee every work day (5 days a week), every week (52 a. If Michael is 25 today and retires at age 65, how much money will have accumulated from savings on coffee versus latte? Assume occur at the the weekly interest rate is 0.1% and that the savings realized he had more wasteful habits, and he made a list of possit savings to see how much richer he could be at age 65. What are the the money to cFind the answers to parts rate is 7 weers year), this works out to be quite a sum. of each week. rewards to Michael's frugality? B D 10 Exercise 13 b 11 Weekly interest rate 12 FFV($B$11,52,-815 0.10% Weekly Yearly savings savings Future value at age 65 13 Item 14 15 Latte versus regular coffee 16 Deli versus brown bag lunch 17 Excess alcohol 533.48 18 Cigarettes 19 Candy 20 Excess junk food 21 Cell phone (chat vs. needed calls) 22 Wasted groceries 23 Restaurant fast food vs. eat at home 24 Wasted energy: heat, AC, lights 25 Movies versus books 26 Expensive cable TV 10.00 25.00 10.00 11.00 5.00 10.00 6.00 27 Wasted gasoline on excessive trips, etc. 28 Wasteful spending at mall 29 Money saved by time Michael is 65 7.00 30.00 12.00 10.00 13.00 8.00 10.00 167.00 o fo D15 B MICHAEL SAVES MONEY 1 2 Exercise 13 a 3 Weekly interest rate 0.10% 4 Weekly Latte savings 10.00 5 Years until age 65 40