Question: hello please help :) Complete the accompanying spreadsheet model for the costs in Year 1. A surgery center specialzes in high-risk cardiovascular surgery. The center
hello please help :)
Complete the accompanying spreadsheet model for the costs in Year 1. A surgery center specialzes in high-risk cardiovascular surgery. The center needs to forecast its proftability over the next tweee years to plan for captal growh projects. For the frot year, the hospinil anticipaces serving 1,200 patients, which is expected to grow by 3% per year. Based on current reimbursement formulas, aach patient provides an average biling of $130,000, which wit grow by 2 ts. each year. Howner, because of mannged care, the conter collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of bilitings. Fiand easts for salarins, withtet. and 50 on will amount to $20,000,000 in the frent year and are assumed to increase by 5% per year. Devalop a spreadiheet model to predict the net pretent value of proft over the next three yeirs. Use a discount mote of 4%

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
