|
|
|
|
|
|
| B_CO_FINANCE |
|
Learner Copy |
|
|
Rev 3/14/21 |
| COMPANY B |
| Illlustrative Data for Educational Purposes |
| All values shown are in thousands. |
|
|
|
2017 |
2018 |
2019 |
| Income Statement |
| Revenue |
|
|
27,981 |
26,302 |
27,091 |
| Cost of Goods Sold (COGS) |
|
|
15,389 |
18,411 |
18,151 |
| Gross Profit |
|
|
12,591 |
7,891 |
8,940 |
| Expenses |
| Salaries and Benefits |
|
|
2,910 |
2,600 |
2,910 |
| Rent and Overhead |
|
|
1,354 |
1,354 |
1,354 |
| Depreciation and Amortization |
|
|
2,814 |
2,806 |
2,776 |
| Interest |
|
|
2,700 |
1,800 |
1,800 |
| Total Expenses |
|
|
9,778 |
8,560 |
8,840 |
| Earnings Before Tax |
|
|
2,813 |
(669) |
100 |
|
| Taxes |
|
|
788 |
(141) |
21 |
| Net Earnings |
|
|
2,025 |
(529) |
79 |
|
|
|
|
2017 |
2018 |
2019 |
| Balance Sheet |
| Assets |
| Cash |
|
|
82,445 |
82,914 |
72,944 |
| Accounts Receivable |
|
|
1,380 |
1,297 |
1,336 |
| Inventory |
|
|
3,078 |
2,018 |
1,989 |
| Property and Equipment |
|
|
37,413 |
37,007 |
37,032 |
| Total Assets |
|
|
124,316 |
123,236 |
113,301 |
|
| Liabilities |
| Accounts Payable |
|
|
1,560 |
1,009 |
995 |
| Debt |
|
|
90,000 |
90,000 |
80,000 |
| Total Liabilities |
|
|
91,560 |
91,009 |
80,995 |
| Shareholders' Equity |
| Equity Capital |
|
|
33,685 |
33,685 |
33,685 |
| Retained Earnings |
|
|
(929) |
(1,458) |
(1,379) |
| Shareholders' Equity |
|
|
32,756 |
32,227 |
32,306 |
| Total Liabilities and Shareholders' Equity |
|
|
124,316 |
123,236 |
113,301 |
|
|
|
|
2017 |
2018 |
2019 |
| Cash Flow Statement |
| Operating Cash Flow |
| Net Earnings |
|
|
2,025 |
(529) |
79 |
| Plus: Depreciation and Amortization |
|
|
2,814 |
2,806 |
2,776 |
| Less: Changes in Working Capital |
|
|
(10,312) |
(592) |
25 |
| Cash from Operations |
|
|
15,151 |
2,869 |
2,830 |
|
| Investing Cash Flow |
| Investments in Property and Equipment |
|
|
(2,706) |
(2,400) |
(2,800) |
| Cash from Investing |
|
|
(2,706) |
(2,400) |
(2,800) |
|
| Financing Cash Flow |
| Issuance (repayment) of Debt |
|
|
– |
– |
(10,000) |
| Issuance (repayment) of Equity |
|
|
– |
– |
– |
| Cash from Financing |
|
|
– |
– |
(10,000) |
|
| Net Increase (decrease) in Cash |
|
|
12,445 |
469 |
(9,970) |
| Opening Cash Balance |
|
|
70,000 |
82,445 |
82,914 |
| Closing Cash Balance |
|
|
82,445 |
82,914 |
72,944 |
|
|
| Supporting Schedules |
| Working Capital Schedule |
| Accounts Receivable |
|
|
1,380 |
1,297 |
1,336 |
| Inventory |
|
|
3,078 |
2,018 |
1,989 |
| Accounts Payable |
|
|
1,560 |
1,009 |
995 |
| Net Working Capital (NWC) |
|
|
2,898 |
2,306 |
2,331 |
| Change in NWC |
|
|
(10,312) |
(592) |
25 |
|
| Depreciation Schedule |
| PPE Opening |
|
|
37,521 |
37,413 |
37,007 |
| Plus Capex |
|
|
2,706 |
2,400 |
2,800 |
| Less Depreciation |
|
|
2,814 |
2,806 |
2,776 |
| PPE Closing |
|
|
37,413 |
37,007 |
37,032 |
|
| Debt and Interest Schedule |
| Debt Opening |
|
|
90,000 |
90,000 |
90,000 |
| Issuance (repayment) |
|
|
– |
– |
(10,000) |
| Debt Closing |
|
|
90,000 |
90,000 |
80,000 |
| Interest Expense |
|
|
2,700 |
1,800 |
1,800 |
|
|
