Using the input data below, how do I calculate the breakeven point for each of the following
Fantastic news! We've Found the answer you've been seeking!
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 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% |
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ
Posted Date: