WGU D513 Corazon y Alma Health Pro Forma Operating Budget | 2025 Update with complete solutions.

Corazon y Alma Health Pro Forma Operating Budget
Table 1: Income Statement for All Owned Operations
Operating Revenue, Operating Budget Actual $ Variance
Expenses, Nonoperating Items, and
Noncash Items
Operating Revenue Header Operating Revenue Header Operating Revenue Header Row –
Operating Revenue Row – Intentionally Left Row – Intentionally Left Intentionally Left Blank
Blank Blank

Inpatient Charges $47,500,000 $45,000,000 ($2,500,000)
Outpatient Charges $35,000,000 $40,500,000 $5,500,000
Total Charges $82,500,000 $85,500,000 $3,000,000
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Deductions from Charges - ($33,000,000) ($34,200,000 ($1,200,000)
Discounts and Allowances )
Deductions from Charges - Charity ($6,187,500) ($6,412,500) ($225,000)
Care
Total Deductions ($39,187,500) ($40,612,500 ($1,425,000)
)
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Net Patient Revenue $43,312,500 $44,887,500 $1,575,000
Other Operating Revenues $2,500,000 $2,350,000 ($150,000)
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Total Operating Revenues $45,812,500 $47,237,500 $1,425,000
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Operating Expenses Operating Expenses Operating Expenses Header Row –
Operating Expenses Header Row – Intentionally Header Row – Intentionally Intentionally Left Blank
Left Blank Left Blank

Salaries $25,000,000 $25,050,000 ($50,000)
Benefits $6,250,000 $6,262,500 ($12,500)
Insurance $550,000 $550,000 $0
Supplies $4,125,000 $4,275,000 ($150,000)
Purchased Services $3,500,000 $3,750,000 ($250,000)
Utilities $125,000 $135,000 ($10,000)
Rent $35,000 $35,000 $0
Repairs and Maintenance $25,000 $35,000 ($10,000)
Interest $180,000 $200,000 ($20,000)
Other $175,000 $155,000 $20,000
Bad Debt $4,125,000 $4,275,000 ($150,000)
Total Operating Expenses $44,090,000 $44,722,500 ($632,500)
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Operating Income $1,722,500 $2,515,000 $792,500
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Nonoperating Items Header Nonoperating Items Header Nonoperating Items Header Row –
Nonoperating Items Row – Intentionally Left Row – Intentionally Left Intentionally Left Blank
Blank Blank

Accessibility Review Completed and Approved for Distribution and Use.
Accessibility, Production & Operations [HC - Based on review completed 05/30/24.]

, Operating Revenue, Operating Budget Actual $ Variance
Expenses, Nonoperating Items, and
Noncash Items
Investment Income $825,875 $991,050 $165,175
Donations and Fund Raising $175,000 $155,000 ($20,000)
Total Nonoperating Gain (loss) $1,000,875 $1,146,050 $145,175
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Operating Income Before Noncash $2,723,375 $3,661,050 $937,675
Items
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Noncash Items Header Noncash Items Header Noncash Items Header Row – Intentionally
Noncash Items Row – Intentionally Left Row – Intentionally Left Left Blank
Blank Blank

Depreciation ($342,000) ($332,000) ($10,000)
Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank Intentionally Left Blank

Net Income $2,381,375 $3,329,050 $947,675


Table 2: Cash Balance (Income Statement for All Owned Operations)
Cash Balance Amount
Beginning Cash Balance (1/1) $1,071,450
Operating Income Before Noncash Items $3,661,050
Ending Cash Balance (12/31) $4,732,500


Table 3: Ratio Analysis - Total Margin (Income Statement for All Owned
Operations)
Net Income, Operating Revenues + Amount
Nonoperating Gain, and Total Margin
Net Income/ $3,329,050
Total Operating Revenues + Nonoperating Gain $48,383,550
Total Margin: 6.88%


Table 4: Ratio Analysis - Operating Margin (Income Statement for All Owned
Operations)
Operating Income, Operating Revenues, and Amount
Operating Margin
Operating Income/ $2,515,000
Total Operating Revenues $47,237,500
Operating Margin: 5.32%


Accessibility Review Completed and Approved for Distribution and Use.
Accessibility, Production & Operations [HC - Based on review completed 05/30/24.]