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 :)
hello please help :) Complete the accompanying
hello please help :) Complete the accompanying
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 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 General Management Questions!