all answers must be answered as a formula.

Calculating Annuity Values - Excel Sign In FILE OE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Arial 14 Conditional Format as Cell Paste Alignment Number Cells Editing Formatting Table Styles Clipboard Font Styles fe C1 B D 2. You want to have $75,000 in your savings account 12 years from now, and you're prepared to make equal annual deposits into the account at the end of each year. If the account pays 6.8 percent interest, what amount must you deposit each year? 6. Desired amount 75,000 # of years 12 Interest rate 6.8% 10 11 Complete the following analysis. Do not hard code values in your answers. Your answer should be a positive value. 12 13 14 Annual deposit 15 16 17 18 Sheet1 +, READY 100% 4)