Need business and finance help with ration calculation

User Generated

Jvyyvrr

Business Finance

Description

Kroger.xlsx calculation sheet where you should do that, and should be from 2003 to 2014, you have the result on ration sheet. Your calculation result should be as same as the ration sheet.

Unformatted Attachment Preview

BS 03-13 Kroger Company TICKER: SIC: GICS: ASSETS Cash & Equivalents Net Receivables Inventories Prepaid Expenses Other Current Assets Total Current Assets Gross Plant, Property & Equipment Accumulated Depreciation Net Plant, Property & Equipment Investments at Equity Other Investments Intangibles Deferred Charges Other Assets TOTAL ASSETS LIABILITIES Long Term Debt Due In One Year Notes Payable Accounts Payable Taxes Payable Accrued Expenses Other Current Liabilities Total Current Liabilities Long Term Debt Deferred Taxes Investment Tax Credit Minority Interest Other Liabilities TOTAL LIABILITIES EQUITY Preferred Stock - Redeemable Preferred Stock - Nonredeemable Total Preferred Stock Common Stock Capital Surplus Retained Earnings Less: Treasury Stock Common Equity TOTAL EQUITY TOTAL LIABILITIES & EQUITY COMMON SHARES OUTSTANDING ANNUAL BALANCE SHEET KR 5411 30101030 Jan-13 Jan-12 Jan-11 Jan-10 Jan-09 Jan-08 Jan-07 Jan-06 Jan-05 Jan-04 Jan-03 $ 1,193.00 $ 1,051.00 $ 5,146.00 @CF $ 569.00 -----------------$ 7,959.00 $ 29,370.00 $ 14,495.00 -----------------$ 14,875.00 $ $ 44.00 $ 1,234.00 $ $ 540.00 -----------------$ 24,652.00 $ 974.00 $ 949.00 $ 5,114.00 @CF $ 288.00 -----------------$ 7,325.00 $ 28,071.00 $ 13,607.00 -----------------$ 14,464.00 $ $ 50.00 $ 1,138.00 $ $ 499.00 -----------------$ 23,476.00 $ 1,491.00 $ 845.00 $ 4,966.00 @CF $ 319.00 -----------------$ 7,621.00 $ 26,716.00 $ 12,569.00 -----------------$ 14,147.00 $ $ 69.00 $ 1,140.00 $ $ 528.00 -----------------$ 23,505.00 $ 1,078.00 $ 909.00 $ 4,902.00 @CF $ 561.00 -----------------$ 7,450.00 $ 25,673.00 $ 11,744.00 -----------------$ 13,929.00 $ $ 68.00 $ 1,158.00 $ $ 488.00 -----------------$ 23,093.00 $ 894.00 $ 944.00 $ 4,859.00 @CF $ 509.00 -----------------$ 7,206.00 $ 23,900.00 $ 10,739.00 -----------------$ 13,161.00 $ $ 67.00 $ 2,271.00 $ $ 506.00 -----------------$ 23,211.00 $ 918.00 $ 786.00 $ 4,855.00 @CF $ 555.00 -----------------$ 7,114.00 $ 22,436.00 $ 9,938.00 -----------------$ 12,498.00 $ $ 75.00 $ 2,234.00 $ $ 378.00 -----------------$ 22,299.00 $ 803.00 $ 778.00 $ 4,609.00 @CF $ 565.00 -----------------$ 6,755.00 $ 20,982.00 $ 9,203.00 -----------------$ 11,779.00 $ $ 152.00 $ 2,268.00 $ $ 261.00 -----------------$ 21,215.00 $ 210.00 $ 686.00 $ 4,486.00 @CF $ 1,084.00 -----------------$ 6,466.00 $ 19,786.00 $ 8,421.00 -----------------$ 11,365.00 $ $ 119.00 $ 2,295.00 $ $ 237.00 -----------------$ 20,482.00 $ 144.00 $ 828.00 $ 4,356.00 @CF $ 1,078.00 -----------------$ 6,406.00 $ 19,203.00 $ 7,706.00 -----------------$ 11,497.00 $ $ 104.00 $ 2,264.00 $ $ 220.00 -----------------$ 20,491.00 $ 159.00 $ 740.00 $ 4,169.00 @CF $ 1,130.00 -----------------$ 6,198.00 $ 18,425.00 $ 7,247.00 -----------------$ 11,178.00 $ $ 85.00 $ 3,163.00 $ $ 139.00 -----------------$ 20,763.00 $ 171.00 $ 677.00 $ 4,175.00 @CF $ 543.00 $ 2,734.00 $ $ 4,524.00 $ $ 977.00 $ 2,822.00 -----------------$ 11,057.00 $ 6,145.00 $ 800.00 $ $ $ 2,436.00 -----------------$ 20,438.00 $ 1,315.00 $ $ 4,329.00 $ $ 1,056.00 $ 2,405.00 -----------------$ 9,105.00 $ 6,850.00 $ 647.00 $ $ $ 2,908.00 -----------------$ 19,510.00 $ 588.00 $ $ 4,227.00 $ $ 888.00 $ 2,367.00 -----------------$ 8,070.00 $ 7,304.00 $ 750.00 $ $ $ 2,083.00 -----------------$ 18,207.00 $ 579.00 $ $ 3,890.00 $ $ 786.00 $ 2,459.00 -----------------$ 7,714.00 $ 7,477.00 $ 568.00 $ $ $ 2,428.00 -----------------$ 18,187.00 $ 558.00 $ $ 3,822.00 $ $ 828.00 $ 2,421.00 -----------------$ 7,629.00 $ 7,505.00 $ 384.00 $ $ 95.00 $ 2,422.00 -----------------$ 17,940.00 $ 1,592.00 $ $ 4,050.00 $ $ 815.00 $ 2,232.00 -----------------$ 8,689.00 $ 6,529.00 $ 367.00 $ $ $ 1,800.00 -----------------$ 17,385.00 $ 906.00 $ $ 3,804.00 $ $ 796.00 $ 2,075.00 -----------------$ 7,581.00 $ 6,154.00 $ 722.00 $ $ $ 1,835.00 -----------------$ 16,292.00 $ 554.00 $ $ 3,550.00 $ $ 742.00 $ 1,869.00 -----------------$ 6,715.00 $ 6,678.00 $ 843.00 $ $ $ 1,856.00 -----------------$ 16,092.00 $ 71.00 $ $ 3,778.00 @CF $ 659.00 $ 1,808.00 -----------------$ 6,316.00 $ 7,900.00 $ 939.00 $ $ $ 1,796.00 -----------------$ 16,951.00 $ 248.00 $ $ 3,637.00 @CF $ 547.00 $ 1,733.00 -----------------$ 6,165.00 $ 8,116.00 $ 974.00 $ $ $ 1,523.00 -----------------$ 16,778.00 $ 352.00 $ $ 3,278.00 @CF $ 571.00 $ 1,407.00 $ $ -----------------$ $ 959.00 $ 3,451.00 $ 9,034.00 $ 9,237.00 -----------------$ 4,207.00 -----------------$ 4,207.00 -----------------$ 24,652.00 514.00 $ $ -----------------$ $ 959.00 $ 3,427.00 $ 7,727.00 $ 8,132.00 -----------------$ 3,981.00 -----------------$ 3,981.00 -----------------$ 23,476.00 561.00 $ $ -----------------$ $ 959.00 $ 3,394.00 $ 7,675.00 $ 6,732.00 -----------------$ 5,296.00 -----------------$ 5,296.00 -----------------$ 23,505.00 620.00 $ $ -----------------$ $ 958.00 $ 3,361.00 $ 6,751.00 $ 6,238.00 -----------------$ 4,832.00 -----------------$ 4,832.00 -----------------$ 23,093.00 642.00 $ $ -----------------$ $ 955.00 $ 3,266.00 $ 6,994.00 $ 6,039.00 -----------------$ 5,176.00 -----------------$ 5,176.00 -----------------$ 23,211.00 649.00 $ $ -----------------$ $ 947.00 $ 3,031.00 $ 6,358.00 $ 5,422.00 -----------------$ 4,914.00 -----------------$ 4,914.00 -----------------$ 22,299.00 663.00 $ $ -----------------$ $ 937.00 $ 2,755.00 $ 5,242.00 $ 4,011.00 -----------------$ 4,923.00 -----------------$ 4,923.00 -----------------$ 21,215.00 705.00 $ $ -----------------$ $ 927.00 $ 2,536.00 $ 4,330.00 $ 3,403.00 -----------------$ 4,390.00 -----------------$ 4,390.00 -----------------$ 20,482.00 723.00 $ $ -----------------$ $ 918.00 $ 2,432.00 $ 3,339.00 $ 3,149.00 -----------------$ 3,540.00 -----------------$ 3,540.00 -----------------$ 20,491.00 728.00 $ $ -----------------$ $ 913.00 $ 2,382.00 $ 3,517.00 $ 2,827.00 -----------------$ 3,985.00 -----------------$ 3,985.00 -----------------$ 20,763.00 743.00 $ $ $ 5,566.00 $ 17,429.00 $ 6,881.00 $ 10,548.00 $ $ 126.00 $ 3,595.00 $ $ 267.00 $ 20,102.00 $ 5,608.00 $ 8,222.00 $ 709.00 $ $ $ 1,713.00 $ 16,252.00 - $ $ 908.00 $ 2,317.00 $ 3,146.00 $ 2,521.00 $ 3,850.00 $ 3,850.00 $ 20,102.00 758.00 IS 03-13 Kroger Company TICKER: SIC: GICS: Sales Cost of Goods Sold Gross Profit Selling, General, & Administrative Expense Operating Income Before Deprec. Depreciation, Depletion, & Amortization Operating Profit Interest Expense Non-Operating Income/Expense Special Items Pretax Income Total Income Taxes Minority Interest Income Before Extraordinary Items & Discontinued Operations Preferred Dividends Available for Common Savings Due to Common Stock Equivalents Adjusted Available for Common Extraordinary Items Discontinued Operations Adjusted Net Income Earnings Per Share Basic Excluding Extra Items & Disc Op Earnings Per Share Basic Including Extra Items & Disc Op Earnings Per Share DilutedExcluding Extra Items & Disc Op Earnings Per Share Diluted Including Extra Items & Disc Op EPS Basic from Operations EPS Diluted from Ops Dividends Per Share Com Shares for Basic EPS Com Shares for Diluted EPS ANNUAL INCOME STATEMENT KR 5411 30101030 Jan-13 $ 96,751.00 $ 76,858.00 -----------------$ 19,893.00 Jan-12 $ 90,374.00 $ 71,494.00 -----------------$ 18,880.00 Jan-11 $ 82,189.00 $ 63,927.00 -----------------$ 18,262.00 Jan-10 $ 76,733.00 $ 58,958.00 -----------------$ 17,775.00 Jan-09 $ 76,000.00 $ 58,564.00 -----------------$ 17,436.00 Jan-08 $ 70,235.00 $ 53,779.00 -----------------$ 16,456.00 Jan-07 $ 66,111.00 $ 50,115.00 -----------------$ 15,996.00 Jan-06 $ 60,553.00 $ 45,565.00 -----------------$ 14,988.00 Jan-05 $ 56,434.00 $ 42,008.00 -----------------$ 14,426.00 Jan-04 $ 53,791.00 $ 39,460.00 -----------------$ 14,331.00 Jan-03 $ 51,760.00 $ 37,717.00 $ 15,592.00 -----------------$ 4,301.00 $ 15,011.00 -----------------$ 3,869.00 $ 14,462.00 -----------------$ 3,800.00 $ 14,046.00 -----------------$ 3,729.00 $ 13,518.00 -----------------$ 3,918.00 $ 12,799.00 -----------------$ 3,657.00 $ 12,488.00 -----------------$ 3,508.00 $ 11,688.00 -----------------$ 3,300.00 $ 11,273.00 -----------------$ 3,153.00 $ 10,744.00 -----------------$ 3,587.00 $ 10,252.00 $ 1,652.00 -----------------$ 2,649.00 $ 462.00 $ $ 115.00 -----------------$ 2,302.00 $ 794.00 $ 11.00 ------------------ $ 1,638.00 -----------------$ 2,231.00 $ 435.00 $ $ (953.00) -----------------$ 843.00 $ 247.00 $ (6.00) ------------------ $ 1,600.00 -----------------$ 2,200.00 $ 448.00 $ $ (18.00) -----------------$ 1,734.00 $ 601.00 $ 17.00 ------------------ $ 1,525.00 -----------------$ 2,204.00 $ 502.00 $ $ (1,113.00) -----------------$ 589.00 $ 532.00 $ (13.00) ------------------ $ 1,442.00 -----------------$ 2,476.00 $ 485.00 $ $ (25.00) -----------------$ 1,966.00 $ 717.00 @CF ------------------ $ 1,356.00 -----------------$ 2,301.00 $ 474.00 $ $ -----------------$ 1,827.00 $ 646.00 $ ------------------ $ 1,272.00 -----------------$ 2,236.00 $ 488.00 $ @CF -----------------$ 1,748.00 $ 633.00 $ ------------------ $ 1,265.00 -----------------$ 2,035.00 $ 510.00 $ @CF -----------------$ 1,525.00 $ 567.00 $ ------------------ $ 1,256.00 -----------------$ 1,897.00 $ 554.00 $ $ (1,053.00) -----------------$ 290.00 $ 390.00 $ ------------------ $ 1,209.00 -----------------$ 2,378.00 $ 586.00 $ $ (1,026.00) -----------------$ 766.00 $ 454.00 $ ------------------ $ 1,087.00 $ 1,497.00 $ -----------------$ 1,497.00 $ 602.00 $ -----------------$ 602.00 $ 1,116.00 $ -----------------$ 1,116.00 $ 70.00 $ -----------------$ 70.00 $ 1,249.00 $ -----------------$ 1,249.00 $ 1,181.00 $ -----------------$ 1,181.00 $ 1,115.00 $ -----------------$ 1,115.00 $ 958.00 $ -----------------$ 958.00 $ (100.00) $ -----------------$ (100.00) $ 312.00 $ -----------------$ 312.00 $ 1,233.00 $ - $ (12.00) -----------------$ 1,485.00 $ $ -----------------$ 1,485.00 $ (4.00) -----------------$ 598.00 $ $ -----------------$ 598.00 $ (7.00) -----------------$ 1,109.00 $ $ -----------------$ 1,109.00 $ (1.00) -----------------$ 69.00 $ $ -----------------$ 69.00 $ -----------------$ 1,249.00 $ $ -----------------$ 1,249.00 $ -----------------$ 1,181.00 $ $ -----------------$ 1,181.00 $ -----------------$ 1,115.00 $ $ -----------------$ 1,115.00 $ -----------------$ 958.00 $ $ -----------------$ 958.00 $ -----------------$ (100.00) $ $ -----------------$ (100.00) $ -----------------$ 312.00 $ $ -----------------$ 312.00 $ $ 2.78 $ 1.01 $ 1.75 $ 0.11 $ 1.92 $ 1.71 $ 1.56 $ 1.32 $ (0.14) $ 0.42 $ 1.58 $ 2.78 $ 1.01 $ 1.75 $ 0.11 $ 1.92 $ 1.71 $ 1.56 $ 1.32 $ (0.14) $ 0.42 $ 1.55 $ 2.77 $ 1.01 $ 1.74 $ 0.11 $ 1.90 $ 1.69 $ 1.54 $ 1.31 $ (0.14) $ 0.41 $ 1.56 $ $ $ $ 2.77 2.65 2.63 0.50 533.40 536.60 $ $ $ $ 1.01 2.02 2.00 0.43 589.60 593.20 $ $ $ $ 1.74 1.77 1.76 0.39 635.20 638.30 $ $ $ $ 0.11 1.71 1.69 0.37 647.00 650.00 $ $ $ $ 1.90 1.93 1.92 0.34 652.00 659.00 $ $ $ $ 1.69 1.65 1.63 0.29 690.00 698.00 $ $ $ $ 1.54 1.59 1.57 0.19 715.00 723.00 $ $ $ $ 1.31 1.33 1.32 724.50 731.20 $ $ $ $ 0.41 1.52 1.49 747.20 753.80 $ $ $ $ 1.52 1.69 1.67 779.00 791.00 (0.14) 1.16 1.16 736.00 736.00 $ $ $ $ $ 14,043.00 $ 3,791.00 $ 2,704.00 $ 600.00 $ $ (131.00) $ 1,973.00 $ 740.00 $ - $ 1,233.00 - $ 1,233.00 $ (28.00) $ $ 1,205.00 Kroger Company DuPont Analysis Net Profitability Total Asset Turnover Equity Multiplier Return on Equity Financial Analysis Jan-13 Jan-12 Jan-11 Jan-10 Jan-09 1.55% 4.021 5.878 0.67% 3.847 5.064 1.36% 3.528 4.601 0.09% 3.314 4.627 1.64% 3.340 4.510 36.57% 12.98% 22.04% 1.40% 24.76% 20.56% 2.74% 1.55% 6.22% 36.57% 20.89% 2.47% 0.67% 2.56% 12.98% 22.22% 2.68% 1.36% 4.79% 22.04% 23.16% 2.87% 0.09% 0.30% 1.40% 22.94% 3.26% 1.64% 5.49% 24.76% 96.751 3.773 14.982 24.362 6.595 5.892 4.021 100.751 3.623 14.185 25.731 6.317 5.642 3.847 93.716 3.895 12.956 28.171 5.855 5.214 3.528 82.820 4.407 12.080 30.214 5.665 4.849 3.314 87.861 4.154 12.058 30.271 5.924 4.873 3.340 0.720 0.203 0.108 5.734 17.370 21.013 0.805 0.211 0.107 5.129 16.747 21.795 0.944 0.289 0.185 4.911 15.767 23.149 0.966 0.258 0.140 4.390 15.301 23.855 0.945 0.241 0.117 5.105 14.880 24.529 0.829 0.381 4.860 0.830 0.443 4.897 0.775 0.431 3.438 0.791 0.454 3.779 0.777 0.448 3.484 Profitability Analysis Gross Profitability Operating Profitability Net Profitability Return on Assets Return on Equity Efficiency Analysis Receivable Turnover Receivable DSO Inventory Turnover Inventory DCO Net PP&E Turnover Net Fixed Asset Turnover Total Asset Turnover Liquidity Analysis Current Ratio Quick Ratio Cash Ratio Times Interest Earned Accounts Payable Turnover Accounts Payable DCO Leverage Ratio Total Debt to Total Assets Long Term Term Debt to Total Assets Total Debt to Total Equity Jan-08 Jan-07 Jan-06 Jan-05 Jan-04 Jan-03 1.68% 3.228 4.424 1.69% 3.171 4.477 1.58% 2.956 5.167 -0.18% 2.736 5.482 0.58% 2.633 5.216 2.38% 24.01% 23.95% 24.16% -2.66% 7.96% 23.43% 3.28% 1.68% 5.43% 24.01% 24.20% 3.38% 1.69% 5.35% 23.95% 24.75% 3.36% 1.58% 4.68% 24.16% 25.56% 3.36% -0.18% -0.48% -2.66% 26.64% 4.42% 0.58% 1.53% 7.96% 89.815 4.064 11.365 32.116 5.786 4.738 3.228 90.316 4.041 11.020 33.121 5.713 4.643 3.171 79.991 4.563 10.306 35.415 5.297 4.310 2.956 71.982 5.071 9.855 37.036 4.978 3.940 2.736 75.922 4.808 9.458 38.590 4.952 3.697 2.633 0.819 0.196 0.106 4.854 13.757 26.531 0.891 0.209 0.106 4.582 13.663 26.715 0.963 0.133 0.031 3.990 12.471 29.267 1.014 0.154 0.023 3.424 11.381 32.071 1.005 0.146 0.026 4.058 11.411 31.986 0.993 0.151 0.030 4.507 0.780 0.390 3.538 0.768 0.411 3.309 0.786 0.458 3.666 0.827 0.519 4.788 0.808 0.511 4.210 0.808 0.529 4.221 27.13% 5.22% 2.38% Kroger Company TICKER: SIC: GICS: ASSETS Cash & Equivalents Net Receivables Inventories Prepaid Expenses Other Current Assets Total Current Assets Gross Plant, Property & Equipment Accumulated Depreciation Net Plant, Property & Equipment Investments at Equity Other Investments Intangibles Deferred Charges Other Assets TOTAL ASSETS LIABILITIES Long Term Debt Due In One Year Notes Payable Accounts Payable Taxes Payable Accrued Expenses Other Current Liabilities Total Current Liabilities Long Term Debt Deferred Taxes Investment Tax Credit Minority Interest Other Liabilities TOTAL LIABILITIES EQUITY Preferred Stock - Redeemable Preferred Stock - Nonredeemable Total Preferred Stock Common Stock Capital Surplus Retained Earnings Less: Treasury Stock ANNUAL BALANCE SHEET KR 5411 30101030 Jan-07 Jan-06 Jan-05 $ 803.00 $ 778.00 $ 4,609.00 @CF $ 565.00 -----------------$ 6,755.00 $ 20,982.00 $ 9,203.00 -----------------$ 11,779.00 $ $ 152.00 $ 2,268.00 $ $ 261.00 -----------------$ 21,215.00 $ 210.00 $ 686.00 $ 4,486.00 @CF $ 1,084.00 -----------------$ 6,466.00 $ 19,786.00 $ 8,421.00 -----------------$ 11,365.00 $ $ 119.00 $ 2,295.00 $ $ 237.00 -----------------$ 20,482.00 $ 144.00 $ 828.00 $ 4,356.00 @CF $ 1,078.00 -----------------$ 6,406.00 $ 19,203.00 $ 7,706.00 -----------------$ 11,497.00 $ $ 104.00 $ 2,264.00 $ $ 220.00 -----------------$ 20,491.00 $ 906.00 $ $ 3,804.00 $ $ 796.00 $ 2,075.00 -----------------$ 7,581.00 $ 6,154.00 $ 722.00 $ $ $ 1,835.00 -----------------$ 16,292.00 $ 554.00 $ $ 3,550.00 $ $ 742.00 $ 1,869.00 -----------------$ 6,715.00 $ 6,678.00 $ 843.00 $ $ $ 1,856.00 -----------------$ 16,092.00 $ 71.00 $ $ 3,778.00 @CF $ 659.00 $ 1,808.00 -----------------$ 6,316.00 $ 7,900.00 $ 939.00 $ $ $ 1,796.00 -----------------$ 16,951.00 $ $ -----------------$ $ 937.00 $ 2,755.00 $ 5,242.00 $ 4,011.00 ------------------ $ $ -----------------$ $ 927.00 $ 2,536.00 $ 4,330.00 $ 3,403.00 ------------------ $ $ -----------------$ $ 918.00 $ 2,432.00 $ 3,339.00 $ 3,149.00 ------------------ Common Equity TOTAL EQUITY TOTAL LIABILITIES & EQUITY COMMON SHARES OUTSTANDING $ 4,923.00 -----------------$ 4,923.00 -----------------$ 21,215.00 705 $ 4,390.00 -----------------$ 4,390.00 -----------------$ 20,482.00 723 $ 3,540.00 -----------------$ 3,540.00 -----------------$ 20,491.00 728 Jan-04 Jan-03 Jan-02 Jan-01 Jan-00 Jan-99 $ 159.00 $ 740.00 $ 4,169.00 @CF $ 1,130.00 -----------------$ 6,198.00 $ 18,425.00 $ 7,247.00 -----------------$ 11,178.00 $ $ 85.00 $ 3,163.00 $ $ 139.00 -----------------$ 20,763.00 $ 171.00 $ 677.00 $ 4,175.00 @CF $ 543.00 -----------------$ 5,566.00 $ 17,429.00 $ 6,881.00 -----------------$ 10,548.00 $ $ 126.00 $ 3,595.00 $ $ 267.00 -----------------$ 20,102.00 $ 161.00 $ 679.00 $ 4,178.00 @CF $ 494.00 -----------------$ 5,512.00 $ 15,677.00 $ 6,020.00 -----------------$ 9,657.00 $ $ $ 3,594.00 $ $ 324.00 -----------------$ 19,087.00 $ 161.00 $ 687.00 $ 4,066.00 @CF $ 502.00 -----------------$ 5,416.00 $ 14,241.00 $ 5,421.00 -----------------$ 8,820.00 $ $ $ 3,639.00 $ $ 315.00 -----------------$ 18,190.00 $ 281.00 $ 622.00 $ 3,938.00 @CF $ 690.00 -----------------$ 5,531.00 $ 13,042.00 $ 4,767.00 -----------------$ 8,275.00 $ $ $ 3,761.00 $ $ 399.00 -----------------$ 17,966.00 $ 121.43 $ 456.92 $ 1,730.16 @CF $ 364.68 -----------------$ 2,673.18 $ 6,861.93 $ 3,076.81 -----------------$ 3,785.12 @CF $ 67.31 $ 48.94 $ 52.32 $ 73.20 -----------------$ 6,700.07 $ 248.00 $ $ 3,637.00 @CF $ 547.00 $ 1,733.00 -----------------$ 6,165.00 $ 8,116.00 $ 974.00 $ $ $ 1,523.00 -----------------$ 16,778.00 $ 352.00 $ $ 3,278.00 @CF $ 571.00 $ 1,407.00 -----------------$ 5,608.00 $ 8,222.00 $ 709.00 $ $ $ 1,713.00 -----------------$ 16,252.00 $ 436.00 $ $ 3,005.00 $ $ 584.00 $ 1,460.00 -----------------$ 5,485.00 $ 8,412.00 $ 349.00 $ $ $ 1,339.00 -----------------$ 15,585.00 $ 336.00 $ $ 3,012.00 $ $ 604.00 $ 1,639.00 -----------------$ 5,591.00 $ 8,210.00 $ 249.00 $ $ $ 1,051.00 -----------------$ 15,101.00 $ 536.00 $ $ 2,867.00 $ $ 695.00 $ 1,630.00 -----------------$ 5,728.00 $ 8,934.00 $ 110.00 $ $ $ 511.00 -----------------$ 15,283.00 $ 175.20 $ $ 1,785.63 $ $ 536.93 $ 694.30 -----------------$ 3,192.07 $ 3,228.66 $ 200.95 $ $ $ 466.22 -----------------$ 7,087.90 $ $ -----------------$ $ 913.00 $ 2,382.00 $ 3,517.00 $ 2,827.00 ------------------ $ $ -----------------$ $ 908.00 $ 2,317.00 $ 3,146.00 $ 2,521.00 ------------------ $ $ -----------------$ $ 901.00 $ 2,217.00 $ 2,114.00 $ 1,730.00 ------------------ $ $ -----------------$ $ 891.00 $ 2,092.00 $ 1,104.00 $ 998.00 ------------------ $ $ -----------------$ $ 885.00 $ 2,023.00 $ 232.00 $ 457.00 ------------------ $ $ -----------------$ $ 281.79 $ 555.01 $ (773.61) $ 451.03 ------------------ $ 3,985.00 -----------------$ 3,985.00 -----------------$ 20,763.00 743 $ 3,850.00 -----------------$ 3,850.00 -----------------$ 20,102.00 758 $ 3,502.00 -----------------$ 3,502.00 -----------------$ 19,087.00 795 $ 3,089.00 -----------------$ 3,089.00 -----------------$ 18,190.00 815 $ 2,683.00 -----------------$ 2,683.00 -----------------$ 17,966.00 835 $ (387.83) -----------------$ (387.83) -----------------$ 6,700.07 513.916 Jan-98 Jan-97 $ 65.48 $ 400.53 $ 1,805.97 @CF $ 368.57 -----------------$ 2,640.55 $ 6,183.25 $ 2,886.65 -----------------$ 3,296.60 @CF $ 155.14 $ 51.52 $ 59.94 $ 97.59 -----------------$ 6,301.34 $ $ 324.05 $ 1,713.94 @CF $ 314.77 $ 24.34 $ $ 1,781.53 $ $ 484.81 $ 652.85 -----------------$ 2,943.52 $ 3,493.08 $ 166.01 $ $ $ 483.59 -----------------$ 7,086.19 $ 21.14 $ $ 1,650.26 $ $ 478.38 $ 563.15 $ $ -----------------$ $ 277.15 $ 451.49 $ (1,184.39) $ 329.10 ------------------ $ $ $ 2,352.76 $ 5,726.62 $ 2,663.08 $ 3,063.53 @CF $ 152.68 $ 53.36 $ 90.17 $ 112.91 $ 5,825.41 $ 2,712.92 $ 3,659.49 $ 151.04 $ $ $ 483.67 $ 7,007.12 - $ $ 136.46 $ 521.77 $ (1,596.05) $ 243.89 $ (784.85) $ (1,181.71) -----------------$ (784.85) $ (1,181.71) -----------------$ 6,301.34 $ 5,825.41 509.942 507.52 Kroger Company TICKER: SIC: GICS: Sales Cost of Goods Sold Gross Profit Selling, General, & Administrative Expense Operating Income Before Deprec. Depreciation, Depletion, & Amortization Operating Profit Interest Expense Non-Operating Income/Expense Special Items Pretax Income Total Income Taxes Minority Interest Income Before Extraordinary Items & Discontinued Operations Preferred Dividends Available for Common Savings Due to Common Stock Equivalents Adjusted Available for Common Extraordinary Items Discontinued Operations Adjusted Net Income Earnings Per Share Basic Excluding Extra Items & Disc Op Earnings Per Share Basic Including Extra Items & Disc Op Earnings Per Share DilutedExcluding Extra Items & Disc Op Earnings Per Share Diluted Including Extra Items & Disc Op EPS Basic from Operations EPS Diluted from Ops Dividends Per Share Com Shares for Basic EPS Com Shares for Diluted EPS ANNUAL INCOME STATEMENT KR 5411 30101030 Jan-07 $ 66,111.00 $ 50,115.00 -----------------$ 15,996.00 Jan-06 $ 60,553.00 $ 45,565.00 -----------------$ 14,988.00 Jan-05 $ 56,434.00 $ 42,008.00 -----------------$ 14,426.00 $ 12,488.00 -----------------$ 3,508.00 $ 11,688.00 -----------------$ 3,300.00 $ 11,273.00 -----------------$ 3,153.00 $ 1,272.00 -----------------$ 2,236.00 $ 488.00 $ @CF -----------------$ 1,748.00 $ 633.00 $ ------------------ $ 1,265.00 -----------------$ 2,035.00 $ 510.00 $ @CF -----------------$ 1,525.00 $ 567.00 $ ------------------ $ 1,256.00 -----------------$ 1,897.00 $ 554.00 $ $ (1,053.00) -----------------$ 290.00 $ 390.00 $ ------------------ $ 1,115.00 $ -----------------$ 1,115.00 $ 958.00 $ -----------------$ 958.00 $ (100.00) $ -----------------$ (100.00) $ -----------------$ 1,115.00 $ $ -----------------$ 1,115.00 $ -----------------$ 958.00 $ $ -----------------$ 958.00 $ -----------------$ (100.00) $ $ -----------------$ (100.00) $ 1.56 $ 1.32 $ (0.14) $ 1.56 $ 1.32 $ (0.14) $ 1.54 $ 1.31 $ (0.14) $ $ $ $ 1.54 1.59 1.57 0.19 715 723 $ $ $ $ 1.31 1.33 1.32 724.5 731.2 $ $ $ $ (0.14) 1.16 1.16 736 736 UAL INCOME STATEMENT Jan-04 $ 53,791.00 $ 39,460.00 -----------------$ 14,331.00 Jan-03 $ 51,760.00 $ 37,717.00 -----------------$ 14,043.00 Jan-02 $ 50,098.00 $ 36,386.00 -----------------$ 13,712.00 Jan-01 $ 49,000.00 $ 36,428.00 -----------------$ 12,572.00 Jan-00 $ 45,352.00 $ 33,331.00 -----------------$ 12,021.00 Jan-99 $ 28,203.31 $ 21,392.52 -----------------$ 6,810.78 $ 10,744.00 -----------------$ 3,587.00 $ 10,252.00 -----------------$ 3,791.00 $ 9,993.00 -----------------$ 3,719.00 $ 9,030.00 -----------------$ 3,542.00 $ 8,811.00 -----------------$ 3,210.00 $ 5,258.87 -----------------$ 1,551.91 $ 1,209.00 -----------------$ 2,378.00 $ 586.00 $ $ (1,026.00) -----------------$ 766.00 $ 454.00 $ ------------------ $ 1,087.00 -----------------$ 2,704.00 $ 600.00 $ $ (131.00) -----------------$ 1,973.00 $ 740.00 $ ------------------ $ 1,076.00 -----------------$ 2,643.00 $ 648.00 $ $ (284.00) -----------------$ 1,711.00 $ 668.00 $ ------------------ $ 1,008.00 -----------------$ 2,534.00 $ 675.00 $ $ (351.00) -----------------$ 1,508.00 $ 628.00 $ ------------------ $ 961.00 -----------------$ 2,249.00 $ 652.00 $ $ (468.00) -----------------$ 1,129.00 $ 491.00 $ ------------------ $ 429.95 -----------------$ 1,121.96 $ 266.90 $ $ (142.10) -----------------$ 712.96 $ 263.05 $ ------------------ $ 312.00 $ -----------------$ 312.00 $ 1,233.00 $ -----------------$ 1,233.00 $ 1,043.00 $ -----------------$ 1,043.00 $ 880.00 $ -----------------$ 880.00 $ 638.00 $ -----------------$ 638.00 $ 449.91 $ -----------------$ 449.91 $ -----------------$ 312.00 $ $ -----------------$ 312.00 $ -----------------$ 1,233.00 $ (28.00) $ -----------------$ 1,205.00 $ -----------------$ 1,043.00 $ $ -----------------$ 1,043.00 $ -----------------$ 880.00 $ (3.00) $ -----------------$ 877.00 $ -----------------$ 638.00 $ (10.00) $ -----------------$ 628.00 $ -----------------$ 449.91 $ (39.12) $ -----------------$ 410.79 $ 0.42 $ 1.58 $ 1.30 $ 1.07 $ 0.77 $ 0.88 $ 0.42 $ 1.55 $ 1.30 $ 1.07 $ 0.76 $ 0.81 $ 0.41 $ 1.56 $ 1.26 $ 1.04 $ 0.74 $ 0.85 $ $ $ $ 0.41 1.52 1.49 747.2 753.8 $ $ $ $ 1.52 1.69 1.67 779 791 $ $ $ $ 1.26 1.51 1.48 804 825 $ $ $ $ 1.04 1.37 1.34 823 846 $ $ $ $ 0.73 1.14 1.10 829 858 $ $ $ $ 0.77 1.05 1.01 511.628 530.764 Jan-98 $ 26,567.35 $ 19,996.38 -----------------$ 6,570.97 Jan-97 $ 25,170.91 $ 19,041.47 $ 5,192.44 -----------------$ 1,378.53 $ 4,918.38 $ 380.22 -----------------$ 998.31 $ 285.95 $ $ -----------------$ 712.36 $ 268.33 $ ------------------ $ 343.77 $ $ $ $ 867.30 299.98 - $ $ $ 567.31 214.58 - $ 444.03 $ -----------------$ 444.03 $ $ 352.74 - $ 352.74 $ -----------------$ 444.03 $ (32.38) $ -----------------$ 411.66 $ - $ $ $ 352.74 (2.86) - $ 349.87 $ 0.88 $ 0.67 $ 0.81 $ 0.67 $ 0.85 $ 0.67 $ $ @NA $ 0.79 0.88 $ $ @NA $ 0.66 0.67 508.568 525.72 $ 6,129.44 $ 1,211.07 525.5 528.132 Kroger Company DuPont Analysis Net Profitability Total Asset Turnover Equity Multiplier Return on Equity Financial Analysis Jan-07 Jan-06 Jan-05 Jan-04 Jan-03 1.69% 3.171 4.477 1.58% 2.956 5.167 -0.18% 2.736 5.482 0.58% 2.633 5.216 2.38% 2.642 5.330 23.95% 24.16% -2.66% 7.96% 33.54% 24.20% 3.38% 1.69% 5.35% 23.95% 24.75% 3.36% 1.58% 4.68% 24.16% 25.56% 3.36% -0.18% -0.48% -2.66% 26.64% 4.42% 0.58% 1.53% 7.96% 27.13% 5.22% 2.38% 6.29% 33.54% 90.316 4.041 11.020 33.121 5.713 4.643 3.171 79.991 4.563 10.306 35.415 5.297 4.310 2.956 71.982 5.071 9.855 37.036 4.978 3.940 2.736 75.922 4.808 9.458 38.590 4.952 3.697 2.633 76.342 4.781 9.031 40.417 5.123 3.683 2.642 0.891 0.209 0.106 4.582 13.663 26.715 0.963 0.133 0.031 3.990 12.471 29.267 1.014 0.154 0.023 3.424 11.381 32.071 1.005 0.146 0.026 4.058 11.411 31.986 0.993 0.151 0.030 4.507 12.005 30.404 0.768 0.411 3.309 0.786 0.458 3.666 0.827 0.519 4.788 0.808 0.511 4.210 0.808 0.529 4.221 Profitability Analysis Gross Profitability Operating Profitability Net Profitability Return on Assets Return on Equity Efficiency Analysis Receivable Turnover Receivable DSO Inventory Turnover Inventory DCO Net PP&E Turnover Net Fixed Asset Turnover Total Asset Turnover Liquidity Analysis Current Ratio Quick Ratio Cash Ratio Times Interest Earned Accounts Payable Turnover Accounts Payable DCO Leverage Ratio Total Debt to Total Assets Long Term Term Debt to Total Assets Total Debt to Total Equity Jan-02 Jan-01 Jan-00 Jan-99 Jan-98 Jan-97 2.08% 2.688 5.656 1.80% 2.710 6.264 1.41% 3.677 10.747 1.60% 4.338 -11.087 1.67% 4.382 -6.166 1.40% 31.65% 30.49% 55.60% -76.73% -45.16% 27.37% 5.28% 2.08% 5.60% 31.65% 25.66% 5.17% 1.80% 4.87% 30.49% 26.51% 4.96% 1.41% 5.17% 55.60% 24.15% 3.98% 1.60% 6.92% -76.73% 24.73% 3.76% 1.67% 7.32% -45.16% 73.350 4.976 8.827 41.349 5.423 3.803 2.688 74.866 4.875 9.102 40.099 5.733 3.888 2.710 84.069 4.342 11.761 31.035 7.521 5.510 3.677 65.784 5.548 12.099 30.167 7.965 7.337 4.338 73.332 4.977 11.362 32.125 8.354 7.449 4.382 1.005 0.153 0.029 4.079 12.132 30.087 0.969 0.152 0.029 3.754 12.436 29.350 0.966 0.158 0.049 3.449 15.277 23.892 0.837 0.181 0.038 4.204 11.952 30.540 0.897 0.158 0.022 3.491 11.707 31.177 0.867 0.119 0.000 2.891 0.817 0.529 4.450 0.830 0.523 4.889 0.851 0.532 5.696 1.058 0.581 -18.276 1.125 0.657 -9.029 1.203 0.737 -5.930 24.35% 3.45% 1.40% Kroger CompanyFinancial Analysis DuPont Analysis Net Profitability Total Asset Turnover Equity Multiplier Jan-13 Jan-12 Jan-11 Jan-10 1.55% 0.67% 1.36% 0.09% 20.56% 2.74% 1.53% 6.02% 20.89% 2.47% 0.66% 2.55% 22.22% 2.68% 1.35% 4.72% 23.16% 2.87% 0.09% 0.30% Return on Equity Profitability Analysis Gross Profitability Operating Profitability Net Profitability Return on Assets Return on Equity Efficiency Analysis Receivable Turnover Receivable DSO Inventory Turnover Inventory DCO Net PP&E Turnover Net Fixed Asset Turnover Total Asset Turnover Liquidity Analysis Current Ratio Quick Ratio Cash Ratio Times Interest Earned Accounts Payable Turnover Accounts Payable DCO Leverage Ratio Total Debt to Total Assets Long Term Term Debt to Total Assets Total Debt to Total Equity Jan-09 Jan-08 Jan-07 Jan-06 Jan-05 Jan-04 Jan-03 1.64% 1.68% 1.69% 1.58% -0.18% 0.58% 2.38% 22.94% 3.26% 1.64% 5.38% 23.43% 3.28% 1.68% 5.30% 24.20% 3.38% 1.69% 5.26% 24.75% 3.36% 1.58% 4.68% 25.56% 3.36% -0.18% -0.49% 26.64% 4.42% 0.58% 1.50% 27.13% 5.22% 2.33%
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags