A 1. Calculate the present value in two years using discount rates. Present Value with Different Discount Rates - Excel FILE HOME INSERT PAGE LAYOUT Calibri 11 AA Paste BIU- Clipboard Font 2 21 J21 X fe A B C FORMULAS DATA 96 REVIEW VIEW Alignment Number Conditional Format as Cell Formatting Table Styles- Styles Cells Editing D E F G H Compute the present value of $4,800 paid in two years using the following discount rates: 8 percent in the first year and 7 percent in the second year. (Do not round intermediate calculations and round your answer to 2 decimal places.) 555 6 7 Future value 8 Number of years 9 Interest rate first year 10 Interest rate second year 4,800 2 8.00% 7.00% 11 12 13 14 15 16 17 18 Complete the following analysis. Do not hard code values in your calculations. Value two years from today Value one year from today Present value 19 20 21 READY Sheet1 E 5 x Sign In +100% 4