Requirement 1 Perform a horizontal analysis on the balance sheets for 2022 and 2023. Complete the grey boxes below

Requirement 2 Perform a vertical analysis on the income statement. Complete the grey boxes belo

Requirement 3 Compute the following ratios in the grey cells:

Financial Statement Analysis Excel Problem Follow the Grenache prepare the necessary Orange ORLANIR UNIVERSE Lorem 193 and 20221 134 Cash SSR 195,000 TS 2 00 1,000 MY Othern Assets alun ... men TORIA 19:37 815 . 231.51 Acne Total Club HI 0.000 Del Po Mogo tal- 3000 190,00 TUTO Le bare med und Princess Raw Telu ltte Meatin' 235,000 58,00 501 SUCRE 2221 20 ORANGE UNIVERSE Your 103 Natal TRO Dhe LCORC Income Taxi 157.529 Amalia YER Martes Address All.com maquiminis 1 1 Puma Blastest 22 23 Post Com the finger Centar Acid. Teilatie C Account De Sol Raw be Days Sacs very DI D ! Heard Prelit Magne TA AR late afectam no Stackout 9 Eimipore PH Divided You Diva Requirement ! Perform a horizontal analysis on the balance sheets for 2022 and 2023. Complete the grey boxes below. ORANGE UNIVERSE Comparative Balance Sheet June 30, 2022 and 2023 Increase (Decrease) Amount Percentage 2013 2022 Assets Cash Short-term Investments Accounts Receivable Merchandise laventory Other Current Assets Total Current Assets Property. Plant, and Equipment Total Assets 155.000 675.000 200.000 63.000 189.000 1,312,000 875.000 2.187.000 124,000 645.000 212.000 62,000 14.000 1.227.000 832.000 2.059.000 265,000 251.750 725,522,727 906.000 Liabilities Current Liabilities Accounts Payable Accrued Liabilities Total Current Liabilities Long-term Liabilities Bonds Payable Mortgage Payable Total Long-term Liabilities Total Liabilities Stockholders' Equity Common Stock. Ipar 225.000 shares issued and outstanding Paid In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 250,000 150,000 400,000 1.306,000 150,000 175.000 325.000 225.000 58.000 581.000 86400 2.170,000 225.000 58.000 474,727 273 757.72727) 2,060,000 Requirement 2 Perform a vertical analysis on the income statement. Complete the grey boxes below. ORANGE UNIVERSE Income Statement Year Ended June 30, 2023 2,800,000 1,551,600 1,248,400 450,5401 797,860 Net Sales Cost of Goods Sold Gross Profit Operating Expenses Operating Income Other Income and (Expenses) Interest Expense Income Before Income Taxes Income Tax Expense Net Income -15,000 782,860 153,529.21 629,330.8 Requirement 3 10211 2022 Compute the following is in the grey celle Working Capital Current Ratio Acid-Test (Owick) Ratio Cash Ratio Accounts Receivable Turner Days Sales in Receivables Inventory Tumover Days' Sales inventy Gross Profil Percentage Debt Ratio Debt to Equity Ratio Times Interest.Eamed Rutie Pratit Margin Ratin Rate of Retum on Total Assets Asset Tuover Ratio Rate of Return on Commen Stockholders' Equity Earnings per Shure (EPS) Price Earnings Ratio Dividend Yield Dividend Payout Dashboard Calendar To Do Notifications Inbox