Required information [The following information applies to the questions displayed below.] This Applying Excel worksheet includes an explanation of the Present Value (PV) and Net Present Value (NPV) formulas. Use the PV and NPV formulas in Excel to solve for the three scenarios in the spreadsheet. After completing all three requirements, verify the amounts from each scenario below. For Scenario A: Check your formula setup by changing the "Future date received" to 5 years instead of 2 years, while keeping all other data the same from the original example. If working properly, at a Discount Rate of 10%, the Present Value should now $6,209.21. Check your formula setup by changing the "Annual Cash Receipt" to $7,500 instead of $5,000 years, while keeping all other data the same from the original example. If working properly, at a Discount Rate of 10%, the Present Value should now $28,430.90. Cor Scenario C: NPV of Investment $459.13 Check your formula setup by changing the "Initial Investment" to ($8,000) instead of ($5,000), while keeping all other data the same from the original example. If vorking properly, the Net Present Value should now be (\$2,540.87). Hint: For Scenario C, the Net Present Value includes the total NPV of all cash flows received in Years 1 through 5 , plus the cost of the initial investment to determin he final total NPV of the investment. Below are multiple scenarios where each company needs assistance to calculate the Present Value, Net Present Value and Payback Period. 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 discount rates shown below? Note: Your final answers should be displayed as a positive number. 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 discount rates shown below? Note: Your final answers should be displayed as a positive number. c. A company is planning to invest in a project over a 5-year period, but wants to know its financial implications. It expects the cash in-flow return on the investment to steadily increase over the 5 years. Using the information below, help determine the Total Net Cash Flows, the Net Present Value and the estimated Payback Period. Note: Estimate the payback period to the nearest year