For this assignment, you will be provided with a spreadsheet containing projected numbers for two different patient services programs. You will need to download the Program Projections [XLSX] Download Program Projections [XLSX]spreadsheet and use it to conduct your analysis.
Instructions
You are 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.
You have been provided with a spreadsheet that covers much of the projected financials for each of the proposed programs. Your task is to perform an analysis of that information and provide your recommendation to the capital budgeting committee as to which program they should pursue.
You have been asked to create a presentation to present your findings to the capital budgeting committee.
Using the provided spreadsheet, complete a capital budgeting analysis on the information provided in the spreadsheet. Specifically, you will need to identify a net present value (NPV), internal rate of return (IRR), and a discounted payback period for proposed Program