1. Calculate the present value of the savings. All answers must be entered as a formula. Click OK to begin OK 7 Calculating Annuity Values - Excel FORMULAS DATA REVIEW VIEW HOME INSERT PAGE LAYOUT X De Calibri - 11 Cells Editing BIU - -A A % -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles ard Font F G H E D A B Your company will generate $68,000 in annual revenue each year for the next seven years from a new information database. If the appropriate interest rate is 8.5 percent, what is the present value of the savings? $ Annual savings # of years Interest rate on annuity 68,000 7 8.5% Complete the following analysis. Do not hard code values in your calculations. Your answers should be positive. 2 3 Present value son in