Chapter 11 Sample Problem and Solution

xlsx

School

University of Texas, Rio Grande Valley *

*We aren’t endorsed by this school

Course

6350.01V

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

3

Uploaded by PrivateMoonHyena43

Report
UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT Chapter 11 -- The Basics of Capital Budgeting Sampple Problem Braun Medical Center is considering an investment project which has the following cash flows: Year Cash Flow 0 -$1,000 1 $400 2 $300 3 $500 4 $400 The Center's CCC is 10 percent. What is the project's payback, internal rate of return, modified internal rate of return, and net present value? Copyright © 2020 Foundation of the American College of Healthcare Executives. Not for sale.
UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT Chapter 11 -- The Basics of Capital Budgeting Sample Problem Braun Medical Center is considering an investment project which has the following cash flows: Year Cash Flow 0 -$1,000 1 $400 2 $300 3 $500 4 $400 The Center's CCC is 10 percent. What is the project's payback, internal rate of return, modified internal rate of return, and net present value? ANSWER Step 1 - Identify the relevant data CCC 10% Step 2 - Calculate the cumultative cash flow and payback Cumulative Year Cash Flow Cash Flow 0 -$1,000 -$1,000 1 $400 -$600 2 $300 -$300 3 $500 $200 4 $400 $600 The cumulative cash flows indicate that the project breaks even in Year 3. Note that the project has a $300 cumulative shortfall going into Year 3. If we assume that the cash flows occur evenly during the year, then breakeven will occur $300 / $500 = 0.6 of the way into Year 3. Thus, the project's payback is 2.6 years. Step 3 - calculate the net present value NPV $260.43 =NPV(B21,C27:C30)+C26 The NPV formula includes a range of time periods 1 to 4 - the initial investment in time period 0 in cell C26 must be added outside of the NPV fornmula. Step 4 - calculate the IRR and MIRR A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
IRR 21.22% =IRR(C26:C30) MIRR 16.55% =MIRR(C26:C30,B21,B21) A B C D E F G H I 45 46 47
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help