Financial Analysis
Financial Analysis
Permalink:
Using the financial statements from the Major Medical Center Case Study below, analyze the following: x Review the auditors opinion letter and analyze any concerns. x Review the financial statements. Analyze any unusual items and examine the balance sheet, operating statement, and cash flow statement. x Review the notes and analyze any causes for concern. x Calculate the following ratios using Excel: common size, current, quick, days of cash on hand, receivables turnover, average collection period, fixed asset turnover, total asset turnover, debt, debt to equity, times??interest??earned, operating margin, total margin, Return On Assets (ROA), and Return On Net Assets (RONA). x Evaluate Major Medical Centers financial status. Submit four??page Word document (not including the title and reference pages) and an Excel worksheet. Paper need to be formatted to APA style, and must cite at least four scholarly sources. 552
Part VI Financial Analysis Case Study Problem 15-12. For the Major Medical Center financial statements on the following pages, complete the following: a. Read the auditors opinion letter. Are any flags raised? b. Review the financial statements. Search for un? usual items. What things catch your eye on the balance sheet, operating statement, and cash flow statement? c. Review the notes. Do any of them raise cause for concern? d. Calculate the following ratios: common size, cur? rent, quick, days of cash on hand, receivables turnover, average collection period, fixed asset turnover, total asset turnover. debt, debt to equity. times-interest-earned, operating ma rgin, total mar? gin, ROA, and RONA. e. What do you think of Major Medical Centers financial sta t us?
CASE STUDY Major Medical Center8 I.N. SINGER AND OW, GPAs 2650 East 38th Street New York, New York 10089 Report of Independent Auditors Board of Trustees Major Medical Center We have audited the accompanying statements of financial position of Major Medical Center (the Medical Center) as of December 31, 2014 and 2013, and the related statements of operations, changes in net assets, and cash flows for the years then ended. These financial statements are the responsibility of the Medical Centers management. Our responsi bility is to express an opinion on tl1ese financial state? ments based on our audits. We conducted our a udits in accordance with generally accepted aud iting stan? dards. Those standards require that we plan and perform the audit to obtain rea? sonable assurance about whether t11e financial statements are f ree of material mis? statement. An audit includes examining, on a test basis, evidence suppotting the amounts and disclosures i n the financial statements. An audit also includes assess? ing the accounting principles used and significant estimates made by management, as well as evaluating the overall fina ncial statement presentation. We believe that our audits provide a reasonable basis for our opinion. In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of Major Medical Center at December 31, 2014 and 2013, and tl1e results of its operations, changes in net assets, and cash flows for the years then ended, in conformity with generally accepted accounting principles. April 30, 2015 i.N. SINGER AND OLD, CPAS RMajor MedicalCenter and Ho pital Support, Inc. are llctional organizations. Any similarity to r al organizations is purely coincidental. Chapter 15 Financial Statement Analysis 553 Major Medical Center Statements of Financial Position Assets Current Assets Cash and cash equivalents Assets limited as to use-compensating balance for letters of credit Short-term investments Receivables for patient care, net of allowance for doubtful accounts (2014-$27,232; 2013-$31,934)
Pledges receivable Inventories, at average cost Due from third-party reimbursement programs Receivables for government grants Other Total Current Assets Assets Limited as to Use Sinking fund Compensating balance for standby letters of credit Long-term investments Due from affiliates, net Pledges receivable, net of allowance for uncollectible pledges (2014-$2,218; 2013-$4,453) Property, plant, and equipment net Deferred financing costs Other Liabilities and Net Assets Current Liabilities Current portion of long-term debt Accounts payable and accrued expenses Accrued salaries and related liabilities Due to third-party reimbursement programs, net Advances on government grants Total Current Liabilities Long-term debt, less current portion Accrued post-retirement benefits Other noncurrent liabilities Total Liabilities Commitments and contingencies Net Assets Unrestricted Temporarily restricted Permanently restricted TotalNet
Assets Total Liabilities and Net Assets Scl anOmpanying note . December 31 2014 2013 (In Thousands) $ 8,065 $ 9,005 1,000 1,387 1,283 49,719 47,614 1,814 2,205 1,690 2,326 6,539 467 2,234 3,415 $ 72,448 $ 66,315 14,487 13,410 923 1,132 618 3,417 3,543 1,889 1,468 98,555 89,777 1,323 2,065 1,043 $196,239 $176,174 $ 11,608 $ 11,488 29,489 25,311 25,572 20,096 1 ,874 1,587 $ 68,256 $ 58,769 55,539 47,709 6,023 6,017 16,445 17,014 $146,263 $129,509 $ 40,582 $ 38,014 8,262 7,519 1132 1 132 $ 49,976 $ 46,665 $196,239 $176,174 554 Part VI Finandal Analysis Major Medical Center Statements of Operations Year ended December 31 2014 2013 (In Thousands) Operating Revenue Net patient service revenue $402,921 $369,512 Other revenue 13,356 13,850 Net assets released from restrictions 4,708 2,863 Total Operating Revenue $420,985 $386,225 Operating Expenses Salaries and wages $207,141 $196,453 Employee benefits 44,456 44,860 Supplies and expenses 137,505 117,838 Depreciation and amortization 22,541 18,856 Research 2,457 2,214 Interest 4.456 5,253 Total Operating Expenses $418,556 $385,474 Operating Income $ 2,429 $ 751 Net assets released from restrictions used for capital acquisitions 139 146 Increase in unrestricted net assets $ 2,568 $ 897 Sec accompanying notes. Major Medical Center Statements of Changes in Net Assets Net Assets Temporarily Permanently Unrestricted Restricted Restricted (In Thousands)
Net Assets at December 31, 2012 Increase in unrestricted net assets Restricted contributions, grants, and other receipts Investment income restricted for specific purposes Net assets released from restrictions for: Operating expenses Capital asset acquisitions Change in net assets Net Assets at December 37, 2013 $37,117 $ 897 $ 897 $38,014 $3,023 -$- 7,253 252 (2,863) (146) $4,496 $7,519 $1,132 -$- -$? $1,132 Increase in unrestricted net assets Restricted contributions, grants, and other receipts Investment income restricted for specific purposes Net assets released from restrictions for: Operating expenses Capital asset acquisitions $ 2,568 -$$ 5,421 169 (4,708) (139) Change in net assets Net Assets on December 31, 2014 $ 2,568 $40,582 $ 743 $8,262 $ $1,132 See accompanying notes. Chapter 15 Financial Statement Analysis 555 Major Medical Center Statements of Cash Flows Year Ended December 31 2014 2013 (In Thousands) Notes to Financial Statements 1. Organization and Summaty of Significant Accou nti ng Policies Orgattizatiotz Major Medical Center (the Medical Center) is a not-for-profit corporation. The Medical Center provides health care and related services. The accompanying financial statements do not include the accounts of the Research Foundation, a not-for-profit corporation that solicits funds and awards grants to the Medica l Center for research purposes, nor for Hospital Support, Inc., which provides certain su pport services.
Temporarily and Permanently Restricted Net Assets Temporarily restricted net assets are those whose use by the Medical Center has been limited by donors to a speci fic time period or purpose. Permanently restricted net assets 556 Part Vl Financial Analysis have been restricted by donors to be maintained by the Medical Center in perpetuity. When a donor restriction expires (i.e., when a stipulated time restriction ends or pur? pose restriction is accomplished), temporarily restricted net assets are reclassified as un? restricted net assets and reponed in the statements of operations as net assets released from restrictions. Donor-restricted contributions whose restrictions are met within the same year as received arc reflected as tempora rily restricted contributions and net asset<; released from restrictions in the accompanying financial statements. Receivables for Patiettt Care Patient accounts receivable from th i rd-pa rt y programs for which the Medical Center receives payment under reimbursement formulas or negotiated rates are stated at the estimated net amounts receivable from such payors, which are generally less than the established charges of the Medical Center. Investments Investments consist of U.S. Treaswy bonds and notes, certificates of deposit, and money mar? ket funds. Investments arc carried at fair value. Amounts classilled as long-term investments, consisting primarily of money market funds, represent pem1anently n:suicted net assets.
lnvestmetzt Gains, Losses, and Income Investment income, which includes real gains and losses, earned on permanently re? stricted and temporarily restricted funds upon which restrictions have been placed by donors, is added to temporarily restricted funds. All other investment income is ret1ectecl in the accompanying statement> of operations. Property, Plant, and Equipment Propetty, plant, and equipment purchased are canied at cost, and mose acquired by gifts and bequests are carried at apprdised or fair ma rket value established at the date of acquisition. Capitalized leases are recorded at the fair market value at the inception of the leases. l11e canying amounts of assel<; and the related accumulated depreciation are removed from the accounts when such assets are disposed of, and any resulting gain or loss is included in oper? ations. Depreciation of assets used in operations is recorded on me stra ight-line method over the estimated useful lives of tl1e asset<;. Capit.llized leases are amortized over the lease tem1. Pledges Unconditional promises to give cash and other assets are repotted at their net present value at the date the promise is received. The gifts are reported as either temporarily or permanently restricted support if they are received with donor stipulations that limit the use of the donated assets. Pledges receivable, discounted at 10 percent, are expected to be paid as follows (in thousands): Less than one year $ 1,814 One year to five years 3,145 In excess of five years 962 $ 5,921 Less allowance for uncollectible pledges receivable (2,218) $ 3,703
Assets Limited as to Use Assets classified as limited as to use represent assets whose use is restricted for specific purposes under terms of agreementS. ?- ? ? Accrued Post-Reliremellt Benefit s Chapter 15 Financial Statement Analysis 557 The itedical Center account<> for post-retirement health care and life insurance benefits on the accrual basis of accounting. Uucompe11sated Care As a matter of policy, the Medical Center provides significant amounts of partially or totally uncompensated patient care. For accounting purposes, such uncompensated care is treated either as charity care or bad debt expense. The Medical Center has defined char? ity care for accounting and disclosure purposes as the difference between its customary charges and the sliding scale rates given to patients in need of financial assistance. Since payment of this difference is not sought, charity care allowances are not repotted as reve? nue. Patients who do not qualify for sliding scale fees and all uninsured inpatient<; who do not qualify for Medicaid assistance arc bi lled at the Medical Centers full rates. Uncollected balances for these patients are categorized as bad debts. Total uncompensated care for all patient services approximated $22 million and $20 million in 2011 and 2013, respectively. Use of Estimates The preparation of financial statements in conformity with generally accepted account? ing principles requires management to m:.tke estimates and assumptions that affect the reported amount of assets and liabilities and the d isclosure of contingent assets and liabilities at the date of the financial statements. Estimates also affect the reported amoums of revenue and expenses during the reponing period. Actual results could differ from these estimates. Management believes that the amounts recorded based on estimates and assumptions are reasonable, and any differences between estimates and actual should not ha e a material impact on the Medical Centers financial position. Operatbzg Income Transactions deemed hy management to he ongoing, major, or central to the provision of health care services are reported as operating revenue and expenses, and arc included in operating income. Operating income also includes investment income and realized gains and lossls from the sale of investments. Tax Status The tvlldical Center is exempt from federal income taxes under Section 501(c)(3) of the Intlrnal Revenue Code. The Medical Center has been classified as an organization that is not a private foundation under Section 509(a)(1 ). Contributions received by the Medical Clnter qualify as tax-deductible charitable contributions. 2. Third-Party Reimbursement Programs Tlw tledical Center has agreements with third-party payers that provide for payments to tlw Medical Center at amounts different from its established charges. Payment ar? rangements include prospectively determined rates per discharge, reimbursement of costs, discounted charges, and per diem payments.
Patient service revenue is recorded at the Medical Centers established charges when patient services are performed. Adjustments for differences between established charges and payment amounts are deducted directly from receivables for patient care and patient service revenue in the year incurred. Federal and state regulations provide for certain retrospective adjustments to cunent and ptior years payment rates based on industrywide and hospital-specific data. The Medical Center has estimared the potential impa<.1of such retrospective adjustments based on infOtma? rion presently available, and adjustments are accrued on an estimated basis in the period the setvices are rendered and are adjusted in future peti percent of the Medical Centers cash and cash equivalents balance was held at one financial institution. 14. Fair Value of Financial Instruments The following methods and assumptions were used by the Medical Center in estimating its fair value disclosures for financial instruments: The carrying amount reported in the statements of financial position for cash and cash equivalents approximates its fair value. Short-term investments consist primarily of government and other debt securities. Fair values are based on quoted market prices. Long-term investments consist primarily of money market funds. Fair values are based on quoted market prices. Assets limited as to use consist primarily of government securities. Fair values are based on quoted market prices. Most of the long-term debt of the Medical Center was refinanced during 2006. The canying value of the Medical Centers long-term debt at December :31, 2011, approxi? mates it<; fair value. 15. Contingencies The Medical Center is a defendant in various legal actions ansrng out of the normal course of its operations, the final outcome of which cannot presently be determined. The amounts claimed would be material to the financial position of the Medical Center. Medical Center management is of the opinion that ultimate liability, if any, with respect to all of these matters will not have a material adverse effect on the Medical Centers financial position. Approximately 67 percent of the Medical Centers employees are members of vari? ous unions. Of these employees, approximately 70 percent are covered by contracts expiring during 2015. Suggested Readings Emery, Douglas R., john D. Finnerty, and John D. Stowe.
Corporate Financial Mana emenl, ,ird ed. Upper Saddle River, N.J.: Prentice Hall, 2007. Finkler, Steven A. Finance & Accountin for Nonjlnancial Managers, .3rd ed. New York, N.Y.: Aspen Publishers, 2003. Fraser, Lyn M., and Aileen Ormiston. Unden;tmulinR Financial Statemellls. 9th ed. Upper Saddle River, 1.j.: Prentice Hall, 2009. lngcnix St. Anthony. IZ1e 2008Aimanac c>/llospital Filial/Cia/ (.Operating I11dicators. United States: lngenix, 200H. Rcvsinc, Lawrence, Daniel W. Collins. W. Bruce Johnson, and Fred Mittelstaedt. Fil/(mcia/ Reporting (. Ana vsis, 5th ed. ew York: McGra I!ill Irwin, 20 II. Werner, Michael L., and Kumen II. jones. 111/roduction to Financial Accounting: A User Perspectil?, jrd ed. ppt:r Saddle Rin:r, N.J.: lrenricc Hall, 200 1.