Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    Practice Data Set Financialforecast Bottomup

    Uploaded by

    Tesfaye

    Copyright:

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

    Practice Data Set Financialforecast Bottomup

    Uploaded by

    Tesfaye
    36 views5 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Practice Data Set Financialforecast Bottomup

    Uploaded by

    Tesfaye

    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

    Ticker Symbol Years Period Ending Total Revenue Cost of Revenue

    1 NAVI Year 1 12/31/2013 $5,015,000,000 $1,844,000,000


    2 NAVI Year 2 12/31/2014 $5,115,000,000 $1,945,000,000
    3 NAVI Year 3 12/31/2015 $4,183,000,000 $1,479,000,000
    4 PYPL Year 1 12/31/2014 $8,025,000,000 $747,000,000
    5 PYPL Year 2 12/31/2015 $9,248,000,000 $792,000,000
    6 PYPL Year 3 12/31/2016 $10,842,000,000 $834,000,000
    7 QRVO Year 1 3/29/2014 $1,148,231,000 $940,573,000
    8 QRVO Year 2 3/28/2015 $1,710,966,000 $1,279,152,000
    9 QRVO Year 3 4/2/2016 $2,610,726,000 $2,009,936,000
    10 WRK Year 1 9/30/2014 $9,895,100,000 $7,961,500,000
    11 WRK Year 2 9/30/2015 $11,124,800,000 $8,986,500,000
    12 WRK Year 3 9/30/2016 $14,171,800,000 $11,413,200,000

    Ticker Symbol PYPL Year 1 Year 2

    Revenue $8,025,000,000 $9,248,000,000


    COGS $747,000,000 $792,000,000
    Gross Profit $7,278,000,000 $8,456,000,000
    Sales General and Admin $5,494,000,000 $6,339,000,000
    Other Operating Items $516,000,000 $608,000,000
    Total Operating Expenses $6,010,000,000 $6,947,000,000
    Operating Income/EBIT $1,268,000,000 $1,509,000,000

    Operating Statistics Historical Data


    Revenue Growth (%) 15.24%
    Gross Margin 0.907 0.914
    Operating Margin 0.158 0.163

    SCENARIO Base Case

    Operating Scenarios-sensitivity analysis

    Revenue Growth (%)


    1 Strong Case 1
    2 Base Case 2
    3 Weak Case 3

    Gross Margin
    1 Strong Case 1
    2 Base Case 2
    3 Weak Case 3

    Operating Margin
    1 Strong Case 1
    2 Base Case 2
    3 Weak Case 3
    Sales, General and A Other Operating Ite Gross Profit Operating Profit Gross Margin Operating Margin
    $446,000,000 $104,000,000 $3,171,000,000 $2,621,000,000 0.632 0.523
    $495,000,000 $122,000,000 $3,170,000,000 $2,553,000,000 0.620 0.499
    $545,000,000 $137,000,000 $2,704,000,000 $2,022,000,000 0.646 0.483
    $5,494,000,000 $516,000,000 $7,278,000,000 $1,268,000,000 0.907 0.158
    $6,339,000,000 $608,000,000 $8,456,000,000 $1,509,000,000 0.914 0.163
    $7,698,000,000 $724,000,000 $10,008,000,000 $1,586,000,000 0.923 0.146
    $180,317,000 $0.00 $207,658,000 $27,341,000 0.181 0.024
    $309,348,000 $0.00 $431,814,000 $122,466,000 0.252 0.072
    $588,822,000 $0.00 $600,790,000 $11,968,000 0.230 0.005
    $937,600,000 $86,000,000 $1,933,600,000 $910,000,000 0.195 0.092
    $1,026,100,000 $118,900,000 $2,138,300,000 $993,300,000 0.192 0.089
    $1,750,100,000 $211,800,000 $2,758,600,000 $796,700,000 0.195 0.056

    Year 3 Year 4 Year 5

    $10,842,000,000 $12,522,510,000 $14,463,499,050


    $834,000,000
    $10,008,000,000 $11,520,709,200 $13,306,419,126
    $7,698,000,000
    $724,000,000
    $8,422,000,000
    $1,586,000,000 $1,878,376,500 $2,169,524,858

    cal Data Assumption


    17.24% 15.50% 15.50%
    0.923 0.92 0.92
    0.146 0.15 0.15

    16.00% 17.00%
    15.50% 15.50%
    14.00% 14.00%

    0.93 0.93
    0.92 0.92
    0.9 0.9
    0.17 0.17
    0.15 0.15
    0.14 0.14
    erating Margin

    You might also like