Help Save & This question will be sent to your instructor for grading. 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 Discount Rate 10% Present Value $8,264.46 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 be $6,209.21 For Scenario B: Discount Rate 10% Present Value $18,953.93 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 be $28,430.90 For Scenario C NPV of Investment $459.13