Spreadsheet: 108183d1305235781-changing-conditional-formatting-based-on-a-reference-kessler-1
Sheet: Dupont Analysis

DuPont Analysis
Item | 2006 | 2007 | 2008 | 2009 | 2010
Sales
Net Income
total assets | 2649744 | 2693823 | 3129881 | 8192161 | 7974853
Total shareholder equity | 1728059 | 1795657 | 1799853 | 4939931 | 5326320
Return on Sales
Total asset Turnover
Equity Multiplier
ROE
 |  |  |  |  |  |  |  |  |  | 2154726.07421875 | 2148017.08984375 | 2524773.92578125 | 3757933.10546875 | 4605.2890625
[NAME] as a percent of Sales |  |  |  |  |  |  |  |  |  |  | Balance Sheet
Item | 2006 | 2007 | 2008 | 2009 | 2010 | 2 year average | 5 year average |  |  | 2006 | 2007 | 2008 | 2009 | 2010
Cash |  |  |  |  |  |  |  |  | Cash | 71956 | 200119 | 184175 | 456693 | 283570
Recievables less bad debt |  |  |  |  |  |  |  |  | Recievables less bad debt | 148014 | 124048 | 162426 | 266037 | 238867
Inventory |  |  |  |  |  |  |  |  | Inventory | 297621 | 286052 | 379608 | 603926 | 654939
Other Current Assets |  |  |  |  |  |  |  |  | Other Current Assets |  | 29147 | 49998 | 72235 | 46254
Total Current Assets |  |  |  |  |  |  |  |  | Total Current Assets
Property Plant & Equipment |  |  |  |  |  |  |  |  | Property Plant & Equipment | 527735 | 454028 | 496296 | 838433 | 858313
Intangibles |  |  |  |  |  |  |  |  | Intangibles | 472915 | 478194 | 614000 | 3098976 | 3026515
Total of other non-current assets |  |  |  |  |  |  |  |  | Total of other non-current assets | 1077599 | 1122235 | 1243378 | 2855861 | 2866395
Total Assets |  |  |  |  |  |  |  |  | Total Assets
Accounts Payable |  |  |  |  |  |  |  |  | Accounts Payable | 88963 | 93500 | 119844 | 198954 | 179509
Income Taxes |  |  |  |  |  |  |  |  | Income Taxes | 13584 | 7265 | 1164 | 17690 | 75977
Dividends payable |  |  |  |  |  |  |  |  | Dividends payable | 15946 | 17034 | 17479 | 41448 | 47648
Current portion of long-term debt |  |  |  |  |  |  |  |  | Current portion of long-term debt | 0 | 33000 | 0 | 276726 | 10000
Notes Payable |  |  |  |  |  |  |  |  | Notes Payable | 28620 | 0 | 0 | 350000 | 0
Other Current Liabilities |  |  |  |  |  |  |  |  | Other Current Liabilities
Total Current Liabilities |  |  |  |  |  |  |  |  | Total Current Liabilities
Long-Term Debt |  |  |  |  |  |  |  |  | Long-Term Debt | 428602 | 392643 | 789684 | 910000 | 900000
Deffered income taxes |  |  |  |  |  |  |  |  | Deffered income taxes | 155579 | 158418 | 175950 | 1145808 | 1101506
Other non-current Liabilities |  |  |  |  |  |  |  |  | Other non-current Liabilities
Total Noncurrent Liabilities |  |  |  |  |  |  |  |  | Total Noncurrent Liabilities
Total Liabilities |  |  |  |  |  |  |  |  | Total Liabilities
Total Shareholders equity |  |  |  |  |  |  |  |  | Total Shareholders equity | 1728059 | 1795657 | 1799853 | 4939931 | 5326320
Total Liabilities&Shareholder equity |  |  |  |  |  |  |  |  | Total Liabilities&Shareholder equity
Pro-Forma Balance Sheet
Item | 2011 | 2012 | 2013 | 2014 | 2015
Cash
Recievables less bad debt
Inventory
Other Current Assets
Total Current Assets
Property Plant & Equipment
Intangibles
Total of other non-current assets
Total Assets
Accounts Payable
Income Taxes
Dividends payable
Current portion of long-term debt
Notes Payable
Other Current Liabilities
Total Current Liabilities
Long-Term Debt
Deffered income taxes
Other non-current Liabilities
Total Noncurrent Liabilities
Total Liabilities
Total Shareholders equity
Total Liabilities&Shareholder equity
Sales Projections | 4851426.666666667 | 5763494.88 | 6847031.91744 | 8134273.91791872 | 9663517.41448744