Appendix 33-A
Metropolis System financial report
1. Provide an overview of the financial status of the organization
2. Provide suggestions to the Senior Vice President to improve the financial status of the organization that can be considered in a future strategic plans
% change D=(C/B) 100 188% 0% -3% 0% -3% 50% 6% 33% 7% ASSETS March March 31, Change 31,20x3 20x02 C=B-A Current Assets: Cash and cash equivalents $1,150,000 $400,000 $750,000 Assets whose use is limited $825,000 $825,000 $0 Patient accounts receivable $8,700,000 $8,950,000 ($250,000) Less allowance for bad debts ($1,300,000) ($1,300,000) $0 Net Receivable on patient $7,400,000 $7,650,000 ($250,000) account Other Receivable $900,000 $100,000 $50,000 Inventories and supplies $900,000 $850,000 $50,000 Prepaid expense $200,000 $150,000 $50,000 Total current assets $10,625,000 $9,975,000 $650,000 assets whose use is limited Corporate fund depreciation $1,950,000 $1,800,000 $150,000 Under bond indenture $1,425,000 $1,475,000 ($50,000) agreement held by trustee Total assets whose use is $3,375,000 $3,275,000 $100,000 limited Less current portion ($825,000) ($825.000) $0 Net assets whose use is $2,550,000 $2,450,000 $100,000 limited Property, plant, and equipment $19,300,000 $19,200,000 $100,000 net Other assets $325,000 $375,000 (550,000) Total assets whose use is $32,800,000 $32,000,000 $800,000 limited 8% -3% 3% 0% 4% 1% -13% 3% SIGNIFICANT CHANGES IN ASSETS (GREATER THAN 10%) Cash and Cash Equivalent 188% Other Receivable 50% Prepaid Expense 33% Other assets -13% increase increase increase decrease LIABILITIES March 31, 20x03 Current Liabilities $525,000 Current maturities of long-term $4,900,000 debts Accounts payable and accrued $300,000 expenses Bond Interest payable $106,000 March 31, 20x02 $500,000 $5,300,000 Change CB-A $25,000 ($400,000) % change D=(C/B) 100 5% -8% $325,000 ($25,000) -8% $175,000 ($69,000) -39% -7% Reimbursement settlement $5,831,000 $6,300,000 ($469,000) payable total current liabilities $6,000,000 $6,500,000 ($500,000) Long term debt ($525,000) ($500,000) ($25,000) Less: Current Portion of Long- $5,475,000 $6,000,000 ($525.000) Term Debt Net Long-Term Debt $11,300,000 $12,300,000 ($1,000,000) Total Liabilities -8% 5% -9% -8% SIGNIFICANT CHANGES IN LIABILITIES (GREATER THAN 10%) Reimbursement settlement -39% Decrease payable PATIENT SERVICE REVENUE 20X3 Routine Revenue $9,850,000 28.06% Laboratory $7,375,000 21.01% Radiology and CT Scanner $5,825,000 16.60% Medical and Surgical Supply/IV $5,050,000 14.39% Operating Rooms $5,250,000 14.96% TOTAL OPERATING $35,100,000 REVENUE 20X2 $9,750,000 $7,300,000 $5,760,000 $5,000,000 $5,200,000 $34,600,000 28.18% 21.10% 16.65% 14.45% 15.03% 20X2 11.62% $4,200,000 12.44% SCHEDULE OPERATING 20X3 EXPENSES Routine Medical/Surgical $3,880,000 Expenses Laboratory $2,375,000 Medical and Surgical Supply/iv $1,800,000 General Expense $2,375,000 Employee Welfare $1,900,000 TOTAL OPERATING $33,400,000 EXPENSES 7.11% 5.39% 7.11% 5.69% $2,350,000 $1,750,000 $2,350,000 $1,950,000 $33,760,000 6.96% 5.18% 6.96% 5.78%