Fill out the spreadsheet for Nestlé (NSRGY)
Nestlé (NSRGY) Abstract of Valuation Outcomes Mar-14 Technique 1: Dividend Low cost Mannequin $76.83 Technique 2: Working Free Money Movement $74.03 Technique three: Free Money Movement to Fairness $77.04 Common $75.97 Market Worth at Mar 25, 2014: $74.60 Nestlé (NSRGY) Consolidated Statements of Revenue 12 months ended December 31 31/12/2008 31/12/2009 31/12/2010 31/12/2011 (In tens of millions besides per share knowledge) 12 Months 12 Months 12 Months 12 Months Internet working revenues $31,944 $30,990 $35,119 $46,542 Price of products bought 11,374 11,088 12,693 18,216 Gross revenue 20,570 19,902 22,426 28,326 SG&A bills 11,774 11,358 13,158 17,440 Different working costs 350 313 819 732 Working earnings eight,446 eight,231 eight,449 10,154 Curiosity earnings (internet) 333 249 317 483 Curiosity expense 438 355 733 417 Fairness income-net (874) 781 1,025 690 Different earnings (loss)-net 39 40 5,185 529 Positive aspects on issuances of inventory by fairness investees - - - - EBT earlier than cumulative impact of accounting change 7,506 eight,946 14,243 11,439 Revenue taxes 1,632 2,040 2,384 2,805 Internet earnings earlier than cumulative impact of accounting change 5,874 6,906 11,859 eight,634 Internet earnings after cumulative impact of accounting change and different changes 5,807 6,824 11,809 eight,572 Common shares excellent 2,315 2,315 2,333 2,323 Internet earnings per share $2.51 $2.95 $5.06 $three.69 Dividends paid per share $1.52 $1.64 $1.76 $1.88 Nestlé (NSRGY) Consolidated Steadiness Sheets 12 months ended December 31 31/12/2007 31/12/2008 31/12/2009 31/12/2010 31/12/2011 (In tens of millions besides per share knowledge) 12 Months 12 Months 12 Months 12 Months 12 Months ASSETS Money & money equivalents $four,093 $four,701 $7,021 $eight,517 $12,803 ST investments and Marketable securities 215 278 2,192 2,820 1,232 Complete money & mktable sec four,308 four,979 9,213 11,337 14,zero35 Accounts receivable three,317 three,090 three,758 four,430 four,920 Inventories 2,220 2,187 2,354 2,650 three,092 Pay as you go bills and different belongings 2,260 1,920 2,226 three,162 three,450 Complete present belongings $12,105 $12,176 $17,551 $21,579 $25,497 Complete Lengthy Time period Investments $7,777 $5,779 $6,755 $7,585 $eight,374 Different belongings $2,675 $1,733 $1,976 $2,121 $three,495 Complete make investments. & different belongings $10,452 $7,512 $eight,731 $9,706 $11,869 Property, plant & tools Land - - - - - Buldings and enhancements eight,493 eight,326 9,561 14,727 14,939 Equipment and tools - - - - - Containers - - - - - Complete Gross PP&E $eight,493 $eight,326 $9,561 $14,727 $14,939 Much less allowances for depreciation - - - - - Internet PP&E $eight,493 $eight,326 $9,561 $14,727 $14,939 Goodwill & Logos four,256 10,088 10,407 18,021 18,649 Different Intangible Property 7,963 2,417 2,421 eight,888 9,020 Complete belongings $43,269 $40,519 $48,671 $72,921 $79,974 Liabilities A/P and accrued bills $6,915 $6,205 $6,657 $eight,859 $9,009 Loans & notes payable 5,919 6,066 6,749 eight,100 12,871 Present portion of long-term debt 133 465 51 1,276 2,zero41 Accrued earnings taxes 258 252 264 273 362 Complete present liabilities $13,225 $12,988 $13,721 $18,508 $24,283 Lengthy-term debt three,277 2,781 5,059 14,zero41 13,656 Different liabilities three,133 three,401 three,512 5,108 5,706 Deferred Revenue Taxes 1,890 877 1,580 four,261 four,694 Complete long-term liabilities $eight,300 $7,059 $10,151 $23,410 $24,056 Complete liabilities $21,525 $20,047 $23,872 $41,918 $48,339