please be very specific with the answers thank you due today pls !!!

A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next throe years to plan for capital growth projecte. For the. first year, the hospital anticipates serving 1,300 patients, which is expected to grow by 7% per year, Based on curront reimbursement formulas, each patient provides an averago billing of $120,000, which will grow by 3% 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. Foxed costs for solaries, utitities, 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 spreadabeot model for the costs in Year 1. (Type whole numbers.) (Round to the nearest cent as needed.)