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