Scribd Logo
Upload

Welcome to Scribd!

  • 152 views

    Trend Analysis

    Uploaded by

    Rachel Villotes
    The document provides financial statements for Gilbert Company from 2015 to 2019 including the statement of financial position, income statement, and key metrics. Over the period: - Total assets grew 46% from $2.17B to $3.21B driven primarily by increases in property/equipment and other assets. - Net income increased 80% from $58M to $104M as net sales expanded 75% from $1.71B to $3B and gross margins improved.

    Copyright:

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

    Trend Analysis

    Uploaded by

    Rachel Villotes
    152 views5 pages
    The document provides financial statements for Gilbert Company from 2015 to 2019 including the statement of financial position, income statement, and key metrics. Over the period: - Total assets grew 46% from $2.17B to $3.21B driven primarily by increases in property/equipment and other assets. - Net income increased 80% from $58M to $104M as net sales expanded 75% from $1.71B to $3B and gross margins improved.

    Original Title

    TREND_ANALYSIS.xlsx

    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 document provides financial statements for Gilbert Company from 2015 to 2019 including the statement of financial position, income statement, and key metrics. Over the period: - Total assets grew 46% from $2.17B to $3.21B driven primarily by increases in property/equipment and other assets. - Net income increased 80% from $58M to $104M as net sales expanded 75% from $1.71B to $3B and gross margins improved.

    Copyright:

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

    Trend Analysis

    Uploaded by

    Rachel Villotes
    The document provides financial statements for Gilbert Company from 2015 to 2019 including the statement of financial position, income statement, and key metrics. Over the period: - Total assets grew 46% from $2.17B to $3.21B driven primarily by increases in property/equipment and other assets. - Net income increased 80% from $58M to $104M as net sales expanded 75% from $1.71B to $3B and gross margins improved.

    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 5

    Gilbert Company

    Statement of Financial Position


    December 31, 2015-2019
    (P000's)

    December Net Sales


    Assets 2015 2016 2017 2018 2019 Cost of Goods sold
    Current Assets Gross margin on sales
    Cash 56.4 117.2 118.0 148.4 166.8 Operating expenses
    Marketable Securities 210.2 79.2 79.6 79.0 89.8 Selling expenses
    Trade Receivables, net 522.2 406.6 460.6 539.8 583.8 General and adm
    Inventory 394.4 439.2 483.8 536.6 506.8 Total operating ex
    Other current assets 121.4 101.00 10.32 104.2 70.4 Operating income
    Total current assets 1304.6 1143.2 1245.2 1408.0 1417.6 Other income and exp
    Income before taxes
    Land, building and equipment, net 853.8 1364.4 1380.8 1430.2 1440.2 Less: Income before t
    Other assets 8.6 221.00 324.6 318.8 349.6 Net income
    Total Assets 2167.0 2728.6 2950.6 3157.00 3207.4

    Liabilities and Equity


    Current Liabilities
    Accounts Payable 375.0 362.8 345.2 303.0 320.8
    Notes Payable 112.6 210.2 177.0 123.2 86.6
    Other current liabilities 147.4 38.2 50.2 69.4 57.6
    Total current liabilities 635.0 611.2 572.4 495.6 465.0
    Long-term liabilities (4%) 325.0 532.0 481.0 457.8 401.0
    Total Liabilities 960.0 1143.2 1053.4 953.4 866.0

    Equity
    Share Capital (P100 par) common 850.0 1050.0 1240.0 1240.0 1240.0
    Additional paid-in capital 140.0 240.0 320.0 320.0 320.0
    Retained Earnings 217.0 295.4 337.2 643.6 781.4
    Total Equity 1207.0 1585.4 1897.2 2203.6 2341.4
    Total liabilities and equity 2167.0 2728.6 2950.6 3157.0 3207.4
    Gilbert Company
    Income Statement
    For the Years Ended December 31, 2015-2019 For the Ye
    (P000's)

    2015 2016 2017 2018 2019


    Net Sales 1707.4 1719.6 2402.4 2682.6 2983.6 Net Sales
    Cost of Goods sold 1248.2 1255.4 1722.6 1928.8 2109.4 Cost of Goods sold
    Gross margin on sales 459.2 464.2 679.8 753.8 874.2 Gross margin on sales
    Operating expenses Operating expenses
    Selling expenses 230.4 232.2 365.2 421.2 507.2
    General and administrative expenses 99.0 108.2 158.4 163.6 185.0
    Total operating expenses 329.4 340.4 523.6 584.8 692.2
    Operating income 129.8 123.8 156.2 169.0 182.0 Operating income
    Other income and expenses, net (deduct) -20.6 -17 -26.4 -21.4 -15.0 Other income and expenses,
    Income before taxes 109.2 106.8 129.8 147.6 167.0 Income before taxes
    Less: Income before taxes 51.2 53.4 65 53.8 62.6 Less: Income before taxes
    Net income 58.0 53.4 64.8 93.8 104.4 Net income
    Gilbert Company
    Income Statement
    For the Years Ended December 31, 2015-2019
    (P000's)

    2015 2016 2017 2018 2019


    100% 1719.6 2402.4 2682.6 2983.6
    Cost of Goods sold 73.1% 1255.4 1722.6 1928.8 2109.4
    Gross margin on sales 26.9% 464.2 679.8 753.8 874.2
    Operating expenses
    Selling expenses 13.5% 232.2 365.2 421.2 507.2
    General and administ 5.8% 108.2 158.4 163.6 185.0
    Total operating expen 19.3% 340.4 523.6 584.8 692.2
    Operating income 7.6% 123.8 156.2 169.0 182.0
    Other income and expenses, net -1.2% -17 -26.4 -21.4 -15.0
    Income before taxes 6.4% 106.8 129.8 147.6 167.0
    Less: Income before taxes 3.0% 53.4 65 53.8 62.6
    Net income 3.4% 53.4 64.8 93.8 104.4
    Gilbert Company
    Statement of Financial Position
    December 31, 2015-2019
    (P000's)

    December
    Assets 2015 2016 2017 2018 2019 Net Sales
    Current Assets Cost of Goods sold
    Cash 100.0 208.0 209.0 263.0 296.0 Gross margin on sale
    Marketable Securities 100.0 37.0 38.0 38.0 43.0
    Trade Receivables, net 100.0 78.0 88.0 103.0 112.0
    Inventory 100.0 111.0 123.0 136.0 128.0 Other income and ex
    Other current assets 100.0 83.0 85.0 86.0 58.0 Net income
    Total current assets 100.0 88.0 95.0 108.0 109.0

    Land, building and equipment, net 100.0 160.0 162.0 168.0 169
    Other assets 100.0 2570.0 3774.0 3707.0 4065
    Total Assets 100.0 126.0 136.0 146.0 148

    Liabilities and Equity


    Current Liabilities
    Accounts Payable 100.0 97.0 92.0 81.0 86.0
    Notes Payable 100.0 187.0 157.0 109.0 77.0
    Other current liabilities 100.0 26.0 34.0 47.0 39.0
    Total current liabilities 100.0 96.0 90.0 78.0 73.0
    Long-term liabilities (4%) 100.0 164.0 148.0 141.0 123.0
    Total Liabilities 100.0 119.0 110.0 99.0 90.0

    Equity
    Share Capital (P100 par) common 100.0 124.0 146.0 146.0 146.0
    Additional paid-in capital 100.0 171.0 229.0 229.0 229.0
    Retained Earnings 100.0 136.0 155.0 27.0 360.0
    Total Equity 100.0 131.0 157.0 183.0 194.0
    Total liabilities and equity 100.0 126.0 136.0 146.0 148.0
    Gilbert Company
    Income Statement
    For the Years Ended December 31, 2015-2019
    (P000's)

    2015 2016 2017 2018 2019


    Net Sales 100 101 141 157 175
    Cost of Goods sold 100 101 138 155 169
    Gross margin on sales 100 101 148 164 190
    Selling expenses 100 101 159 183 220
    General and administrative expenses 100 109 160 165 187
    Other income and expenses, net (deduct) 100 83 128 104 73
    Net income 100 92 112 162 180

    You might also like