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

3

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 Patient Accounts Receivable 5, 500,000 3, 575,000 Total Current Assets 9,600,500 6,580,250 Capital Assets Land & Construction in Progress 350,000 200,000 Total Capital Assets 350,000 200,000 Total Assets 9,950,500 6,780,250 Liabilities Current Liabilities Accounts Payable and Accrued Expenses 568,000 397,000 Accrued Salaries 875,000 975,000 Total Liabilities 1,443,000 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? 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. 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. 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
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