Name Chapter 13 Financial Statement Analysis Mini Project Target Inc. Wal-Mart I

Question

Name Chapter 13 Financial Statement Analysis Mini Project Target Inc. Wal-Mart Inc. Income Statement Data for the year $41,895 $1,776 $647 $2,849 $61,471 $1,896 $16,200 $286,515 $6,908 $1,798 $12,731 $374,526 $4,273 $70,847 Cost of Goods Sold Income Tax Expense Interest Expense Net Income Net Sales (Cash & Credit) Other Income/Expense Selling And Administrative Expenses Balance Sheet Balances - Dec 31 Current Assets Current Liabilities Long Term Liabilities Non-current Assets Total Stockholders' Equity $18,906 $11,782 $17,471 $25,654 $15,307 $47,585 $58,454 $40,452 $115,929 $64,608 Balance Sheet Balances - Jan 1 Current Liabilities Total Assets Total Liabilities Total Stockholder's Equity $11,117 $37,349 $21,716 $15,633 $52,148 $151,587 $90,014 $61,573 Other Data Average Accounts Receivable Average Inventory Cash from Sales Operations $7,124 $6,517 $4,125 $3,247 $34,433 $20,354

Explanation / Answer

Target Inc Wal Mart 1) Working capital 7124 -10869 CurrentAssets-Current Liabilities 18906-11782 47585-58454 2) Current ratio 1.60 0.81 CurrentAssets/Current Liabilities 18906/11782 47585/58454 3)Accounts Receivebale Turnover 8.63 115.35 Net credit sales/Avg Acc. Rec 61471/7124 374526/3247 4) Average collection period 42.29 3.16 days 365/Acc rec Turnover 365/8.63 365/115.35 5) Inventory Turnover 6.43 8.32 COGS/Avg Inventory 41895/6517 286515/34433 6) Average sales period 56.77 43.87 days Avg Inventory/COGS*365 365/6.43 365/8.32 7) Operating cycle 99.06 47.03 days 5+6 42.29+56.77 3.16+43.87 8) Gross profit margin 31.85 23.50 % GP/Net sales*100 (61471-41895)/61471*100 (374526-286515)/374526*100 9) net profit margin 4.63 3.40 % NP/Net sales *100 2849/61471*100 12731/374526*100 10) timere interest earned 5.22 9.55 EBIT/Interest expenses (61471-41895-16200)/647 (374526-286515-70847)/1798 11) Debt to equity ratio 1.91 1.53 Debt/Equity (11782+17471)/15307 (58454+40452)/64608

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.