Chapter 4 Problems (60 Pts) Saved Saved Help Save & Exit Submit 1. Calculate the present value in two years using discount rates. INSERT points XB5 FILE HOME Calibri Paste B I 1 . Present Value with Different Discount Rates - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW A A . A. Alignment Number Conditional Format as Cell - Formatting Table Styles Styles U. eBook Clipboard Font F22 Print References 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.) $ 4,800 Future value Number of years Interest rate first year Interest rate second year 8.00% 7.00% Complete the following analysis. Do not hard code values in your calculations Value two years from today Value one year from today Present value ... Sheet1 ... + READY