Question: Can you please help me understand how to get the vertical and horizontal analysis for year 2. Please see attachment Our Company Balance Sheet Last
Can you please help me understand how to get the vertical and horizontal analysis for year 2. Please see attachment

Our Company Balance Sheet Last day year 1 Assets Current Assets: Cash Accounts Receivable Inventory Supplies Prepaid Rent Total Current Assets PP&E: Equipment Accumulated Depreciation Total PP&E Total Assets Liabilities Current Liabilities: Accounts Payable Interest Payable Income Taxes Payable Total Current Liabilities LTD: Notes Payable Total Liabilities Owners' Equity Stock Retained Earnings Total Owners' Equity Total Liabilities & Owners' Equity Vertical Analysis Comments: Horizontal Analysis Comments" Vertical Analysis Last day year 1 Balance Sheet Last day year 2 $ $ $ $ $ $ 45,750 2,000 6,100 1,000 7,000 61,850 $ $ $ $ $ $ 39,850 2,000 8,000 700 6,000 56,550 $ $ $ $ 5,000 (500) 4,500 66,350 $ $ $ $ 500 (500) 56,550 $ $ 4,500 100 $ 4,600 $ $ $ $ 8,000 100 100 8,200 $ $ 2,000 6,600 $ $ 2,000 10,200 1,905 56,905 63,505 $ $ $ $ 6,473 6,473 16,673 $ $ $ Vertical Analysis Last day year 2 Horizontal Analysis last day years 1 & 2 Our Company Income Statement Vertical Analysis Year ending 1 Year 1 Sales CGS Gross Profit Operating Expenses: Salaries Expense Utilities Supplies Rent Advertising Expense Consulting Expense Depreciation Expense Total Operating Expenses Operating Income Other Expenses: Interest Expense Income before taxes Income taxes (40%) Net Income EPS Vertical Comments: Horizontal Comments: Income Statement Year ending 2 Vertical Analysis Year 2 Horizontal Analysis Years 1 & 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
