- Have any questions? Contact us free of charge
- 233245354352
- 5432431
- [email protected]
FM007_Assessment_JirannaFinancials1.xlsx
FM007_Assessment_JirannaFinancials1.xlsx
Income Statement
| Jiranna Healthcare Income Statement December 31, 2013 (in thousands) | |||||
| 2009 | 2010 | 2011 | 2012 | 2013 | |
| Gross patient services revenues (non-GAAP) | 8,870 | 9,490 | 10,400 | 11,200 | 12,050 |
| Less deductions from revenues (non-GAAP) | (780) | (890) | (1,000) | (1,500) | (1,600) |
| Net patient service revenues | 8,090 | 8,600 | 9,400 | 9,700 | 10,450 |
| Other operating revenues | 519 | 633 | 679 | 717 | 980 |
| Total operating revenues | 8,609 | 9,233 | 10,079 | 10,417 | 11,430 |
| Operating expenses | |||||
| Salaries and wages | 5,497 | 5,678 | 5,890 | 6,170 | 6,800 |
| Supplies | 823 | 850 | 855 | 890 | 905 |
| Utilities | 558 | 576 | 590 | 595 | 620 |
| Insurance | 44 | 46 | 49 | 54 | 70 |
| Depreciation | 168 | 173 | 175 | 178 | 188 |
| Interest | 142 | 146 | 154 | 179 | 198 |
| Bad debts | 363 | 375 | 400 | 455 | 500 |
| Other operating expenses | 987 | 1,299 | 1,560 | 1,300 | 1,350 |
| Total operating expenses | 8,582 | 9,143 | 9,673 | 9,821 | 10,631 |
| Operating income | 27 | 90 | 406 | 596 | 799 |
| Nonoperating income | 154 | 195 | 245 | 220 | 290 |
| Excess of revenue over expenses | $ 181 | $ 285 | $ 651 | $ 816 | $ 1,089 |
| Change in net assets | |||||
| Unrestricted | $ 181 | $ 285 | $ 651 | $ 816 | $ 1,089 |
| Temporarily restricted | – | – | – | – | – |
| Permanently restricted | – | – | – | – | – |
| Total change in net assets | 181 | 285 | 651 | 816 | 1,089 |
Balance Sheet
| Jiranna Healthcare Balance Sheet December 31, 2013 (in thousands) | |||||
| 2009 | 2010 | 2011 | 2012 | 2013 | |
| Current Assets | $ 280 | $ 124 | $ 136 | $ 295 | $ 355 |
| Cash | 30 | 45 | 50 | 75 | 88 |
| Receivables, net | 1,340 | 1,536 | 1,700 | 1,896 | 2,400 |
| Inventory | 140 | 175 | 250 | 276 | 266 |
| Prepaid expenses | 40 | 32 | 40 | 53 | 78 |
| Total Current Assets | 1,830 | 1,912 | 2,176 | 2,595 | 3,187 |
| Total Assets | |||||
| Short-term investments | 600 | 1,010 | 1,200 | 1,300 | 1,510 |
| Plant and equipment | 6,580 | 6,780 | 6,900 | 7,200 | 7,500 |
| Less accumulated depreciation | -1,660 | -1750 | -1,800 | -1,950 | -2,350 |
| Plants and equipment, net | 4,920 | 5,030 | 5,100 | 5,250 | 5,150 |
| Total Assets | $ 7,350 | $ 7,952 | $ 8,476 | $ 9,145 | $ 9,847 |
| Current liabilities | |||||
| Accounts payable | 370 | 302 | 356 | 370 | 375 |
| Accrued expenses payable | 220 | 208 | 212 | 210 | 215 |
| Deferred revenues | 60 | 77 | 87 | 87 | 94 |
| Total Current liabilities | 650 | 587 | 655 | 667 | 684 |
| Long-term liabilities | 2,400 | 3,000 | 3,300 | 3,500 | 3,750 |
| Total Liabilities | 3,050 | 3,587 | 3,955 | 4,167 | 4,434 |
| Net assets | |||||
| Unrestricted | 3,000 | 3,285 | 3,221 | 3,678 | 4,113 |
| Temporarily restricted | 700 | 700 | 700 | 700 | 700 |
| Permanently restricted | 600 | 600 | 600 | 600 | 600 |
| Total Net Assets | 4,300 | 4,585 | 4,521 | 4,978 | 5,413 |
| Total Liabilities and Net Assets | 7,350 | 8,172 | 8,476 | 9,145 | 9,847 |
Cash Flows
| Jiranna Healthcare Cash Flows, 2013 (in thousands) | ||
| Cash Flows from Operating Activities | ||
| Cash received from patient and third-party payers | $ 10,671 | |
| Cash received from operating revenue sources | 800 | |
| Cash received from nonoperating revenue sources | 270 | |
| Cash payments to employees | (5,600) | |
| Cash payments to suppliers of goods and services | (4,800) | |
| Net cash flow from operating activities | $ 1,341 | |
| Cash flows from Investing Activities | ||
| Cash payments for purchase of plant assets | (1,200) | |
| Cash payments for purchase of long-term investments | (670) | |
| Proceeds from sales of plant assets | 80 | |
| Proceeds from sale of long-term investments | 60 | |
| Net cash flow from investing activities | (1,730) | |
| Cash flows from Financing Activities | ||
| Proceeds from issuance of 6% bonds payable | 4,000 | |
| Principal payments on long-term debt | (300) | |
| Cash payments to retire 7% bonds payable | (3,200) | |
| Net cash flow from financing activities | 500 | |
| Net increase/(decrease) in cash | $ 111 | |
Captial Project
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Nurse Triage Salaries | $ 523,800 | $ 549,990 | $ 577,490 | $ 606,364 | $ 636,682 | $ 668,516 |
| Forecasted ER Cost Reductions | $ 400,000 | $ 800,000 | $ 848,000 | $ 900,577 | $ 955,512 | $ 1,013,798 |
| New IT Specialist's Salary | $ 150,000 | $ 154,500 | $ 159,135 | $ 163,909 | $ 168,826 | $ 173,891 |
| Costs of Facility Renovations | $ 30,000 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 |
| Necessary Capital Equipment Purchases | $ 117,000 | $ 3,510 | $ 3,510 | $ 3,510 | $ 3,510 | $ 3,510 |
| Net Cash Flow: | ||||||
| Present Values of Net Cash Flows: | ||||||
| Net Present Value: | ||||||
| Internal Rate of Return (IRR): | ||||||
| Modified Internal Rate of Return (MIRR): | ||||||
| Payback Period (# years): | ||||||
| Discounted Payback Period (# years): |
Variance Analysis Case Study
| Jiranna HealthcareExpenses Worksheet, Mid-Year Review | ||||||||
| Outpatient | ||||||||
| Outpatient Product Line | Unit Expense (FY10) | Actual Units (FY10) | Total OP Expenses (FY10) | Unit Forecast (FY11) | Unit Expence (Budget FY11) | FY11 Budget (FY10+6% Inflation) | Acutal Mid Year Units (FY11) | Actual OP Expenses (FY11 YTD) |
| CARDIOLOGY | $ 5,478.81 | 645 | $ 3,533,832 | 677 | $5,807.54 | $ 3,931,704 | 197 | $ 1,144,085 |
| ENDOCRINOLOYGY | $ 5,478.81 | 217 | $ 1,188,902 | 228 | $5,807.54 | $ 1,324,119 | 112 | $ 650,444 |
| FAMILY MED | $ 5,476.81 | 1,105 | $ 6,051,875 | 1,161 | $5,802.92 | $ 6,737,188 | 636 | $ 3,690,656 |
| GYN | $ 5,478.81 | 208 | $ 1,139,592 | 219 | $5,794.28 | $ 1,268,947 | 116 | $ 672,136 |
| ENT | $ 5,475.81 | 690 | $ 3,778,309 | 724 | $5,804.36 | $ 4,202,356 | 421 | $ 2,443,635 |
| MENTAL HEALTH | $ 498.78 | 1,287 | $ 641,930 | 1,351 | $528.71 | $ 714,283 | 736 | $ 389,128 |
| NEWBORN | $ 5,478.81 | 698 | $ 3,824,209 | 733 | $5,807.54 | $ 4,256,926 | 433 | $ 2,514,664 |
| OB | $ 5,478.81 | 1,430 | $ 7,834,698 | 1,501 | $5,807.54 | $ 8,717,115 | 868 | $ 5,040,943 |
| ORTHO | $ 5,478.81 | 601 | $ 3,292,765 | 631 | $5,807.54 | $ 3,664,557 | 274 | $ 1,591,266 |
| PEDIATRICS | $ 5,477.81 | 124 | $ 679,248 | 130 | $5,806.48 | $ 754,842 | 72 | $ 418,066 |
| PODIATRY | $ 5,478.81 | 2,050 | $ 11,231,561 | 2,152 | $5,807.54 | $ 12,497,823 | 800 | $ 4,646,031 |
| Total Expenses | $55,281 | 9,055 | $43,196,921 | 9,507 | $58,582 | $48,069,860 | 4,665 | $23,201,056 |
| Jiranna HealthcareRevenues Worksheet, Mid-Year Review | ||||||||
| Outpatient | ||||||||
| Outpatient Product Line | Unit Price (FY10) | Actual Units (FY10) | Total OP Revenue (FY11) | Unit Forecasted For (FY11) | Unit Price (Budget FY11) | Projected OP Revenue For FY11 | Actual (FY11 YTD) | Actual OP Revenue (FY11 YTD) |
| CARDIOLOGY | $ 6,118.73 | 645 | $ 3,946,580.85 | 677 | $6,118.73 | $ 4,142,380 | 197 | $ 1,205,390 |
| ENDOCRINOLOYGY | $ 6,103.65 | 217 | $ 1,324,492.05 | 228 | $6,103.65 | $ 1,391,632 | 112 | $ 683,609 |
| FAMILY MED | $ 6,021.65 | 1,105 | $ 6,653,923.25 | 1,161 | $6,019.06 | $ 6,988,125 | 636 | $ 3,828,120 |
| GYN | $ 6,013.65 | 208 | $ 1,250,839.20 | 219 | $5,999.92 | $ 1,313,983 | 116 | $ 695,991 |
| ENT | $ 6,010.65 | 690 | $ 4,147,348.50 | 724 | $6,010.65 | $ 4,351,711 | 421 | $ 2,530,484 |
| MENTAL HEALTH | $ 502.99 | 1,287 | $ 647,348.13 | 1,351 | $502.99 | $ 679,539 | 736 | $ 370,200 |
| NEWBORN | $ 7,014.71 | 698 | $ 4,896,267.58 | 733 | $7,014.71 | $ 5,141,782 | 433 | $ 3,037,369 |
| OB | $ 5,713.65 | 1,430 | $ 8,170,519.50 | 1,501 | $5,713.65 | $ 8,576,189 | 868 | $ 4,959,448 |
| ORTHO | $ 6,084.18 | 601 | $ 3,656,592.18 | 631 | $6,084.18 | $ 3,839,118 | 274 | $ 1,667,066 |
| PEDIATRICS | $ 6,001.65 | 124 | $ 744,204.60 | 130 | $6,001.65 | $ 780,215 | 72 | $ 432,119 |
| PODIATRY | $ 6,018.14 | 2,050 | $ 12,337,187.00 | 2,152 | $6,018.14 | $ 12,951,037 | 800 | $ 4,814,512 |
| Total Revenue | $61,604 | 9,055 | $47,775,303 | 9,507 | $61,587 | $50,155,711 | 4,665 | $24,224,308 |
| Product Line | MDC DescrOPtion | |||||||
| CARDIOLOGY | Diseases and Disorders of the Circulatory System (Hypertension, Heart Disease, etc.) | |||||||
| ENDOCRINOLOYGY | Diseases and Disorders of the Endocrin System (Diabetes Type 1 & 2, Thyroid Disorders, etc) | |||||||
| FAMILY MED | Family Primary Care and Disease Preventative Services | |||||||
| GYN | Diseases and Disorders of Women's Reproductive Health | |||||||
| ENT | Diseases and Disorders of the Ear, Nose, Mouth, and Throat | |||||||
| MENTAL HEALTH | Mental Diseases and Disorders | |||||||
| NEWBORN | Newborns and Other Neonates with Conditions Originating in Perinatal Period | |||||||
| OB | Pregnancy, Childbirth, and the Puerperium | |||||||
| ORTHO | Diseases and Disorders of the Musculoskeletal System and Connective Tissue | |||||||
| PEDIATRICS | Pediatric Primary Care and Disease Prevention Services (0 – 18 years) | |||||||
| PODIATRY | Diseases and Disorders of the Feet and Lower Limbs | |||||||