Applying Excel - Present Value: Exercise (Part 2 of 2) For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario. Scenario A: Future value to be received $ 11,000 Future date received 5 years

Interest Rate 7% 11% 17%

Scenario B: Annual Cash Receipt $ 5,500 Number of Years 8 years

Interest Rate 7% 11% 17%

Required: a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)

Interest Rate Present Value 7% $ 45,102.17 11%

17%

b. A company is expecting to receive a stream of year-end annual cash payments over multiple years. Using the PV formula in Excel, what is the Present Value of that money at three different interest rates? (Round your answers to 2 decimal places.)

Interest Rate Present balue 7%

11%

17%