Cases in Healthcare Finance, Case 20: Coral Bay Hospital.... Using the information provided, create a What-If Analysis in Excel for possible NPVs using the "black and white" template also provided. Please indicate what the Row and Column "input" variables would be if both Costs and Revenues stay constant under current conditions of a 3% inflation rate.

INPUT DATA: KEY OUTPUT: NPV IRR MIRR Payback $150,000 $200,000 $10,000,000 $5,000,000 20 $1,000 $918,000 $50,000 $36,000 $200 30% 30% 40.0% $1,000,000 $500,000 10.0% $875,020 12.9% 11.8% Land initial cost Land opportunity cost (and salvage value) Building/equipment cost Build/equipment salvage value Procedures per dav Average net patient revenue per procedure Labor costs Utilities costs Incremental overhead Supply cost ($/procedure) Inflation rate on net patient revenue Inflation rate on costs Tax rate Revenues lost from inpatient surgeries Reduction in inpatient surgery costs Cost of capital