solve using excel

1 Du Pont Analysis 2 3 Inputs - Income Statement 4 Sales 5 CGS $3,074,000.00 6 Operating Expenses $2,088,000.00 7 Interest Expense $568,000.00 8 Taxes $93,000.00 9 Prefered Stock Dividends $94,000.00 10 $10,000.00 11 Inputs- Balance- Sheet 12 Current Assets $1,223,000.00 $2,374,000.00 $620,000.00 $1,023,000.00 $200,000.00 $1,754,000.00 Fixed Assets Current Liabilities Long Term Debt Share Hodler Equity Preffered Sharehodler Equity -Common $1,754,000.00 Calculated Variables Earnings Available to common Share Holders Assets/Liabilities Balance Total Assets or Liabilites+Equity OK Outputs Net Profit Margin Total Asset Turnover Return on Assets Financial Leverage Multiplier Return on Common Equity]