posted the question half so that the image would be clear and the chart last so it could be seen

11.4.31 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 gr expected to grow by 8% per year. Based on current reimbursement formulas, each patient provides an average billing of $120,000, which will grow by 2% 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 ir 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. (Type whole numbers.) C D E F G H 1 Collection % % Variable Cost % % 3 Discount Rate % 2 Growth Rates Question Help east 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 provides an average billing of $120,000, which will grow by 2% each year. However, because of managed care, the center collects only 25% of sts 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 ate of 4%. G H A surgery center specializes in high-risk cardiovascular surgery. The conter needs to forecast its profitability over the next three years to plan fom expected to grow by 8% per year. Based on current reimbursement formulas, each patient provides an average billing of $120,000, which will gm 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 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. (Type whole numbers.) B Collection % % 2 Variable Cost % % 3 Discount Rate % D H 1 4 5 Growth Ratos % % Patients Served Average Billing 6 Collected Amount Variable Costs Fixed Costs Total Collected Total Costs Total Profit 7 Year 1 Enter your answer in the edit fields and then click Check