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