Scenario: KH Enterprises is considering the options of purchasing a smaller company or developing a new product to expand the existing company. The cost will be $24,500,000 for either option. The discount rate for both projects is 8%. Assume a 3.5% reinvestment rate for MIRR. Cash inflows for each option are below. Directions: (1) Calculate the Payback Period, Discounted Payback, Net Present Value (NPV), Internal Rate of Return (IRR), and Modified Internal Rate of Return (MIRR). KH Enterprises' senior management is trying to determine if they should purchase a smaller company or develop a new product. Both options require a $24,500,000 million investment. In the "Worksheet" tab, calculate Payback period, Net Present Value fNPVI. Intemal Rate of Retum (IRR), and Modifed Internal Rate of Return (MIRR) for both options. Finally, transfer you answers to the "Answer Summary" tab. management on which option the Excel file and Word document in Blackboard