Compare the net present value for each program

Assignment Help Business Management

Reference no: EM133781834

Homework: Business

Overview

For this homework, 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] 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. You will present your finding in a presentation.

Design a PowerPoint presentation for the capital budgeting committee that includes all of the following:

1) Create a brief 1-2 slide description of the proposed programs.

2) Develop a comparison between the cash flow projects of each program from Year 0 to Year 5. Highlight the differences.

3) Compare the results and interpretation of the discounted payback period between both programs.

4) Compare the net present value (NPV) for each program.

5) Compare the Internal rate of return (IRR) for each program.

6) Develop a recommendation for which program the capital budgeting committee should take into consideration. Include supporting rationale.

Resources

1) The video "Payback Period in Microsoft Excel?" walks you through computing a payback period in Microsoft Excel for a proposed capital investment.

2) The video "Solution 6: Choose a Project Based on NPV, IRR, and Payback Period?" walks you through choosing a project based on NPV, IRR, and payback period.

The specific course learning outcome associated with this homework is:

1) Analyze a capital budget for a program within a healthcare organization.

Reference no: EM133781834

Questions Cloud

Rationale behind torque variations : Rationale Behind Torque Variations: Why do you think different stock materials and configurations require specific torque settings?

Decision-making under certainty-decision-making under risk : Define what is meant by the terms: decision-making under certainty, decision-making under risk, and decision-making under uncertainty.

List the future spot exchange rates : BAFI1018 International Finance, RMIT University - Discuss and evaluate the types of exposures your firm may face as well as the other main concerns

Meeting the minimum wage standard for members : all organizations can afford to pay their employees large sums, but instead must rely on meeting the minimum wage standard for members.

Compare the net present value for each program : Compare the results and interpretation of the discounted payback period between both programs. Compare the net present value (NPV) for each program.

Overall environment of quality team : You learned about groups and teams and the behaviors that can increase productivity, efficiency, and the overall environment of a quality team.

To produce good machine learning model : To produce a good machine learning model, it is essential to begin with a good training dataset.

Effect change with policy by monitoring outcome data : How can this organization effect change with this policy by monitoring outcome data to support the importance of the organization's mission?

Know discrimination is illegal : We know discrimination is illegal. But diversity is not law, nor necessarily even policy within organizations.

User Account

All Pages