Spreadsheet: 156012d1337145388-how-to-find-unique-data-from-a-larger-set-of-data-modelingexercises-completed
Sheet: DellModel

Instructions
Please create a basic income statement / EPS model for DELL below.
Please provide five years of history and two years of projections.
Be sure that the formulas behind all calculations are provided in your model.
Make sure the assumptions behind your forecast are clearly presented.
This model should be based on the same format as traditional Net Income and Earnings Per Share models found in the majority of stock analysts’ reports.
 |  |  |  |  |  |  | Basic assumptions: 1. Macroeconomic situation will remain similar to what it is in 2012 and be better than 2008 and 2009.
 |  |  |  |  |  |  | 2. Management will remain the same and so will DELL's business plan
 |  |  |  |  |  |  | 3. There will be no big change in selling costs or cost of goods sold.
Fiscal year is February-January. All values USD millions. | 2008 | 2009 | 2010 | 2011 | 2012 |  | 2013 | 2014
Sales/Revenue | 61130 | 61100 | 52900 | 61600 | 62260 |  | 62540 | 63450
Cost of Goods Sold (COGS) incl. D&A
[NAME] excluding D&A | 48910 | 49230 | 42550 | 49030 | 47320 |  | 49500 | 48600
Depreciation & Amortization Expense |  |  |  |  |  |  | 950 | 975
Depreciation | 580 | 666 | 647 | 620 | 545 |  | 600 | 580
Amortization of Intangibles | 27 | 103 | 205 | 350 | 391 |  | 340 | 375
Gross Income
 | 2008 | 2009 | 2010 | 2011 | 2012 |  | 2013 | 2014
SG&A Expense
Research & Development | 610 | 663 | 617 | 653 | 856 |  | 780 | 812
Other SG&A | 7540 | 6970 | 6230 | 7230 | 8520 |  | 8480 | 8700
Other Operating Expense | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Unusual Expense | 25 | 295 | 481 | 283 | 230 |  | 250 | 250
EBIT after Unusual Expense
Non Operating Income/Expense | -35 | 58 | -45 | 69 | 44 |  | 50 | 45
Non-Operating Interest Income | 496 | 180 | 57 | 47 | 81 |  | 56 | 95
Equity in Affiliates (Pretax) | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Interest Expense | 45 | 93 | 160 | 199 | 279 |  | 245 | 298
Gross Interest Expense
Interest Capitalized | - | - | - | 0 | 0 |  | 0 | 0
Pretax Income
Income Tax
Income Tax - Current Domestic | 901 | 465 | 527 | 663 | 456 |  | 500 | 545
Income Tax - Current Foreign | 287 | 295 | 116 | 97 | 273 |  | 122 | 167
Income Tax - Deferred Domestic | -308 | 86 | -12 | -86 | 50 |  | 12 | 66
Income Tax - Deferred Foreign | 0 | 0 | -40 | 41 | -31 |  | 3 | 32
Income Tax Credits | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Equity in Affiliates | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Other After Tax Income (Expense) | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Consolidated Net Income
Minority Interest Expense | 29 | 0 | 0 | 0 | 0 |  | 0 | 0
Net Income
Extraordinaries & Discontinued Operations | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Extra Items & Gain/Loss Sale Of Assets | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Cumulative Effect - Accounting Chg | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Discontinued Operations | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Net Income After Extraordinaries
Preferred Dividends | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Net Income Available to Common
EPS (Basic)
Basic Shares Outstanding | 2220 | 1980 | 1950 | 1940 | 1840 |  | 1825 | 1988
EPS (Diluted)
Diluted Shares Outstanding | 2250 | 1990 | 1960 | 1960 | 1850 |  | 1840 | 1998
EBITDA