Perform a vertical analysis on the balance sheet and income statement for $2023.$ ?Complete the grey boxes below.

Transcribed Image Text:

Perform a vertical analysis on the balance sheet and income statement for 2023. Complete the grey boxes below. Current Assets: Cash Short-term Investments Accounts Receivable Merchandise Inventory Other Current Assets Total Current Assets Property, Plant, and Equipment Total Assets ORANGE UNIVERSE Comparative Balance Sheet June 30, 2023 Assets ORANGE UNIVERSE Income Statement Year Ended June 30, 2023 Net Sales $ 2,800,000 138,000 675,000 230,000 63,000 189,000 1,295,000 Cost of Goods Sold Gross Profit 1,551,600 1,248,400 Operating Expenses 450,540 Operating Income 797,860 Other Income and (Expenses) Interest Expense (15,000) Income Before Income Taxes 782,860 Income Tax Expense 153,529 Net Income 629,331 $ 875,000 2,170,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 Accrued Liabilities Total Current Liabilities Long-term Liabilities Bonds Payable 641,000 906,000 Mortgage Payable Total Long-term Liabilities Total Liabilities Stockholders' Equity Common Stock, $1 par, 225,000 shares issued and outstanding Paid-In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity Assets 250,000 150,000 400,000 1,306,000 225,000 58,000 581,000 864,000 $ 2,170,000 ORANGE UNIVERSE Comparative Balance Sheet June 30, 2022 and 2023 2023 2022 Current Assets: Cash Short-term Investments Accounts Receivable Merchandise Inventory Other Current Assets Total Current Assets Property, Plant, and Equipment Total Assets S 138,000 $ 124,000 675,000 645,000 230,000 212,000 63,000 62,000 189,000 184,000 1,295,000 227,000 875,000 832,000 $ 2,170,000 $2,059,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 $ 250,750 Accrued Liabilities Total Current Liabilities Long-term Liabilities Bonds Payable 641,000 725,523 906,000 976,273 250,000 150,000 Mortgage Payable Total Long-term Liabilities Total Liabilities Stockholders' Equity 150,000 175,000 400,000 325,000 1,306,000 1,301,273 Common Stock, $1 par, 225,000 shares issued and outstanding 225,000 225,000 Total Stockholders' Equity Paid-In Capital in Excess of Par Retained Earnings Total Liabilities and Stockholders' Equity 58,000 58,000 581,000 474,727 $ 864,000 2,170,000 $ 757,727 2,059,000 Perform a vertical analysis on the balance sheet and income statement for 2023. Complete the grey boxes below. Current Assets: Cash Short-term Investments Accounts Receivable Merchandise Inventory Other Current Assets Total Current Assets Property, Plant, and Equipment Total Assets ORANGE UNIVERSE Comparative Balance Sheet June 30, 2023 Assets ORANGE UNIVERSE Income Statement Year Ended June 30, 2023 Net Sales $ 2,800,000 138,000 675,000 230,000 63,000 189,000 1,295,000 Cost of Goods Sold Gross Profit 1,551,600 1,248,400 Operating Expenses 450,540 Operating Income 797,860 Other Income and (Expenses) Interest Expense (15,000) Income Before Income Taxes 782,860 Income Tax Expense 153,529 Net Income 629,331 $ 875,000 2,170,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 Accrued Liabilities Total Current Liabilities Long-term Liabilities Bonds Payable 641,000 906,000 Mortgage Payable Total Long-term Liabilities Total Liabilities Stockholders' Equity Common Stock, $1 par, 225,000 shares issued and outstanding Paid-In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity Assets 250,000 150,000 400,000 1,306,000 225,000 58,000 581,000 864,000 $ 2,170,000 ORANGE UNIVERSE Comparative Balance Sheet June 30, 2022 and 2023 2023 2022 Current Assets: Cash Short-term Investments Accounts Receivable Merchandise Inventory Other Current Assets Total Current Assets Property, Plant, and Equipment Total Assets S 138,000 $ 124,000 675,000 645,000 230,000 212,000 63,000 62,000 189,000 184,000 1,295,000 227,000 875,000 832,000 $ 2,170,000 $2,059,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 $ 250,750 Accrued Liabilities Total Current Liabilities Long-term Liabilities Bonds Payable 641,000 725,523 906,000 976,273 250,000 150,000 Mortgage Payable Total Long-term Liabilities Total Liabilities Stockholders' Equity 150,000 175,000 400,000 325,000 1,306,000 1,301,273 Common Stock, $1 par, 225,000 shares issued and outstanding 225,000 225,000 Total Stockholders' Equity Paid-In Capital in Excess of Par Retained Earnings Total Liabilities and Stockholders' Equity 58,000 58,000 581,000 474,727 $ 864,000 2,170,000 $ 757,727 2,059,000

Answer rating: 100% (QA)

To perform a vertical analysis we need to express each item on the balance sheet and incom... View the full answer