Question: solve pro forma for highlighted: Assumptions for 2022 Proforma: Cape Fear Hospital 4% 4% increase in patient volumes Statement of Operations 4% 4% inflation expected
solve pro forma for highlighted:

Assumptions for 2022 Proforma: Cape Fear Hospital 4% 4% increase in patient volumes Statement of Operations 4% 4% inflation expected - medical supplies and other ope Year Ended September 30 (in thousands) Horizontal Analysis 6% 6% increase in personnel expense 2020 2020 2021 2021 for 2022 2022 2020-2021 2021-2022 4% Bad Debt expense 4% of Patient Service Revenue prior year vertical analysis current year vertical analysis Projections vertical analysis Other line items will not change Revenues: Patient Service Revenue net of Discounts and Allowances $ 66,962 103.81% S 75,290 103.61% #DIV/O! 8,328 S (75,290) Provision for Bad Debt S (2,457 ) -3.81% $ (2,625) -3.61% S #DIV/O! (168) S 2,625 Net Patient Service Revenue $ 64,505 100.00% S 72,665 100.00% S #DIV/O! 8,160 S (72,665) Operating Expenses: Personnel Expense $ 21,707 33.65% S 23,932 32.93% #DIV/O! 2,225 S (23,932) Medical Supplies Expense $ 15,047 23.33% S 16,589 22.83% #DIV/O! 1,542 S (16,589) Other Operating Expense 9,721 15.07% S 10,717 14.75% #DIV/O! 996 S (10,717) Depreciation Expense $ 2,625 4.07% S 2,725 3.75% #DIV/O! 100 S (2,725) otal Operating Expense $ 49,100 76.12% S 53,964 74.26% S #DIV/O! 4,864 S (53,964) ncome from Operations (EBIT) $ 15,405 23.88% S 18,701 25.74% S #DIV/O! 3,296 S (18,701) Other Income (expenses): Interest Expense S (1,322) -2.05% S (1,325) -1.82% #DIV/O! (3) S 1,325 Interest and Other Income, Net 159 0.25% S 165 0.23% #DIV/O! 6 S (165) Total Other Income (Expenses), N. S (1,163) -1.80% S (1,160) -1.60% S #DIV/O! 3 1,160 Net Income $ 14,242 22.08% S 17,541 24.14% S #DIV/O! 3.299 S (17,541)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
