Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Provide both a graphical and trend analysis of each of the following ratios: 1. current ratio (current assets/current liabilities) 2. gross profit margin (sales-cogs)/sales 3.
Provide both a graphical and trend analysis of each of the following ratios:
NIKE INCOME STATEMENT (SMID) 1998 1999 2000 2001 2002 2003 2004 2007 2005 2006 Revenue COGS 9,553.1 8,776.9 8,995,1 9,488.8 9,893.0 10,697,0 12,253.1 13,739.7 14,954.9 16,325.9 6,065,5 5,493.5 5,403.8 5,784.9 6,004,7 6,313,6 7,001.4 7,624.3 8,367.9 9,165.4 Gross Profit 3,487,6 3,283,4 3,591.3 3,703,9 3,888.3 4,383.4 5,251.7 6,115,4 6,587.0 7.160.5 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 SG&A Other 2,623.8 2,426.6 2,606,4 2,689.7 2,820,4 3,1376 3,702.04,221.7 4,477.85,028.7 150.8 66.6 20.7 34.1 3.0 0.0 0.0 0.0 0.0 0.0 Operating Income 713.0 790.2 964.2 980.1 1,064.9 1,245.8 1,549.7 1,893.7 2.109.22,131.8 Net Int Inc & Other (60.0) (44.1) (45.0) (58.7) (47.6) 37.0 49.7 24.3 (32.4) (68.1) 653.0 746,1 919.2 921.4.1.017.31.123.0 1,450.0 1,859.8 2.141.6 2 199.9 Earnings Before Taxes Income Taxes 253.4 294.7 340.1 331.7 349.0 382.9 504.4 648.2 749.6 708,4 399.6 451.4 579.1 589.7 668.3 740.1 945.61,211.61,392.01,491.5 Earnings After Taxes Acctg Changes (5.0) (266.1) Net Income 399.6 451.4 579.1 589.7 663.3 474.0 945.61,211.6 1,392.01,491.5 Assets (SMI) 1998 108.6 2007 1,856.7 1999 198.1 2000 254.3 2001 304.0 2003 634.0 2002 575.5 2006 9542 2004 8280 2005 1,388.1 436.6 9903 400.8 1,348.8 Cash and Equiv Short-Term Investments Accts Rec Inventory Other Current Assets 1,674,4 1,396.6 1,556.0 1,199.3 1,569.4 1,446.0 1,621.4 1,424.1 1,807.1 1,373.8 2,494.7 2,121.9 2,395.9 2,076.7 2.262.1 1,811.1 2,101.1 1,514.9 429.9 2,120.2 1,633.6 529.4 612.9 583.4 353.0 311.5 326.7 453.2 275.8 401.3 8,076.5 3,532.6 7,359.0 Total Current Assets 3,264.9 3,596.4 6,351.1 3,625.3 4,157.7 4,679.9 5,512.0 1,265.8 1,618.8 1.620.8 1,605.8 1,678.3 1,583.4 1,614.5 1,586.9 1,657.7 1.153.1 435.8 540.7 410.9 536.3 5017 426.6 437.8 397.3 541.5 183.8 Net PPBE Intangibles Other Long-Term Assets 275.9 295.2 233.0 229.4 316.6 290.4 266.2 392.8 178.2 291.0 Total Assets 5,397.4 5,247.7 5,856.9 5,819.6 6,443.0 6,713.9 7,891.6 8,793.6 9,869.6 10,688.3 2003 Liabilities and Owner's Equity ($Mil) 1998 1999 Accts Payable 584.6 373.2 Short-Term Debt 481.8 420.1 2000 543.8 974.3 2001 432.0 860.7 2002 504.4 480.5 572.7 2004 763.8 152.6 2005 843.9 76.0 2006 952.2 298.7 2007 1,040.3 131.3 281.1 Taxes Payable 28.9 0.0 21.9 83.0 107.2 118.2 95.0 85.5 109.0 Accrued abilities 608.5 653.6 621.9 472.1 768.3 1,054.2 974.4 984.3 1,286.9 1,303.4 Total Current Liabilities 1,703.8 1,446.9 2,140.0 1,786.7 1,836.2 2,015.2 2,009.0 1,999.2 2,623.3 2,584.0 Long-Term Debt 379.4 386.1 470.3 435.9 625.9 551.6 682.4 687.3 410.7 409.9 Other Long-Term Liabilities 52.6 80.1 110.6 102.5 141.9 156.4 418.5 463.2 550.4 669.3 Total Liabilities 2,135.8 1,913.1 2,720.9 2,325.1 2,604.0 2,723.2 3,109.9 3,149.7 3,584.4 3,663.2 Owner's Equity 3,261.6 3,334.6 3,136.0 3,494.5 3,839.0 3,990.7 4,781.7 5,643.9 6,285.2 7,025.1 Total Liabilities & Owner's Equity 5,397.4 5,247.7 5,856.9 5,819.6 6,443.0 6,713.9 7,891.6 8,793.6 9,869.6 10,688.3 1. current ratio (current assets/current liabilities)
2. gross profit margin (sales-cogs)/sales
3. inventory turnover (sales/inventory)
4. return on sales (net income/sales)
5. return on assets (net income/assets)
6. return on equity (net income/equity)
7. debt (debt/equity)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started