Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    MS Excel Exercise - FS Analysis

    Uploaded by

    paxbass5
    The company's total assets increased 12.26% from 2019 to 2020, with increases in cash, land, and equipment. Liabilities also increased, with a 51.5% rise in accounts payable. Owners' capital rose 10%. Revenues grew 15.79% as net sales increased 25% despite a 33.33% drop in other income. Net income rose 40% from 2019.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    MS Excel Exercise - FS Analysis

    Uploaded by

    paxbass5
    46 views12 pages
    The company's total assets increased 12.26% from 2019 to 2020, with increases in cash, land, and equipment. Liabilities also increased, with a 51.5% rise in accounts payable. Owners' capital rose 10%. Revenues grew 15.79% as net sales increased 25% despite a 33.33% drop in other income. Net income rose 40% from 2019.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The company's total assets increased 12.26% from 2019 to 2020, with increases in cash, land, and equipment. Liabilities also increased, with a 51.5% rise in accounts payable. Owners' capital rose 10%. Revenues grew 15.79% as net sales increased 25% despite a 33.33% drop in other income. Net income rose 40% from 2019.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    46 views12 pages

    MS Excel Exercise - FS Analysis

    Uploaded by

    paxbass5
    The company's total assets increased 12.26% from 2019 to 2020, with increases in cash, land, and equipment. Liabilities also increased, with a 51.5% rise in accounts payable. Owners' capital rose 10%. Revenues grew 15.79% as net sales increased 25% despite a 33.33% drop in other income. Net income rose 40% from 2019.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 12

    ASSETS

    Cash
    Accounts receivable
    Supplies
    Land
    Equipment
    TOTAL ASSETS

    LIABILITIES AND CAPITAL


    Accounts payable
    Notes payable
    Capital
    TOTAL LIABILITIES AND CAPITAL
    2020 2019 Amount change Percentage change

    500,000 400,000 100,000 25.00%


    58,500 90,000 - 31,500 -35.00%
    28,000 40,000 - 12,000 -30.00%
    360,000 300,000 60,000 20.00%
    120,000 120,000 - 0.00%
    1,066,500 950,000 116,500 12.26%

    151,500 100,000 51,500 51.50%


    200,000 200,000 - 0.00%
    715,000 650,000 65,000 10.00%
    1,066,500 950,000 116,500 12.26%
    2020 CS 2019 CS

    46.88% 42.11%
    5.49% 9.47%
    2.63% 4.21%
    33.76% 31.58%
    11.25% 12.63%
    100.00% 100.00%

    14.21% 10.53%
    18.75% 21.05%
    67.04% 68.42%
    100.00% 100.00%
    2020
    Net Sales 5,000,000
    Less: Cost of Goods Sold 3,000,000
    Gross profit 2,000,000
    Add: Other income 200,000
    Revenues 2,200,000
    Less: Operating expenses 800,000
    Net income before tax 1,400,000
    Less: Income tax expense 420,000
    Net income 980,000
    2019 Amount change Percentage change 2020 CS

    4,000,000 1,000,000 25.00% 100.00%


    2,400,000 600,000 25.00% 60.00%
    1,600,000 400,000 25.00% 40.00%
    300,000 - 100,000 -33.33% 4.00%
    1,900,000 300,000 15.79% 44.00%
    900,000 - 100,000 -11.11% 16.00%
    1,000,000 400,000 40.00% 28.00%
    300,000 120,000 40.00% 8.40%
    700,000 280,000 40.00% 19.60%
    2019 CS

    100.00%
    60.00%
    40.00%
    7.50%
    47.50%
    22.50%
    25.00%
    7.50%
    17.50%
    ASSETS
    Cash
    Accounts receivable
    Supplies
    Land
    Equipment
    TOTAL ASSETS

    LIABILITIES AND CAPITAL


    Accounts payable
    Notes payable
    Capital
    TOTAL LIABILITIES AND CAPITAL
    2020 2019 Amount change Percentage change

    500,000 400,000
    58,500 90,000
    28,000 40,000
    360,000 300,000
    120,000 120,000
    1,066,500 950,000

    151,500 100,000
    200,000 200,000
    715,000 650,000
    1,066,500 950,000
    2020 CS 2019 CS
    2020
    Net Sales 5,000,000
    Less: Cost of Goods Sold 3,000,000
    Gross profit 2,000,000
    Add: Other income 200,000
    Revenues 2,200,000
    Less: Operating expenses 800,000
    Net income before tax 1,400,000
    Less: Income tax expense 420,000
    Net income 980,000
    2019 Amount change Percentage change 2020 CS

    4,000,000
    2,400,000
    1,600,000
    300,000
    1,900,000
    900,000
    1,000,000
    300,000
    700,000
    2019 CS

    You might also like