management accounting

ABC Corporation Balance Sheet For the Year Ended December 31, 2020-2024 2020 2021 2022 2023 2024 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets P 60,000 P50,000 120,000 150,000 420,000 520,000 P600,000 P 720,000 80,000 160,000 580,000 P820,000 P 100,000 200,000 600,000 P 900,000 P 200,000 400,000 800,000 P 1,400,000 PPE Total Non-Current Assets TOTAL ASSETS 1,600,000 1,700,000 1,600,000 1,700,000 P 2,200,000 P 2,420,000 1,800,000 1,800,000 P 2,620,000 2,000,000 2,000,000 P 2,900,000 2,500,000 2,500,000 P 3,900,000 LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses P 70,000 30,000 P100,000 60,000 20,000 80,000 P100,000 60,000 P 160,000 P 200,000 100,000 P 300,000 P 300,000 200,000 P 500,000 150,000 150,000 200,000 200,000 300,000 300,000 400,000 400,000 600,000 600,000 P 250,000 P 280,000 P 460,000 P700,000 P 1,100,000 Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE P 1,800,000 P 2,000,000 150,000 140,000 1,950,000 2,140,000 P 2,000,000 160,000 2,160,000 P 2,000,000 200,000 2,200,000 P 2,000,000 800,000 2,800,000 P 2.200,000 P 2,420,000 P 2,620,000 P 2.900.000 P 3,900,000 ABC Corporation Balance Sheet For the Year Ended December 31, 2020-2024 2020 2021 2022 2023 2024 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Llabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE Requirement: Trend Ratios ABC Corporation Income Statement For the Year Ended December 31, 2020-2024 2020 2021 2022 2023 2024 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE Requirement: Common Size Balance Sheet Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 150,000 140,000 1,950,000 2,140,000 P 2,200,000 P 2,420,000 160,000 2,160,000 P 2,620,000 200.000 2,200,000 P 2,900,000 800,000 2,800,000 P 3,900,000 a. 1. Compute Measures of Profitability from 2020-2024 Additional Information: par Value P 200 per share b. Market Price per share P 205 Year 2020, P 210 Year 2021, P 212 Year 2022, P 215 Year 2023, P 216 Year 2024 C. Dividend Payment 1. Year 2020 30,000 2. Year 2021 50,000 3. Year 2022 60,000 4. Year 2023 70,000 5. Year 2024 80,000 2. Compute Measures of Liquidity from 2020-2024 *All sales on account ** All purchases on account ABC Corporation Income Statement For the Year Ended December 31, 2020-2024 Sales SRA SD Net Sales Cost of Sales Gross Profit Operating Expenses Marketing 2020 P 200,000 2,000 3.000 P 195,000 130,000 P 65,000 2021 P 400,000 4,000 3,000 P 393,000 150,000 P 243,000 2022 P 650,000 6,000 4.000 P 640,000 280,000 P 360,000 2023 P 700,000 8,000 6.000 P 686,000 350,000 P336.000 2024 P 800,000 10,000 15,000 P 775,000 420.000 P 355.000 5,000 60,000 70,000 100,000 80,000 100.000 20.000 40.000 50.000 90.000 Gen, & Adm. Expenses Total Operating Expenses Net Income 25,000 120,000 180,000 190,000 100,000 P 143,000 P40,000 P 240,000 P 156.000 P 165,000 ABC Corporation Balance Sheet For the Year Ended December 31, 2020-2024 2020 2021 2022 2023 2024 P 60,000 120,000 420,000 P600.000 P50,000 150,000 520,000 P 720.000 P80,000 160,000 580,000 P820.000 P 100,000 200,000 600,000 P 900.000 P 200,000 400,000 800,000 P 1.400.000 1.600.000 1,600,000 1.700.000 1,700,000 1.800.000 1,800,000 2.000.000 2,000,000 2.500,000 2.500,000 P 2.200.000 P 2.420,000 P 2.620,000 P 2.900.000 P 3.900.000 ASSETS Current Assets Cash A/R Merch. Invty Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABIUTIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock P 70,000 30,000 P 100.000 P 60,000 20,000 P 80.000 P100,000 60,000 P160,000 P 200,000 100,000 P300,000 P 300,000 200,000 P500,000 150,000 150,000 P250,000 200.000 200,000 P_280.000 300.000 300,000 P460,000 400.000 400,000 600,000 600,000 P 1.100,000 P700,000 P 1,800,000 P 2,000,000 P 2,000,000 P 2,000,000 P 2,000,000