DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable nventory Total Assets Dec. 31, 2022 Dec. 31, 2021 460,000 780,000 3,164,000 Example: 400,000 650,000 2,800,000 NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). 30000 + 500000 6.0 %

Guys could you please help me: I'm attaching AT&T's Balance Sheet and Income Statement for the analysis.I'd really appreciate help with the following: Perform a vertical financial analysis incorporatingi. Debt ratioii. Debt to equity ratioiii. Return on assetsiv. Return on equityv. Current ratiovi. Quick ratiovii. Inventory turnoverviii. Days in inventoryix. Accounts receivable turnoverx. Accounts receivable cycle in daysxi. Accounts payable turnoverxii. Accounts payable cycle in daysxiii. Earnings per share (EPS)xiv. Price to earnings ratio (P/E)xv. Cash conversion cycle (CCC), andxvi. Working capitalxvii. Explain Dupont identity, apply it to your selected company, interpret thecomponents in Dupont identity.

Calculate Quick Ratio: AKA the Acid Test

Balance Sheet Prepare a horizontal analysis of the balance sheet for Year 4 and Year 3. Note: Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (1.e., .234 should be entered as 23.4). Assets Current assets Cash Income Statement Marketable securities Accounts receivable (net) Inventories Prepaid Items Total current assets Investments Plant (net) Total long-term assets Total assets Liabilities and Stockholders' Equity Liabilities Current liabilities Terlam Notes payable Accounts payable Salaries payable Total current liabilites Noncurrent liabilities Bonds payable Other Total noncurrent liabilities Total abilities Stockholders' equity FRANKLIN COMPANY Horizontal Analysis of Balance Sheets Preferred stock (par value $10, 4% cumulative, nonparticipating: 6,300 shares authorized and issued) EMAIA Common stock (no par; 50,000 shares authorized, 10,000 shares issued) Retained earnings Total stockholders' equity Total habilities & stockholders equity…