Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Lab1- Maysha Ahmed Neha- Mis107.1

    Uploaded by

    Maysha Ahmed Neha 1931839630
    Nazmul Hassan Sir, MIS107 LAB 1, Excel Assignment

    Copyright:

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

    Lab1- Maysha Ahmed Neha- Mis107.1

    Uploaded by

    Maysha Ahmed Neha 1931839630
    3 views5 pages
    Nazmul Hassan Sir, MIS107 LAB 1, Excel Assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Nazmul Hassan Sir, MIS107 LAB 1, Excel Assignment

    Copyright:

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

    Lab1- Maysha Ahmed Neha- Mis107.1

    Uploaded by

    Maysha Ahmed Neha 1931839630
    Nazmul Hassan Sir, MIS107 LAB 1, Excel Assignment

    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

    Total revenue 5254 5525 6278 7219.

    7 9783 8756
    Cost of goods sold 2850 2869 2998 1850 1250 1459
    Gross profit
    Selling, general & administrative 1065 1125 1348 1550.2 1551.2 1467.3
    Depreciation & Amortization 240 240 400 460 461 455
    Operating income
    Interest expense 102 106 108 124.2 134.23 130.34
    Pretax income
    Taxes 209.37 248.85 299.04 343.896 344.896 304.45
    Net income

    Analysis question
    10 years Total NI
    10 years average NI
    10 years Max NI
    10 yeaMax Growth
    10 years Min Growth
    10 years average YOY Growth

    Net Income above average?


    YoY Growth below average%
    9965 7561.23 10145.18 12456.78
    2267.9 1806.45 3467.78 3743.45

    1634.3 1730.45 2010.32 2217.67


    449 465 567 623

    136.43 126.27 141.89 151.45

    346.76 344.65 445.64 501.67


    Income statement 2010 2011 2012 2013
    Total revenue $ 5,254 $ 5,525 $ 6,278 $ 7,220
    Cost of goods sold $ 2,850 $ 2,869 $ 2,998 $ 1,850
    Gross profit $ 2,404 $ 2,656 $ 3,280 $ 5,370
    Selling, general & administrative $ 1,065 $ 1,125 $ 1,348 $ 1,550
    Depreciation & Amortization $ 240 $ 240 $ 400 $ 460
    Operating income $ 1,099 $ 1,291 $ 1,532 $ 3,360
    Interest expense $ 102 $ 106 $ 108 $ 124
    Pretax income $ 997 $ 1,185 $ 1,424 $ 3,235
    Taxes $ 209 $ 249 $ 299 $ 344
    Net income $ 788 $ 936 $ 1,125 $ 2,891
    YOY Growth % 19% 20% 157%

    Analysis
    10 years Total NI $ 33,673
    10 years average NI $ 3,367
    10 years Max NI $ 6,042
    10 years Max Growth 1.57022827
    10 years Min Growth -0.3980423
    10 years average YOY Growth 35%

    Net Income above average $ 3,367? No No No No


    YoY Growth below average 76% Yes Yes Yes No

    Visuals

    Revenue VS. Net Income


    $14,000
    $12,000
    $10,000
    $8,000
    $6,000
    $4,000
    $2,000
    $-
    2010 2011 2012 2013 2014 2015 2016 2017 2018 2019

    Total revenue Net income


    Moving average (Net income)
    2014 2015 2016 2017 2018 2019
    $ 9,783 $ 8,756 $ 9,965 $ 7,561 $ 10,145 $ 12,457
    $ 1,250 $ 1,459 $ 2,268 $ 1,806 $ 3,468 $ 3,743
    $ 8,533 $ 7,297 $ 7,697 $ 5,755 $ 6,677 $ 8,713
    $ 1,551 $ 1,467 $ 1,634 $ 1,730 $ 2,010 $ 2,218
    $ 461 $ 455 $ 449 $ 465 $ 567 $ 623
    $ 6,521 $ 5,375 $ 5,614 $ 3,559 $ 4,100 $ 5,873
    $ 134 $ 130 $ 136 $ 126 $ 142 $ 151
    $ 6,387 $ 5,244 $ 5,477 $ 3,433 $ 3,958 $ 5,721
    $ 345 $ 304 $ 347 $ 345 $ 446 $ 502
    $ 6,042 $ 4,940 $ 5,131 $ 3,088 $ 3,513 $ 5,220
    109% -18% 4% -40% 14% 49%

    Yes Yes Yes No Yes Yes


    No Yes Yes Yes Yes Yes
    Trend Line

    You might also like