For this assignment, you will be provided with a spreadsheet containing projected

For this assignment, you will be provided with a spreadsheet containing projected

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] 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 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 8–10 slides in length and include speaker notes with each slide.

Resources

The Payback Period in Microsoft Excel video walks you through computing a payback period in Microsoft Excel for a proposed capital investment.The Solution 6: Choose a Project Based on NPV, IRR, and Payback Period video walks you through choosing a project based on NPV, IRR, and payback perio

"96% of our customers have reported a 90% and above score. You might want to place an order with us."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.

Scroll to Top