How do you do a DuPont Analysis and a DuPont Analysis with operating ratios? I need to know how to enter the figures into a spreadsheet or calculator.

Explain how to do a DuPont Analysis and a Dupont Analysis with operating ratios. How is the figure into the computer or an excel spreadsheet? For the Years Ended Net Sales Other income Cost and expenses Cost of goods sold R&D General and selling Interest Other 2011 1,600,000 22,100 1,622,100 2010 1,300,000 21,500 1,321,500 2009 1,200,000 21,000 1,221,000 740,000 90,000 600,000 19,000 14,000 1,463,000 624,000 78,000 500,500 18,200 13,650 1,234,350 576,000 71,400 465,000 17,040 13,800 1,143,240 2011 Earnings before income taxes and noncontrolling interest Provision for income taxes Earnings before noncontrolling interest Noncontrolling interest Net earnings 2010 2009 159,100 87,150 77,760 62,049 35,731 32,659 97,051 51,419 45,101 10,200 86,851 8,500 42,919 8,100 37,001 For the Years Ended 2011 Other relevant financial information Average common shares issued Average long-term debt Average stockholder's equity (all common) Average total assets Average operating assets 2010 2009 29,610 29,100 28,800 211,100 121,800 214,000 811,200 790,100 770,000 1,440,600 1,390,200 1,220,000 1,160,000 1,180,000 1,090,000