1 Editing Clipboard Font Formatting Table Styles Styles D14 X f B 4A 1 C E 2 3 You are planning to make monthly deposits of $450 into a retirement account that pa interest compounded monthly. If your first deposit will be made one month from now, your retirement account be in 30 years? 4 5 6 7 Monthly deposit Times compounded per year Interest rate on annuity Number of years 450 12 10% 30 8 9 10 2 Complete the following analysis. Do not hard code values in your calculation should be positive. 3 4 Future value of annuity 5 6 . Calculating future values - Excel 2 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Arial - 12 M AN & A Paste Cells BIU- % Alignment Number Conditional Format as ce Formatting Table Styles Styles Editing Clipboard Font D14 v i B A E F G H 1 2 3 You are planning to make monthly deposits of $450 into a retirement account that pays 10 percent interest compounded monthly. If your first deposit will be made one month from now, how large will your relirement account be in 30 years? 4 5 6 7 3 Monthly deposit Times compounded per year Interest rate on annuity Number of years 450 12 10% 30 9 10 11 12 Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. 13 Future value of annuity 15 16 17 18