Get answer

You’re a member of the financial services department at Benson Regional Medical Center. The chief financial officer and chair of the capital budgeting committee, Dana Foster, has requested that you perform some capital analysis of two proposed patient service programs.1. Start by downloading the Week 8 Discussion Spreadsheet [XLSX].2. Use the spreadsheet to find the information needed to complete a net present value (NPV), internal rate of return (IRR), and a discounted payback period for proposed Programs A and B.3. Once you have completed the capital budgeting analyses, prepare a narrated PowerPoint presentation that provides:1. A brief description of the proposed programs (A & B)*.2. The cash flows projections for each option from Year 0 through Year 5.3. The results and interpretation of the discounted payback period.4. Net present value (NPV).5. Internal rate of return (IRR).4. In addition, you will be expected to state which program you would like to move forward to the full Capital Budgeting Committee for their consideration with supporting rationale. The presentation should be limited to 10 minutes. Submit the spreadsheet along with the slide deck. Make each slide clear with speaker notes. It should be 6×6, with no overlapping sentences.*You get to create the program options descriptions.