1. Using the attached Consolidated Balance Sheet for Vetville Veterinary Clinic, Inc., complete the following ratios for each year: Ratio/Year 2018 2019 2020 Cash Ratio (Cash/CL) Current Ratio (CA/CL) Percent Equity (Equity/TA) Percent Debt (TL/TA) a. Describe the liquidity position of the business from 2018 to 2020: b. Describe the solvency position of the business from 2018 to 2020: Using the attached 2020 Income Statement for Vetville Veterinary Clinic and information for the year 2020 from the Consolidated Balance Sheet, complete the following ratios: Profit Margin (NI/Gross Revenue): a b. Return on Assets (NI/TA): C. Return on Equity (NV/Equity): d. Can you draw any conclusions about profitability for the year 2020? c. Do a DuPont Analysis for the year 2020. Can you draw any conclusions from this? ASSETS 2018 2019 2020 Current Assets Cash $ $ 10,000 $ 8.500 14,500 11,700 Accounts Receivable 11,200 10,800 Inventories Pharmaceuticals 50,500 42,500 35,000 Supplies 8,000 17,000 $ 93,700 10,200 $ 64,500 Total Current Assets $71,700 Noncorrent Assets Equipment $ $ 95,000 80,000 700,000 Building 650,000 5 120,000 640,000 165,000 5 925,000 Land 150,000 160,000 Total Noncurrent Assets $ 930,000 S 905,000 $ 976,700 Total Assets $ 1,023,700 $ 989.500 LIABILITIES 2018 2019 2020 Current Liabilities Accounts Payable $ 16,500 $ 19,000 17.000 Notes Payable (I y.) $ 17,200 20,100 38,000 25,200 40,500 Teem Debt (current) 45,000 Accrued Expenses Income Taxes 7,000 8,000 10,000 Total Current Liabilities $ 89,200 $83,300 $91.000 Noncurrent Liabilities $ 767,000 5744,000 $732,000 Noncurrent Real Estate Debt Noncurrent Equipment Debt 42.500 23.400 Total Noncurrent Liabilities $ 809,500 $767,400 40,000 5772,000 S863.000 Total Liabilities S 898,700 S850,700 2018 2019 2020 Owner Equity Contributed Capital Retained Earnings $100,000 $100,000 $100,000 26,000 25,000 $ 125,000 $1,023,700 26,500 $ 126,500 Total Owner Equity $ 126,000 Total Liabilities & Owner Equity 5976,700 $ 989.500 Income Statement for Vetville Veterinary Clinic, Inc., January 1, 2020 to December 31, 2020. Item Subtotal Total Clinic Revenue Patient Services Product Sales Pharmaceutical Sales Clinic Gross Revenue $575,200 42,500 68,750 $ 686,450 $ 112,370 Clinic Expenses Cash Operating Expenses Noncash adjustments Change in accounts payable Change in unused supplies Interest Expense Clinic Total Expenses 750 1,200 69,040 $ 183,360 $ 503,090 Net Operating Income Before Taxes S 150.927 Income Tax Expense Net Income S 352,163