ou are offered three annuities (these make equal payments over a specific period). Using an annual 3.5% discount rate, calculate each annuity's price: # Price ($) Payments ($/month) Life (yrs.) 1 ? 95 4 2 ? 100 (growing @1.5%/yr.) 4 3 ? 55 (growing @1.5%/yr.) Forever

File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share X LUI! . AA Times New Roman ~ 12 = Insert General Wrap Text ILI IL Fm 47 0 W e Paste 9X Delete BIU + + $ - % Merge & Center 60 100 .00 0 Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Format V Undo Clipboard Font Alignment Number Cells Editing Analysis D7 1 X fx A B D E F F G H I I J K L M N 0 O P P Q 1 3 1 95 3.50% 0% Annuity 2 100 3.50% 3% 55 3.50% 3.50% 2 3 Payments 4 Discount rate 5 Growth rate 6 Price to be paid 7 Cash Flows: 8 1 9 2 2 10 3 11 4 12 5 13 6 6 14 7 15 8 16 9 17 10 18 11 19 12 20 13 21 14 22 15 23 16 24 17 25 18 26 19 27 20 Prob. 1 Prob. 2 Prob. 3 Prob. 4 . Prob. 5| V. JAN '22 + Ready Display Settings + 100%