Management homework help

1.compute the following ratios for two years of Boeing Company . You may use Excel to compute your ratios.
 
Debt ratio
 
Gross profit margin
 
Free cash flow
 
Times interest earned
 
Accounts receivable turnover
 
Inventory turnover
 
 
 
2.Prepare a DuPont Analysis of ROE for two years, including computations of
 
Return on Sales
 
Asset Turnover
 
Return on Assets
 
Financial Leverage
 
Return on Equity
 
 
 
Briefly evaluate the ratio trends. Indicate on your worksheet whether each ratio is:
 
stronger / weaker
 
quicker /slower
 
more / less liquid
 
more / less risk
 
 
 
6-7 pages report evaluating trends in all of the above ratios. Discuss whether your company’s profitability, efficiency, liquidity, and solvency are improving or deteriorating. Suggest ways the company can improve the ratios that show problems. The report should be well written with cover page, introduction, the body of the paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited.