Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth

image text in transcribed

A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth projects. For the first year, the hospital anticipates serving 1,300 patients, which is expected to grow by 9% per year. Based on current reimbursement formulas, each patient provides an average billing of $130,000, which will grow by 4% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4% Complete the accompanying spreadsheet model for the costs in Year 1 D E F G H (Type whole numbers.) A 1 Collection % 2 Variable Cost % 3 Discount Rate % % % 4 5 Growth Rates % % % 6 Patients Served Average Billing Collected Amount Variable Costs Fixed Costs Total Collected Total Costs Total Profit 7 Year 1 A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth projects. For the first year, the hospital anticipates serving 1,300 patients, which is expected to grow by 9% per year. Based on current reimbursement formulas, each patient provides an average billing of $130,000, which will grow by 4% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4% Complete the accompanying spreadsheet model for the costs in Year 1 D E F G H (Type whole numbers.) A 1 Collection % 2 Variable Cost % 3 Discount Rate % % % 4 5 Growth Rates % % % 6 Patients Served Average Billing Collected Amount Variable Costs Fixed Costs Total Collected Total Costs Total Profit 7 Year 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions