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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
