Homework 3 - Excel A chic ta han File Home Insert Page Layout Formulas Data Review View Developer Help Acrobat Power Pivot Tell me what you want to do 2. Share Arial -A 10 AutoSum Wrap Text General 1 Normal Bad XL Insert Delete Tomat 47 Copy - Format Painter Peste BTU &A Merge & Center $ - % Neutral Conditional Format as Good Formatting Table Styles Clear Sort & Find & Filter - Select - Editing Font Alignment Number A1 f Ch18 Problern: 1 M N 0 0 R S T A C D H H J K 1 Ch18 Problem: I expect to earn 10 percent per year on my retirement investments. At the end of each of the next 40 years, want to put the same amount of money in my retirement portfolio. How much money do I need to put in each year if I want to have $2 million in my account when I retire? 2 Hint: Future value function FV (rate, nper, pmt, (pv], [type]) 3 4 years 40 5 yearly cont S 1.000.000 6 rate of return 0.1 7 8 available in 40 yrs $442 592 56 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Problemi Problem2 Problem3 Problem Problems Problem6 Problem7 Problem Problem + 1 1004