BuntonMod2a

docx

School

University of Cincinnati, Clermont College *

*We aren’t endorsed by this school

Course

FINANCIAL

Subject

Finance

Date

Feb 20, 2024

Type

docx

Pages

5

Uploaded by Nbunton0725

Report
Financial Management in Healthcare Module 2a Application Exercises Learning Objectives: 1) Perform trend analysis on an organization’s balance sheet. 2) Calculate an acid-test/quick ratio. 3) Calculate, analyze, and compare the debt ratio for an organization. Directions: In order to receive the full points for each of the exercises below, you must show your work (i.e. show your formulas with the numbers inserted). All answers are to be rounded to the 10 th place (one place past the decimal). Use the guidance provided within your text as to what type of value should be represented by the particular calculation. All labels must be provided (percentage, days, dollars, etc.) in your final answers. Part I: Trend Analysis Review the balance sheet and calculate the trend (% of change) for each line item and fill in the correct numbers in the highlighted yellow areas of the table. To calculate the percentage change from year to year, use the following formula on page 49 of your finance text. UC Health Balance Sheet Reported Values ($) 2023 Reported Values ($) 2022 Trend (% Change) Assets Current Assets Cash 4, 100,500 3,005,250 4,100,500-3,005,250 0.3644= 36.4% 3,005,250 Patient Accounts Receivable 5, 500,000 3, 575,000 5,500,000-3,575,000 0.5384= 53.8% 3,575,000 Total Current Assets 9,600,500 6,580,250 9,600,500-6,580,250 0.4589= 45.9% 6,580,250 Capital Assets Land & Construction in Progress 350,000 200,000 350,000-200,000 0.75= 75.0% 200,000 Total Capital Assets 350,000 200,000 350,000-200,000 0.75= 75.0% 200,000 Total Assets 9,950,500 6,780,250 9,950,500-6,780,250 0.4675= 46.8% 6,780,250 Liabilities Current Liabilities Accounts Payable and Accrued 568,000 397,000 568,000-397,000 0.4307= 43.1%
Expenses 397,000 Accrued Salaries 875,000 975,000 875,000-975,000 -0.1025= -10.3% 975,000 Total Liabilities 1,443,000 1,372,000 1,443,000-1,372,000 0.0517= 5.2% 1,372,000 Is this a vertical or horizontal analysis? Why? Comment on one item within the balance sheet that should be investigated further to see why there is a difference between the years. What could be impacting the differences? This would be a horizontal analysis because the percentage change is calculated across the rows of the statement. The item that should be investigated more should be the accrued salaries, they have more construction and progress, everything has gone up by at least half, besides their salaries have gone down. It seems as if there is $71,000 of accrued salaries unaccounted for. Accrued salaries for 2023 should be 946,000. The percentage change should be -30.0% for accrued salaries. Part II: Liquidity Ratios A) Quick Test Ratio Balance Sheet for UC Clinic for Year Ending June 30, 2023 (FY23) Assets Liabilities Cash and Cash Equivalents (includes short-term investments) $550,000 Accounts payable $ 720,000 Accounts Receivable $2,265,000 Notes payable $ 375,500 Inventories $465,000 Total Current Assets $3,280.000 Total Current Liabilities $ 1,095,500 Equipment $ 852,000 Long-term debt $2,850,000 Building $2,470,000 Total liabilities $3,745,500 Accumulated Depreciation $346,000 Fund Balance $2,802,500 Total Assets $6,948,000 Total Liabilities & Fund Balance $10,493,500 Balance Sheet for UC Clinic for Year Ending June 30, 2022 (FY22)
Assets Liabilities Cash and Cash Equivalents (includes short-term investments) $450,000 Accounts payable $620,000 Accounts Receivable $1,265,000 Notes payable $275,500 Inventories $365,000 Total Current Assets $2,080.000 Total Current Liabilities $895,500 Equipment $752,000 Long-term debt $1,850,000 Building $1,470,000 Total liabilities $2,745,500 Accumulated Depreciation $246,000 Fund Balance $1,802,500 Total Assets $4,548,000 Total Liabilities & Fund Balance $7,293,500 Analyze the balance sheet to decide whether UC Clinic has sufficient cash on hand to pay its bills. Calculate the quick rate ratios for UC Clinic for FY22 and FY23. Show your work as you might receive partial credit even if your final answer is incorrect. Cash & Cash Equivalents + Short -Term Investments + Accounts Receivable = Quick Ratio Total Current Liabilities June 2023 June 2022 $550,000+$2,265,000 = 2.5696 $450,000+$1,265,000 = 1.9150 $1,095,500 $895,550 Provide a brief answer in narrative format and in your own words as to what this ratio says about UC Clinic and their ability to pay their bills in both FY22 and FY23. A quick ratio that is equal to or greater than one means the company has enough liquid assets to meet its short-term obligations. June 2023 has a quick ratio of 2.5696, meaning this year the hospital is doing well and has a great ability to pay their bills, in June 2022 the hospital has a quick ratio of 1.9150, which shows that they can pay their bills.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Part III: Debt Performance Ratios Using the data provided in UC Clinic’s balance sheets for FY22 and FY23, calculate the debt performance ratio for FY22 and FY23. You may refer to page 61 of the finance text to assist you with this calculation. Show your work as you might receive partial credit even if your final answer is incorrect. Provide a comparative statement between the two fiscal years (FY22 vs FY23) and explain what this means in terms of UC Clinic’s total debt to its total assets Performance Ratio for FY22 Debt ratio = Total Liabilities $7,293,500 = 1.6036= 1.6% Total Assets $4,548,000 Total Equity = total current assets-total current liabilities Debt to Equity Ratio= Total liabilities $7,293,500 = 6.1574= 6.2% Total Equity 1,184,500 Performance Ratio for FY23 Debt ratio= Total Liabilities $10,493,500 = 1.5102 = 1.5% Total assets $6,948,000 Debt to Equity Ratio= total liabilities $10,493,500 = 4.8036= 4.8% Total equity 2,184,500 My calculations show for FY22 the debt ratio is 1.6% which is low, meaning that they have the capacity to take on more debt. FY23 has a debt ratio of 1.5% which also shows the capacity to take on more debt. When calculating the debt-to-equity ratio for FY22, my calculations showed a 6.2%, and for FY23 a 4.8%. The DER for a not-for-profit facility measures the
amount of debt compared to the amount collected via charitable contributions and grants. Both show a low DER implying that they have the capacity to take on more debt if needed.