Calculating present values - Excel ? 23 6 K. FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In A Calibri 11 M ' ' A Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font X f B D E F G H 1 2 3 For each of the following compute the present value: 4 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 6 Present value 7 8 9 10 11 12 13 14 Years 13 4 29 40 Interest rate Future value 9% $ 15,451 7% $ 51,557 24% $ 886,073 35% $ 550,164