all answers must be answered as a formula.

Calculating Annuity Cash Flows - Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 Conditional Format as Cell I U Alignment Number Paste Cells Editing Formatting Table Styles " Styles Clipboard Font fe D If you put up $45,000 today in exchange for a 6.25 percent, 15-year annuity, what will the annual cash flow be? 4 45,000 Initial investment Interest rate on annuity 6.25% # of years 15 9. Complete the following analysis. Do not hard code values in your calculations. Your answers should be positive. 10 11 12 Annuity payment 13 14 15 16 17 Sheet1 READY 100% Attempt(s) Hint Show Me 2. 3