Question

In: Finance

1) Organize the Results in assending order from 2008 to 2017 in both Income Statement (P&L)...

1) Organize the Results in assending order from 2008 to 2017 in both Income Statement (P&L) and Balance Sheet
2) Format your numbers with a comma
P&L Graphs- Does Not matter
2) Make a line/bar graph that compares the trend of sales vs. profits (P&L Statement)
3) Make a pie graph that shows costs, expenses and net income for 2008 and 2017
Balance Sheet Graphs
4) Make a graph to show the trend of Capital Structure (Total Assets, Total Liabilities, Total Equity) 2008 to 2017
5) Make a pie graph to show the composition of Current Assets 2008 and 2017
Cash
Marketable Securities
Receivables
Inventory
Other Current Assets
6) Make a pie graph to show the composition of Non Current Assets
Net Property Plant And Equipment
Investment And Advances
Other Non Current Assets
Deferred Charges
Intangibles
Deposits And Other Assets

7) Make a Staked Colum graph that compares Current Liabilities to Total Liabilities

2017 2016 2015 2014 2013 2012 2011 2010 2009 2008
Shares Outstanding 3073.19 3201.89 3223.19 3229.18 3345.24 3424.7 3561.99 3810.17 3922.55 4004.81
Net Sales Or Revenues 485873 482130 485651 476294 469162 446950 421849 408214 405607 378799
Cost Of Goods Sold 361256 360984 365086 358069 352488 335127 315287 304657 306158 286515
Gross Profit 124617 121146 120565 118225 116674 111823 106562 103557 99449 92284
Research And Development Expense - - - - - - - - - -
Selling General And Admin Expense 101853 97041 93418 91353 88873 85265 81020 79607 76651 70288
Income Before Depreciation Depletion Amortization 22764 24105 27147 26872 27801 26558 25542 23950 22798 21996
Depreciation Depletion Amortization - - - - - - - - - -
Non Operating Income 100 81 113 119 187 162 201 181 284 305
Interest Expense 2367 2548 2461 2335 2251 2322 2205 2065 2184 2103
Pretax Income 20497 21638 24799 24656 25737 24398 23538 22066 20898 20198
Provisionfor Income Taxes 6204 6558 7985 8105 7981 7944 7579 7139 7145 6908
Minority Interest 650 386 736 673 757 688 604 513 499 406
Investment Gains Losses - - - - - - - - - -
Other Income - - - - - - - - - -
Income Before Extraordinaries And Disc Operations 14293 15080 16814 16551 17756 16454 15959 14927 13254 12884
Extraordinary Items And Discontinued Operations - - 285 144 - -67 1034 -79 146 -153
Net Income 13643 14694 16363 16022 16999 15699 16389 14335 13400 12731
Average Shares Used To Compute Diluted E P S 3112 3217 3243 3283 3389 3474 3670 3877 3951 4072
Average Shares Used To Compute Basic E P S 3101 3207 3230 3269 3374 3460 3656 3866 3939 4066
Income Before Non Recurring Items 13456.28 14758.34 16337.44 16731.58 16999 15660 14921 14204 13505 12965.32
Income From Non Recurring Items 186.72 -64.34 -259.44 -853.58 - 173 434 210 -251 -81.32
E P S Basic Net 4.4 4.58 5.07 4.9 5.04 4.54 4.48 3.71 3.4 3.13
E P S Diluted Net 4.38 4.57 5.05 4.88 5.02 4.52 4.47 3.7 3.39 3.13
E P S Diluted Before Non Recurring Items 4.32 4.59 5.07 5.11 5.02 4.49 4.07 3.66 3.42 3.18
Preferred Dividends Acc Pd - - - - - - - - - -
Dividends Common - - - - - - - - - -
Dividend Per Share Common 2 1.96 1.92 1.88 1.59 1.46 1.21 1.09 0.95 0.88
update Date 0 0 0 0 0 0 0 0 0 0
2017 2016 2015 2014 2013 2012 2011 2010 2009 2008
Shares Outstanding 3073.19 3201.89 3223.19 3229.18 3345.24 3424.7 3561.99 3810.17 3922.55 4004.81
Cash 6867 8705 9135 7281 7781 6550 7395 7907 7275 5569
Marketable Securities - - - - - - - - - -
Receivables 5835 5624 6778 6677 6768 5937 5089 4144 3905 3654
Inventory 43046 44469 45141 44858 43803 40714 36318 33160 34511 35180
Raw Materials - - - - - - - - - -
Work In Progress - - - - - - - - - -
Finished Goods - - - - - - - - - -
Notes Receivable - - - - - - - - - -
Other Current Assets 1941 1441 2224 2369 1588 1774 3091 3120 3258 3182
Total Current Assets 57689 60239 63278 61185 59940 54975 51893 48331 48949 47585
Property Plant And Equipment 179492 176958 177395 173089 165825 155002 148584 137848 125820 128384
Accumulated Depreciation 71782 66787 63115 57725 51896 45399 43486 38304 32964 31367
Net Property Plant And Equipment 114178 116516 116655 117907 116681 112324 107878 102307 95653 97017
Investment And Advances - - - - - - - - - -
Other Non Current Assets - - - - - - - - - -
Deferred Charges - - - - - - - - - -
Intangibles 17037 16695 18102 19510 20497 20651 16763 16126 15260 16071
Deposits And Other Assets 9921 6131 5671 6149 5987 5456 4129 3942 3567 2841
Total Assets 198825 199581 203706 204751 203105 193406 180663 170706 163429 163514
Notes Payable - - - - - - - - 1506 5040
Accounts Payable 41433 38487 38410 37415 38080 36608 33557 30451 28849 30370
Current Portion Of Long Term Debt 3355 5453 6402 11773 12392 6022 5686 4573 5848 5913
Current Portion Of Capital Leases 565 551 287 309 327 326 336 346 315 316
Accrued Expenses 20654 19607 19152 18793 18808 18154 18701 18734 18112 15799
Income Taxes Payable 921 521 1021 966 2211 1164 157 1365 677 1016
Other Current Liabilities - - - 89 - 26 47 92 83 -
Total Current Liabilities 66928 64619 65272 69345 71818 62300 58484 55561 55390 58454
Mortgages - - - - - - - - - -
Deferred Charges Taxes Income 9344 7321 8805 8017 7613 7862 6682 5508 6014 5111
Convertible Debt - - - - - - - - - -
Long Term Debt 36015 38214 41086 41771 38394 44070 40692 33231 31349 29799
Non Current Capital Leases 6003 5816 2606 2788 3023 3009 3150 3170 3200 3603
Other Long Term Liabilities - - - - - - - - - -
Total Liabilities 118290 115970 117769 123412 121367 117645 109416 97777 98144 98906
Minority Interest - - - 1491 519 404 408 307 2191 1939
Preferred Stock - - - - - - - - - -
Common Stock Net 305 317 323 323 332 342 352 378 393 397
Capital Surplus 2371 1805 2462 2362 3620 3692 3577 3803 3920 3028
Retained Earnings 89354 90021 85777 76566 72978 68691 63967 66638 63660 57319
Treasury Stock - - - - - - - - - -
Other Liabilities -11495 -8532 -2625 2088 4808 3036 3351 2110 -2688 3864
Shareholders Equity 80535 83611 85937 81339 81738 75761 71247 72929 65285 64608
Total Liabilities And Shareholders Equity 198825 199581 203706 204751 203105 193406 180663 170706 163429 163514
update Date 0 0 0 0 0 0 0 0 0 0

Solutions

Expert Solution

2008

2009

2010

2011

2012

2013

2014

2015

2016

2017

Net Sales Or Revenues

378,799.00

405,607.00

408,214.00

421,849.00

446,950.00

469,162.00

476,294.00

485,651.00

482,130.00

485,873.00

Cost Of Goods Sold

(286,515.00)

(306,158.00)

(304,657.00)

(315,287.00)

(335,127.00)

(352,488.00)

(358,069.00)

(365,086.00)

(360,984.00)

(361,256.00)

Gross Profit

    92,284.00

    99,449.00

103,557.00

106,562.00

111,823.00

116,674.00

118,225.00

120,565.00

121,146.00

124,617.00

Research And Development Expense

-

-

-

-

-

-

-

-

-

-

Selling General And Admin Expense

   (70,288.00)

   (76,651.00)

   (79,607.00)

   (81,020.00)

   (85,265.00)

   (88,873.00)

   (91,353.00)

   (93,418.00)

   (97,041.00)

(101,853.00)

Income Before Depreciation Depletion Amortization

    21,996.00

    22,798.00

    23,950.00

    25,542.00

    26,558.00

    27,801.00

    26,872.00

    27,147.00

    24,105.00

    22,764.00

Depreciation Depletion Amortization

-

-

-

-

-

-

-

-

-

-

Non Operating Income

        305.00

        284.00

        181.00

        201.00

        162.00

        187.00

        119.00

        113.00

          81.00

        100.00

Interest Expense

     (2,103.00)

     (2,184.00)

     (2,065.00)

     (2,205.00)

     (2,322.00)

     (2,251.00)

     (2,335.00)

     (2,461.00)

     (2,548.00)

     (2,367.00)

Investment Gains Losses

-

-

-

-

-

-

-

-

-

-

Other Income

-

-

-

-

-

-

-

-

-

-

Pretax Income

    20,198.00

    20,898.00

    22,066.00

    23,538.00

    24,398.00

    25,737.00

    24,656.00

    24,799.00

    21,638.00

    20,497.00

Provisionfor Income Taxes

     (6,908.00)

     (7,145.00)

     (7,139.00)

     (7,579.00)

     (7,944.00)

     (7,981.00)

     (8,105.00)

     (7,985.00)

     (6,558.00)

     (6,204.00)

Minority Interest

       (406.00)

       (499.00)

Income Before Extraordinaries And Disc Operations

    12,884.00

    13,254.00

    14,927.00

    15,959.00

    16,454.00

    17,756.00

    16,551.00

    16,814.00

    15,080.00

    14,293.00

Minority Interest

       (513.00)

       (604.00)

       (688.00)

       (757.00)

       (673.00)

       (736.00)

       (386.00)

       (650.00)

Extraordinary Items And Discontinued Operations

       (153.00)

        146.00

         (79.00)

      1,034.00

         (67.00)

               -  

        144.00

        285.00

-

-

Net Income

    12,731.00

    13,400.00

    14,335.00

    16,389.00

    15,699.00

    16,999.00

    16,022.00

  16,363.00

    14,694.00

    13,643.00

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Income statement The income statement, also known as the profit and loss (P&L) statement, provides a...
Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were incurred,...
Income statement The income statement, also known as the profit and loss (P&L) statement, provides a...
Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were incurred,...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
3. Income statement The income statement, also known as a profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as a profit and loss (P&L) statement, provides a snapshot of a company’s financial performance during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they are incurred, not...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
2. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
2. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders. The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT