Capital budget analysis | Management homework help

Overview

For this assignment, you have been provided with a spreadsheet containing projected numbers for two different patient services programs. You will need to download the Program Projections [XLSX] spreadsheet (attachment 2001) 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.

Resources

The Payback Period in Microsoft Excel https://www.linkedin.com/learning/investment-evaluation/payback-period-in-microsoft-excel?u=57878161 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 https://www.linkedin.com/learning/investment-evaluation/solution-6-choose-a-project-based-on-npv-irr-and-payback-period?u=57878161. video walks you through choosing a project based on NPV, IRR, and payback period.

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more