Question: *PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITH ANY RELEVANT FORMULAS, thank you!* You have been given the financial statements for Low Risk Inc. You
*PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITH ANY RELEVANT FORMULAS, thank you!*
You have been given the financial statements for Low Risk Inc. You have been asked to determine the free cash flow (FCF) for 2014.
Answer: $16,800
I have provided the answer for reference, I just need to know how to get there.
| Income Statement | ||
| 2013 | 2014 | |
| Sales | 80,000 | 120,000 |
| Cost of Goods Sold | 32,000 | 48,000 |
| Gross Margin | 48,000 | 72,000 |
| Selling Expense | 8,000 | 12,000 |
| EBITDA | 40,000 | 60,000 |
| Depreciation | 4,000 | 6,000 |
| EBIT | 36,000 | 54,000 |
| interest | 150 | 200 |
| Earnings before taxes | 35,850 | 53,800 |
| taxes | 14,340 | 21,520 |
| Net Income | 21,510 | 32,280 |
| Balance Sheet | ||||||
| Assets | 2013 | 2014 |
| Liabilities and Shareholders Equity | 2013 | 2014 |
| Cash | 2,400 | 3,600 | Accounts Payable | 8,800 | 13,200 | |
| Accounts Receivable | 9,600 | 14,400 | Short-term Debt | 1,500 | 1,200 | |
| Inventory | 12,000 | 18,000 | Total Current Liabilities | 10,300 | 14,400 | |
| Total Current Assets | 24,000 | 36,000 | Long Term Debt | 600 | 700 | |
| Net Plant & Equipment | 16,000 | 24,000 | Total Liabilities | 10,900 | 15,100 | |
| Total Assets | 40,000 | 60,000 | Common Stock | 2,600 | 2,800 | |
| Retained Earnings | 26,500 | 42,100 | ||||
| Total Equity | 29,100 | 44,900 | ||||
| Total Liabilities & Equity | 40,000 | 60,000 | ||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
