please answer the highlighted area. I have answered some of the questions, you might help me to check them. Thank you. I cannot upload the file.
This is a statement.
Those are questions: some have been finished but not sure whether they are correct. so please check.
Functional Form Functional Form Wal*Mart Functional Form 1/31/2001 FYO1 Target 2/3/2001 FYOO K-Mart 1/31/2001 FYOO 356 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) 6,412 1,941 4,248 759 7,304 *=SUM(G8:611) 811 7,624 *=SUM(18:J11) 15,759 (4,341) 11,418 *=SUM(G14:G15) 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 47,813 (10,196) 37,617 =D15+D14 4,620 (1,303) 3,317 *=SUM(D17:D18) 9,059 1,582 78,130 *=SUM(D12,016,D19,021,D 768 19,490 *=SUM(G12, G16,G2 449 14,630 *=SUM(J12:J22) 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:D32) 3,576 1,507 361 857 2,288 1,256 187 68 6,301 =SUM(G28:G31) 3,799=SUM(128:31) 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 46,787 =SUM(D33:D38) 1,036 1,721 8,547 *=SUM(133,135:138) 12,971 S=SUM(G33:637) 75 487 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) 902 5,542 1,578 4,018 31,343 *=SUM(D43:046) 78,130 *=SUM(D48,D39) 6,519 *=SUM(G43:G45) 19,490 *=SUM(G48,639) 6,083 *=SUM(J43:45) 14,630 *=SUM(348,239) Revenues Net sales Other Income 37,028 191,329 1,966 193,295 *=SUM(D53:054) 36,362 541 36,903 =SUM(G53:654) 37,028 =J53 Costs and Expenses Cost of sales SG & A Interest 150,255 31,550 1,374 7,248 =D55-D57-D58-D59-D72 25,295 9,130 425 1,113 29,658 7,415 287 (1,109) *=J55-157-158-159-172 EBT *=G55-657-658-659 789 (134) 3,350 342 3,692 *=SUM(D62:D63) (129) 789 Provision for Tax Current Deferred Total Tax Minority Interest Accounting changes Special charges Net Income Avg number of common shares EPS =G62 (134) *=J62 (46) 3,685 *=D60-D64-D65 4,465 0.83 =D68/D69 324 '=G60-664 904 0.36 *=G68/669 (929) '=J60-J64-J65 483 (1.92) *=J68/369 2,868 940 777 Depreciation Amortization Wal*Mart Functional Form Target Functional Form K-Mart Functional Form 0.92 S=D12/D33 1.16 =G12/633 2.01 *=J12/133 Current Ratio CA/CL 0.18 =(D12-D10)/D33 0.49 *=(G12-G10)/G33 0.32 =(J12-J10)/133 Quick Ratio (CA-INV)/CL 0.07 =D8/D33 0.06 *=G8/G33 0.11 *=18/133 Cash Ratio Cash/CL 72.75 *=D12/365 20.01 *=G12/365 20.89 *=J12/365 Interval Measure (in days) CA/ Avg daily operating exp Total Debt (TA-TE)/TA 0.60 =(D23-048)/D23 0.67 *=(G23-G48)/G23 0.58 =(J23-348)/123 0.40 *=D35/D48 0.86 =G35/648 0.34 *=J35/348 Debt/Equity Total Debt/Total Equity 2.49 *=D23/D48 2.99 *=G23/G48 2.41 =J23/148 Equity Multiplier TA / Total Equity 0.29 *=D35/(D35+D48) 0.46 *=G35/(G35+G48) 0.26 *=J35/(135+J48) LT Debt Ratio LTD/ (LTD+TE) 6.28 "=(D60+D59)/D59 3.62 =(G60+G59)/G59 - 2.86 *=(J60+359)/359 Times Interest earned EBIT/Interest 8.36 *=(D60+D59+D72+ 5.83 = (G60+G59+G72+- 0.16 "=(J60+359+J72+273)/159 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 2 NI/TA ROE NI/TE ROE (Dupont Identity) Profit Marg X Asst T/O X EqM 5.06 Range of Stock Prices For the Closing Quarter 43.69 58.44 22.75 38.59 # # W E 8.75 P/E Ratio '=N69/D70 =N70/D70
