Income-statement-excel(含计算公式可修改)

ConsolidatedIncomeStatements(inUS$thousandsexceptshares&pershareamounts)ActualsEstimatesForthefiscalyearendedMarch3,20122010A2011A2012A2013ERevenue$49,243.0$49,747.0$50,705.049,082.4Y/Yrevenuegrowth(%)1%2%-3%Costofgoodssold36,363.036,190.037,130.036,075.6COGSasa%ofrevenue74%73%73%74%Grossprofit$12,880.0$13,557.0$13,575.0$13,006.8Grossprofitmargin(%)26%27%27%27%OperatingexpensesSelling,generalandadministrative9,755.010,325.010,451.010,552.7SG&Aasa%ofrevenue19.8%20.8%20.6%21.5%Other0.00.00.00.0Totaloperatingexpenses9,755.010,325.010,451.010,552.7Equityinearningsofunconsolidatedaffiliates0.00.00.00.0EBITDA3,125.03,232.03,124.02,454.1EBITDAmargin(%)6.3%6.5%6.2%5.0%Depreciation838.0896.0897.0905.2Amortization88.082.048.046.5AdjustedEBIT2,199.02,254.02,179.01,502.4EBITmargin(%)4.5%4.5%4.3%3.1%Operatingincome(GAAP)2,368.02,374.01,085.00.0InterestInterestexpense92.086.0134.076.7Interestincome(53.0)(43.0)(37.0)(0.3)Gainonsaleofinvestments0.00.00.00.0Netinterestexpense39.043.097.076.4Incomebeforetax(IBT)2,160.02,211.02,082.01,426.0IBTmargin(%)4%4%4%3%Incometaxexpense836.0781.0705.0482.9All-ineffectivetaxrate(%)39%35%34%34%Netincomefromcontinuingops1,324.01,430.01,377.0943.1Non-recurringeventsRestructuringcharges-COGS31.95.812.00.0Restructuringcharges0.086.925.80.0BestBuyEuropetransactioncosts-SG&A0.00.030.40.0Goodwillimpairment0.00.01,180.00.0Gainonsaleofinvestments0.00.048.00.0Restructuringcharges–NCI0.00.0(4.0)0.0BestBuyEuropetransactioncosts-NCI0.00.0(13.0)0.0BBYMprofitsharebuyout-NCI0.00.01,303.00.0Discontinuedoperations0.00.00.00.0Restructuringcharges-COGS0.010.08.00.0Restructuringcharges0.044.0178.00.0Restructuringcharges–NCI0.00.0(85.0)0.0Totalnon-recurringevents31.9146.82,683.20.0Netincome1,292.11,283.21,306.2943.1Dividendpayout(234.0)(237.0)(228.0)(141.5)%ofnetincome18.1%18.5%17.5%15.0%Persharedividend0.550.570.620.39AdjustedEarningspershareBasic$3.10$3.16$3.57$2.57Diluted$3.02$3.08$3.57$2.57Earningspershare(GAAP)$3.10$3.14($3.36)$0.00AveragecommonsharesoutstandingBasic416.8406.1366.3366.3Diluted427.5416.5366.3366.3Estimates2014E2015E2016E2017E2018E48,100.847,138.846,196.046,658.047,124.5-2%-2%-2%1%1%35,402.234,694.134,000.334,340.334,683.774%74%74%74%74%$12,698.6$12,444.6$12,195.7$12,317.7$12,440.926%26%26%26%26%10,389.810,182.09,978.310,078.110,178.921.6%21.6%21.6%21.6%21.6%0.00.00.00.00.010,389.810,182.09,978.310,078.110,178.90.00.00.00.00.02,308.82,262.72,217.42,239.62,262.04.8%4.8%4.8%4.8%4.8%943.7981.71,016.41,050.61,084.745.544.643.744.244.61,319.61,236.31,157.31,144.91,132.62.7%2.6%2.5%2.5%2.4%0.00.00.00.00.09.90.00.00.00.0(3.0)(8.2)(13.8)(18.2)(23.9)0.00.00.00.00.06.9(8.2)(13.8)(18.2)(23.9)1,312.71,244.51,171.11,163.01,156.53%3%3%2%2%444.5421.4396.5393.8391.634%34%34%34%34%868.2823.1774.5769.2764.90.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0868.2823.1774.5769.2764.9(130.2)(123.5)(116.2)(115.4)(114.7)15.0%15.0%15.0%15.0%15.0%0.360.340.320.310.31$2.37$2.25$2.11$2.10$2.09$2.37$2.25$2.11$2.10$2.09$0.00$0.00$0.00$0.00$0.00366.3366.3366.3366.3366.3366.3366.3366.3366.3366.3