Health Care Finance

complete the following assignment, MUST HAVE THE FORMULAS IN THE EXCEL BOXES. There are 3 different tabs 2.1, 2.2 and 2.3 DUE TODAY 2/7/2021 by 7 pm Central Standard time. Below is tab 2.1

 CHAPTER 5 HOMEWORK - COSTING AND PROFIT ANALYSISHomework 2.1, Chapter 5Using the data below, answering the following questions:Fixed costs$23,750,000 Variable cost/day$525 Charge (rev)/day$2,575 Inpatient days14,500 

a. Construct the hospital's base case projected P&L statementb.

 What is the hospital's breakeven point (volume / patient days needed to breakeven)?

c. What is the economic breakeven (volume required ) to provide a profit of $1,500,000?

d. What is the total contribution margin if volume decreases by 20%?

e. Based on the scenario in d., if fixed costs remain the same, what is the hospital's profit or loss?