For this assignment, you will be provided with a spreadsheet containing projected numbers for two different patient services programs. You will need to

 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 #1 and Program #2. You will present your finding in a presentation.

  • Design a PowerPoint presentation for the capital budgeting committee that includes all of the following:
    • Create a brief 1-2 slide description of the proposed programs.
    • Develop a comparison between the cash flow projects of each program from Year 0 to Year 5. Highlight the differences.
    • Compare the results and interpretation of the discounted payback period between both programs.
    • Compare the net present value (NPV) for each program.
    • Compare the Internal rate of return (IRR) for each program.
    • Develop a recommendation for which program the capital budgeting committee should take into consideration. Include supporting rationale.

Formatting Requirements

The presentation should be 8-10 slides in length and include speaker notes with each slide.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Please Read chapter1Chapter 1 Reader’s QuestionsInstructions. Please create and

Please Read chapter1 Chapter 1 Reader’s Questions Instructions. Please create and submit  five questions from your reading for this module.  The format of the questions  must be true/false, multiple choice with 3+ answer choices,  or matching.  Each question must be in a different format. For example, you  cannot choose two true/false questions. You must

  Students will select one of the following topical areas in which they will develop their simulation (a “pretend” scenario). The topical areas

  Students will select one of the following topical areas in which they will develop their simulation (a “pretend” scenario). The topical areas are:             Martial or couple relational conflict             Gender or Racial Discrimination or Prejudice related conflict             Bullying at School conflict             Co-worker conflict             Police and public

Write a 150 word response 1 reference/intext citation Due 5/29/2025 Campbell   As noted by the Indeed Editorial Team (2025), ESFJ stands for

Write a 150 word response 1 reference/intext citation Due 5/29/2025 Campbell   As noted by the Indeed Editorial Team (2025), ESFJ stands for extroverted, sensing, feeling, and judging. Those who fall under this category—sometimes referred to as the “provider,” “consul” or “caregiver”—are typically outgoing, organized, tender-hearted, and loyal. Their extroverted

Write a 150 word response 1 reference/intext citation Due 5/29/2025 Knecht   As noted by the Indeed Editorial Team (2025), ESFJ stands for

Write a 150 word response 1 reference/intext citation Due 5/29/2025 Knecht   As noted by the Indeed Editorial Team (2025), ESFJ stands for extroverted, sensing, feeling, and judging. Those who fall under this category—sometimes referred to as the “provider,” “consul” or “caregiver”—are typically outgoing, organized, tender-hearted, and loyal. Their extroverted