A ... B C Present value Sheet1 For each of the following, compute the present value: D Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. . + E Years F 13 4 29 40 Interest rate Future value 9% $ 15,451 7% $ 51,557 24% $886,073 35% $ 550,164 G H Paste Clipboard G F10 1 2 3 4 in 5 L 6 7 8 9 10 11 12 13 14 15 16 A Arial B I U m MERE Font SSSS x C 12 T Present value A A 1,975 6,734 fox 81,346 192,050 G D For each of the following, compute the future value: % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. E 11 7 F Years Interest rate Future value 13% 9% 12% 6% 14 8 G HI Cells Editing H < Y L 1 2 ~ 34 in 5 6 7 00 8 9 10 11 12 13 14 15 16 A B $ EA GA GA GA $ Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. $ C Sheet1 Present value Years 181 335 D 48,000 40,353 + E 4 18 19 25 Interest rate Future value 297 1,080 185,382 531,618 $ LA CASA C F $ $ G H In A1 L 2 B 4 5 5 7 3 9 0 1 2 3 4 5 6 A B $ SASSAS $ $ $ X Solve for the unknown number of years in each of the following: Complete the following analysis. Do not hard code values in your calculations. C Sheet1 Present value 560 810 18,400 21,500 *** fix + D E F Years Interest rate Future value 6% $ 9% $ 11% S 13% $ 4 1,389 1,821 289,715 430,258 (9) G H