Complete the highlighted area of the following accounting statement and financial ratios table.

Some examples are given as reference point.

Assignment 2: Ratio Analysis Complete the highlighted area of the following accounting statement and financial ratios table. Some exam Functional Form Functional Form Wal-Mart Functional Form 1/31/2001 FY01 Target 2/3/2001 K-Mart 1/31/2001 FY00 FY00 401 Assets Current Assets Cash and Equivalents Receivables Inventories Other Total Current Assets 2,054 1,768 21,442 1,291 26,555 *=SUM(D8:011) 356 1,941 4,248 759 6,412 811 15,759 (4,341) 47,813 (10,196) 37,617 =D15+D14 4,620 (1,303) 6,557 PP&E Less: Acc Depr Net PP&E Capital Leases Less: Acc Amort Net Capital Leases Other Assets Net goodwill and intangibles Other assets and deferrals Total Assets 9,059 1,582 78,130 768 449 Liabilities and Shareholders Equity Current Liabilities Commercial Paper Accounts payable Accrued liabilities Accrued income taxes LTD due in next year Capital leases due next year Total Current Liabilities 2,286 15,092 6,355 841 4,234 141 28,949 *=SUM(D27:032) 3,576 1,507 361 2,288 1,256 187 68 857 5,634 2,084 943 Long term debt Long term capital leases Deferred tax Minority interest/ Other Total Liabilities 12,501 3,154 1,043 1,140 1,036 1,721 8,547 Shareholders Equity Preferred stock Common stock Paid in capital Retained earnings Other accum comprehensive income Total Shareholders Equity Total Liabilities and SE 447 1,411 30,169 (684) 75 902 5,542 487 1,578 4,018 Revenues Net sales Other Income 37,028 191,329 1,966 36,362 541 36,903 Costs and Expenses Cost of sales 150,255 25,295 29,658 Revenues Net sales Other Income 37,028 191,329 1,966 36,362 541 36,903 150,255 31,550 1,374 25,295 9,130 425 29,658 7,415 287 =D55-SUM(D57:059) 789 Costs and Expenses Cost of sales SG & A Interest EBT Provision for Tax Current Deferred Total Tax Minority Interest Accounting changes Special charges Net Income Avg number of common shares EPS 3,350 342 (134) (129) (46) 4,465 904 483 2,868 940 777 Depreciation Amortization Wal Mart Functional Form Target Functional Form K-Mart Functional Form Current Ratio 0.92 '=D12/D33 CA/CL Quick Ratio (CA-INV)/CL Cash Ratio Cash/CL Interval Measure (in days) CA/ Avg daily operating exp Total Debt (TA-TE)/TA Debt/Equity Total Debt / Total Equity Equity Multiplier TA/ Total Equity LT Debt Ratio LTD/ (LTD+TE) Times Interest earned EBIT/Interest Cash Coverage (EBIT+Depr+Amort) / Interest Days Inventory 365/(COGS/Inv) Days Receivables 365/(sales/A/R) Days Payables 365/(Operating exp/A/P) NWC Turnover Sales/ NWC Fixed Asset Turnover Sales / FA (every $ in FA gen $4.72 in sales) Total Asset Turnover Sales/Total Assets Profit Margin NI / Sales ROA NI/TA ROE NI / TE ROE (Dupont Identity) Profit Marg X Asst T/O X EqM W W W Range of Stock Prices For the Closing Quarter 43.69 58.44 22.75 38.59 5.06 8.75 W w W P/E Ratio '=N69/D70 '=N70/D70