Clipboard Font anned 20.. G10 11 HOMEWORK #1 2 FILL IN THE INCOME, CASH FLOW AND

Question

Clipboard Font anned 20.. G10 11 HOMEWORK #1 2 FILL IN THE INCOME, CASH FLOW AND BALANCE SHE ertificati4INPUT 2013 2014 6 Sales 7 Cost of Good Sold 8 Cash 9 Depreciation 10Interest Expense 11 Tax Rate 12 SG&A; 13 Long Term Debt 250,000 300,000 120,000 150,000 20,000 36,000 40,000 8,000 9,000 40.0% 40.0% 50,000 55,000 240,000 230,000 150,000 150,000 40,000 42,000 15,00014,500 800,000 820,000 14 Initial Equity Investment 15 Accounts Receivable 16 Inventory 17 Gross Fixed Assets 18 Accumulated Depreciation (350,000) 19 Accounts Payable 20 Retained Earnings 35,00036,000 100,000 21 23 24 25 26 27 28 29 30 31 Ar In Gr

Explanation / Answer

Note: All ratios and intermediate calculations are rounded off to 2 decimal places wherever required in absence of instructions regarding the same.

Workings:

Income Statement Cash Flow 2013 2014 2014 Sales 250000 300000 NI 27600 COGS 120000 150000 Plus depreciation 40000 Gross margin 130000 150000 Cash income 67600 SG&A 50000 55000 EBITDA 80000 95000 WC Change in A/R -2000 Depreciation 36000 40000 Change in inventory 500 EBIT 44000 55000 Change in A/P 1000 Interest 8000 9000 Change working capital -500 EBT 36000 46000 Taxes 14400 18400 Inv Capex -20000 NI 21600 27600 Fin Debt -10000 Balance Sheet Equity 0 2013 2014 Fin Activity -10000 Cash 20000 57100 Account receivable 40000 42000 Cash flow 37100 Inventory 15000 14500 Total C/A 75000 113600 Beginning cash flow 20000 Gross fixed assets 800000 820000 Ending cash flow 57100 Accumulated depreciation -350000 -390000 Net fixed assets 450000 430000 Financial ratios (2014) Total assets 525000 543600 Gross profit 50% Accounts payable 35000 36000 Accounts receivable days 49.86 Long term debt 240000 230000 Inventory turnover days 35.89 Total liabilities 275000 266000 ROA 5.17% Initial equity investment 150000 150000 Retained earnings 100000 127600 ROE 10.46% Total equity 250000 277600 Total liability + equity 525000 543600

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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