Question: Using the input data below, how do I calculate the breakeven point for each of the following in excel: Procedures per day, Net revenue per

Using the input data below, how do I calculate the breakeven point for each of the following in excel: Procedures per day, Net revenue per procedure, supply cost?

INPUT DATA: KEY OUTPUT:
Land initial cost $150,000 NPV $1,200,857
Land opportunity cost (and salvage value) $200,000 IRR 12.9%
Building/equipment cost $10,000,000 MIRR 11.5%
Building/equipment salvage value $5,000,000 Payback 4.1
Procedures per day 20
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 9.0%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!