2.5 points eBook Print References All answers must be entered as a formula. Click OK to begin. OK ? x WOHS, FILE HOME Calculating annuity values - Excel FORMULAS DATA REVIEW - 2 Sign In INSERTPAGE LAYOUT VIEW 31 Calibri - 11 A A Paste B IU - 22- A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Editing Clipboard Font 2.5 points A1 E F G H I eBook Print References If you deposit $4,000 at the end of each of the next 20 years into an account paying 9.7 percent interest, how much money will you have in the account in 20 years? How much will you have if you make deposits for 40 years? 4,000 Annual deposit Number of years Interest rate on annuity Number of years 9.7% 40 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Future value for 20 years Future value for 40 years All answers must be entered as a formula. Click OK to begin. OK $ 4,700 Payment for X Number of years for X 32 S 6,700 Payment for Y Number of years for Y points 5% Discount rate Discount rate 15% eBook Print Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. References Value of X at 5% Value of Y at 5% Value of X at 15% Value of Y at 15% ... Sheet1 ... + READY U 0 -- + 100% Hint Attempt(s) All answers must be entered as a formula. Click OK to begin. OK ? - X Calculating EAR - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri 11AA 10- A Alignment Number B I U - 2.5 points Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 eBook Print References Find the EAR in each of the following cases: Complete the following analysis. Do not hard code values in your calculations. Times compounded per year Effective rate (EAR) Stated rate (APR) 7% 17% 13% 12 365