A surgery center specializes in high-nsk cardiovascular surgery. The center needs to forecast is profitabity over the next three years to plan for capitat growit projects. For the first year, the hospitat anticipates serving 1.400 patients, Which is expected to grow by 7% per year. Based on current reimbursement formula each patvent provides an average billing of $130,000, which will grow by 2% each year. However, because of managed care, the centercollects only 25% of ballings. Varlable costs for supplies and drugs are calculated to be 10% of bilings. Foxed costs for salanes, uthities, and 50 on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year Develop a spreadsheel model to predicl the net present value of profit over the nexd three years. Use a discount rale of 4% The net present value of pront over the next three years 15$ Time Remaining:01.27.04 Next