Please also include formulas

1. Calculate the present value in two years using discount rates. . ? le - 5 x Present Value with Different Discount Rates - Excel PAGE LAYOUT FORMULAS DATA REVIEW FILE HOME INSERT VIEW Sign In X Calibri - 11 in Paste BIU- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font > A1 A B C D E F F G H J 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.) 5 6 7 $ 8 Future value Number of years Interest rate first year Interest rate second year 4,800 2 8.00% 7.00% 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 15 16 17 Value two years from today Value one year from today Present value 18 19 20 21 Sheet1