Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Coral bay hospital case study

17/12/2020 Client: saad24vbs Deadline: 14 Days

CASE19

CASE 20 Instructor Version Copyright 2014 Health Administration Press

11/23/16

CORAL BAY HOSPITAL

Traditional Project Analysis

This case illustrates a complete capital budgeting analysis, including cash flow analysis,

and profitability measures. Note that the model extends to Column I.

The model consists of a complete base case analysis--no changes need to be made

to the existing MODEL-GENERATED DATA section. However, all values in the student

version INPUT DATA section have been replaced with zeros. Thus, students must determine

the appropriate input values and enter them into the model. These cells are colored red.

When this is done, any error cells will be corrected and the base case solution will appear.

Note that the student version does not contain any risk analyses, so students will have to

create their own if required by the case. Furthermore, students must create their own

graphics (charts) as needed to present their results.

The instructor version of the model contains an inflation table, sensitivity analysis,

and scenario analysis, which are not included in the student version. A graph of the sensitivity

analysis is contained on the second sheet.

INPUT DATA: KEY OUTPUT:

Land initial cost $150,000 NPV $875,020

Land opportunity cost (and salvage value) $200,000 IRR 12.9%

Building/equipment cost $10,000,000 MIRR 11.8%

Build/equipment salvage value $5,000,000 Payback 4.1

Procedures per day 20.0

Average net patient revenue per procedure $1,000

Labor costs $918,000

Utilities costs $50,000

Incremental overhead $36,000

Supply cost ($/procedure) $200

Inflation rate on net patient revenue 3.0%

Inflation rate on costs 3.0%

Tax rate 40.0%

Revenues lost from inpatient surgeries $1,000,000

Reduction in inpatient surgery costs $500,000

Cost of capital 10.0%

MODEL-GENERATED DATA:

Depreciation Schedule:

MACRS Deprec. End of Year

Year Factor Expense Book value

1 0.20 $2,000,000 $8,000,000

2 0.32 3,200,000 4,800,000

3 0.19 1,900,000 2,900,000

4 0.12 1,200,000 1,700,000

5 0.11 1,100,000 600,000

6 0.06 600,000 0

Net Cash Flows:

Project Cash Flows

0 1 2 3 4 5

Land opportunity cost ($200,000)

Building/equipment cost (10,000,000)

Net patient revenue (including inpatient loss) $4,000,000 $4,120,000 $4,243,600 $4,370,908 $4,502,035

Less: Labor costs 918,000 945,540 973,906 1,003,123 1,033,217

Cost savings on inpatients (500,000) (515,000) (530,450) (546,364) (562,754)

Utilities costs 50,000 51,500 53,045 54,636 56,275

Supplies 1,000,000 1,030,000 1,060,900 1,092,727 1,125,509

Incremental overhead 36,000 37,080 38,192 39,338 40,518

Depreciation 2,000,000 3,200,000 1,900,000 1,200,000 1,100,000

Income before taxes $496,000 ($629,120) $748,006 $1,527,447 $1,709,270

Taxes 198,400 (251,648) 299,203 610,979 683,708

Project net income $297,600 ($377,472) $448,804 $916,468 $1,025,562

Plus: Depreciation 2,000,000 3,200,000 1,900,000 1,200,000 1,100,000

Plus: Net land salvage value 180,000

Plus: Net building/equipment salvage value 3,240,000

Net cash flow ($10,200,000) $2,297,600 $2,822,528 $2,348,804 $2,116,468 $5,545,562

Cumulative net cash flow ($10,200,000) ($7,902,400) ($5,079,872) ($2,731,068) ($614,600) $4,930,962

(For payback calculation)

Profitability and Breakeven Measures:

Net present value (NPV) $875,020

Internal rate of return (IRR) 12.9%

Modified IRR (MIRR) 11.8%

Payback 4.1

Impact of Uncertain, Future Inflation on NPV:

Level of Net Patient Revenue Inflation

$875,020 0% 1% 2% 3% 4% 5% 6%

0% 557,808 724,065 893,501 1,066,160 1,242,091 1,421,339 1,603,952

1% 495,296 661,553 830,988 1,003,648 1,179,578 1,358,826 1,541,440

Level of Cost 2% 431,588 597,845 767,280 939,940 1,115,870 1,295,119 1,477,732

Inflation 3% 366,668 532,925 702,360 875,020 1,050,950 1,230,199 1,412,812

4% 300,518 466,775 636,210 808,870 984,801 1,164,049 1,346,662

5% 233,121 399,378 568,813 741,473 917,403 1,096,651 1,279,265

6% 164,458 330,715 500,150 672,810 848,741 1,027,989 1,210,602

Sensitivity Analysis:

(Note: This table does NOT automatically recalculate when input values are changed.)

Number of Avg Revenue Bldg/Equip

Procedures per Procedure Salvage Value

-30% (2,006,852) (2,727,320) $316,191

-20% (1,046,228) (1,526,540) 502,467

-10% (85,604) (325,760) 688,744

0% 875,020 875,020 875,020

10% 1,835,644 2,075,800 1,061,296

20% 2,796,268 3,276,580 1,247,573

30% 3,756,892 4,477,360 1,433,849

Scenario Analysis:

(Note: This section does NOT automatically recalculate when values in the INPUT DATA section are

changed. However, the probabilities within the section can be changed and the resulting values

will automatically be recalculated.)

Number of Avg Revenue Bldg/Equip

Case Probability Procedures per Procedure Salvage Value NPV

Worst 25.0% 10 $800 $4,000,000 ($5,501,433)

Most Likely 50.0% 20 1,000 5,000,000 875,020

Best 25.0% 25 1,200 6,000,000 6,651,083

100.0%

Expected NPV $724,922

Standard Deviation $4,299,184

Coefficient of Variation 5.9

END

equipment salvage value

CASE 20 Instructor Version Copyright 2014 Health Administration Press

11/23/16

CORAL BAY HOSPITAL

Traditional Project Analysis

This case illustrates a complete capital budgeting analysis, including cash flow analysis,

and profitability measures. Note that the model extends to Column I.

The model consists of a complete base case analysis--no changes need to be made

to the existing MODEL-GENERATED DATA section. However, all values in the student

version INPUT DATA section have been replaced with zeros. Thus, students must determine

the appropriate input values and enter them into the model. These cells are colored red.

When this is done, any error cells will be corrected and the base case solution will appear.

Note that the student version does not contain any risk analyses, so students will have to

create their own if required by the case. Furthermore, students must create their own

graphics (charts) as needed to present their results.

The instructor version of the model contains an inflation table, sensitivity analysis,

and scenario analysis, which are not included in the student version. A graph of the sensitivity

analysis is contained on the second sheet.

INPUT DATA: KEY OUTPUT:

Land initial cost $150,000 NPV $0

Land opportunity cost (and salvage value) $200,000 IRR 10.0%

Building/equipment cost $10,000,000 MIRR 10.0%

Build/equipment salvage value $2,651,286 Payback 4.1

Procedures per day 20.0

Average net patient revenue per procedure $1,000

Labor costs $918,000

Utilities costs $50,000

Incremental overhead $36,000

Supply cost ($/procedure) $200

Inflation rate on net patient revenue 3.0%

Inflation rate on costs 3.0%

Tax rate 40.0%

Revenues lost from inpatient surgeries $1,000,000

Reduction in inpatient surgery costs $500,000

Cost of capital 10.0%

MODEL-GENERATED DATA:

Depreciation Schedule:

MACRS Deprec. End of Year

Year Factor Expense Book value

1 0.20 $2,000,000 $8,000,000

2 0.32 3,200,000 4,800,000

3 0.19 1,900,000 2,900,000

4 0.12 1,200,000 1,700,000

5 0.11 1,100,000 600,000

6 0.06 600,000 0

Net Cash Flows:

Project Cash Flows

0 1 2 3 4 5

Land opportunity cost ($200,000)

Building/equipment cost (10,000,000)

Net patient revenue (including inpatient loss) $4,000,000 $4,120,000 $4,243,600 $4,370,908 $4,502,035

Less: Labor costs 918,000 945,540 973,906 1,003,123 1,033,217

Cost savings on inpatients (500,000) (515,000) (530,450) (546,364) (562,754)

Utilities costs 50,000 51,500 53,045 54,636 56,275

Supplies 1,000,000 1,030,000 1,060,900 1,092,727 1,125,509

Incremental overhead 36,000 37,080 38,192 39,338 40,518

Depreciation 2,000,000 3,200,000 1,900,000 1,200,000 1,100,000

Income before taxes $496,000 ($629,120) $748,006 $1,527,447 $1,709,270

Taxes 198,400 (251,648) 299,203 610,979 683,708

Project net income $297,600 ($377,472) $448,804 $916,468 $1,025,562

Plus: Depreciation 2,000,000 3,200,000 1,900,000 1,200,000 1,100,000

Plus: Net land salvage value 180,000

Plus: Net building/equipment salvage value 1,830,772

Net cash flow ($10,200,000) $2,297,600 $2,822,528 $2,348,804 $2,116,468 $4,136,334

Cumulative net cash flow ($10,200,000) ($7,902,400) ($5,079,872) ($2,731,068) ($614,600) $3,521,733

(For payback calculation)

Profitability and Breakeven Measures:

Net present value (NPV) $0

Internal rate of return (IRR) 10.0%

Modified IRR (MIRR) 10.0%

Payback 4.1

Impact of Uncertain, Future Inflation on NPV:

Level of Net Patient Revenue Inflation

$0

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Best Coursework Help
Top Essay Tutor
Helping Hand
Homework Guru
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$37 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$40 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$37 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Bhopal gas tragedy case study solution - Prisons for our bodies closets for our minds - Primary activities of a firm - Empirical formula of sodium carbonate - Structure and function of the hematologic system - Ms project pdf one page - Definition of urban sprawl - Database driven solution for tracking sales and inventory - Introduction to political science Assignment - Wpc dot gov in - I NEED THIS AFTER 6HRS (OVERDUE): Week 7 Case Study - Regression Model (Case Study #4) - Pwc compario - Accenta alarm tamper reset - Diameter of nickel in cm - Urban drama movies - Toyota hilux wiring diagram color codes - How to get answers to any homework - How much car can i afford for 400 a month - Sydney boys subject selection - How are crumple zones designed - Myra levine biography - Internal audit strategy example - Bsbmkg609 - 24 dunlop lane kurwongbah - Bsb51315 diploma of work health and safety - How to count male and female in excel - Jcg motors gold coast - A 1 page summary 1st draft. - Python Coding - Grade c company car - Spelling connections grade 8 answer key - BW Texas Gov't Unit 1 Topic 2-3 - How to create use case diagram in rational rose - Where the mountain meets the moon vocabulary - Suppose an investment offers to triple your money - Power Point Presentation - Gate turnaround at southwest airlines - Ned hanlon building butterfield street herston - Harford community college classes - Loftus and palmer schema theory - Social science inquiry advance and evolve over time - Ethical decision making in project management - Hyundai motors is considering three sites - Robin hood mission vision values goals - Compute stefani's total standard cost per unit - They say i say cliff notes - Chase bank bulverde and evans - How to install arulesviz package in r - Information system architecture definition - Medical ethics - Ecu joyner library database - Bill nye biodiversity video worksheet key - Depression is a disease of civilization stephen ilardi at tedxemory - Uci summer session office hours - Discusses a contemporary global manufacturing issue related to Industrial & Systems Engineering. - Next week super discount airlines has a flight - Examples of semi variable costs in healthcare - Case study of southwest airlines with solution - Lewisham disabled freedom pass - Spybot rootkit scan no admin in acl - Brand identity prism template word - Ctd module 3 table of contents - Ethical and Legal Issues Summary - Christchurch city council cemeteries - Flashback a brief history of film 6th edition ebook - The goals and promise of the sarbanes oxley act - Derive linear density expressions for - Approved inspection station hobart - What effect does lord shamash's intervention have on the epic - Economics help - The distance of uranus from the sun - Bbc bitesize latin gcse - Discussion 2: Polytrauma-wk7-2 - Risk Management Week 3 Discussion - READ & REPLY - Why do all nations face the problem of scarcity - Legal and Law aspects in Cybersecurity - Gomer oz dabar greek - History Reading Assignment - Lincoln hospital work experience - BUS 3 - Shadow health focused exam abdominal pain objective - Discussion-6 ME - Kaplan university course catalog - Effects of alcohol worksheet - Maurice raving beauty and the beast - Aspirin + naoh equation - Go math grade 1 answer key chapter 12 - Press on nail manufacturers - Leading and managing in nursing 7th ed - Dream chocolate case study answers - Britishgas co uk smartpayghelp - Wbs for a coffee shop - Baptist roman road to salvation - The hr planning process begins with - Marketing management - How much would a person weigh on jupiter - Sap business processes list - 1.1 10 practice complete your assignment - Kevin bridges meets chad hogan