|
|
|
|
|
|
| A_CO_FIN | | Learner Copy | | | Rev 6/19/21 |
| COMPANY A |
| Illlustrative Data for Educational Purposes |
| All values shown are in thousands. |
| | | | 2017 | 2018 | 2019 |
| Income Statement |
| Revenue | | | 27,981 | 28,772 | 29,580 |
| Cost of Goods Sold (COGS) | | | 15,389 | 18,997 | 16,285 |
| Gross Profit | | | 12,592 | 9,775 | 13,295 |
| Expenses |
| Salaries and Benefits | | | 4,510 | 4,500 | 4,480 |
| Rent and Overhead | | | 1,804 | 1,804 | 1,804 |
| Depreciation and Amortization | | | 2,814 | 2,806 | 2,806 |
| Interest | | | 900 | 900 | 900 |
| Total Expenses | | | 10,028 | 10,010 | 9,990 |
| Earnings Before Tax | | | 2,564 | (235) | 3,305 |
|
| Taxes | | | 718 | (65) | 925 |
| Net Earnings | | | 1,846 | (170) | 2,380 |
|
| | | | 2017 | 2018 | 2019 |
| Balance Sheet |
| Assets |
| Cash | | | 62,265 | 61,708 | 44,319 |
| Accounts Receivable | | | 1,380 | 1,419 | 1,460 |
| Inventory | | | 3,078 | 3,799 | 3,257 |
| Property and Equipment | | | 37,413 | 37,408 | 37,403 |
| Total Assets | | | 104,136 | 104,334 | 86,439 |
|
| Liabilities |
| Accounts Payable | | | 1,560 | 1,926 | 1,651 |
| Debt | | | 30,000 | 30,000 | 10,000 |
| Total Liabilities | | | 31,560 | 31,926 | 11,651 |
|
| Shareholders' Equity |
| Equity Capital | | | 33,685 | 33,685 | 33,685 |
| Retained Earnings | | | 38,891 | 38,723 | 41,103 |
| Shareholders' Equity | | | 72,576 | 72,408 | 74,788 |
| Total Liabilities and Shareholders' Equity | | | 104,136 | 104,334 | 86,439 |
|
| | | | 2017 | 2018 | 2019 |
| Cash Flow Statement |
| Operating Cash Flow |
| Net Earnings | | | 1,846 | (170) | 2,380 |
| Plus: Depreciation and Amortization | | | 2,814 | 2,806 | 2,806 |
| Less: Changes in Working Capital | | | (10,312) | 394 | (226) |
| Cash from Operations | | | 14,972 | 2,242 | 5,411 |
|
| Investing Cash Flow |
| Sales (Investments) in Property and Equipment | | | 2,706 | (2,800) | (2,800) |
| Cash from Investing | | | 2,706 | (2,800) | (2,800) |
|
| Financing Cash Flow |
| Issuance (repayment) of Debt | | | – | – | (20,000) |
| Issuance (repayment) of Equity | | | – | – | – |
| Cash from Financing | | | – | – | (20,000) |
|
| Net Increase (decrease) in Cash | | | 17,678 | (558) | (17,389) |
| Opening Cash Balance | | | 44,587 | 62,265 | 61,708 |
| Closing Cash Balance | | | 62,265 | 61,708 | 44,319 |
|
|
| Supporting Schedules |
| Working Capital Schedule |
| Accounts Receivable | | | 1,380 | 1,419 | 1,460 |
| Inventory | | | 3,078 | 3,799 | 3,257 |
| Accounts Payable | | | 1,560 | 1,926 | 1,651 |
| Net Working Capital (NWC) | | | 2,898 | 3,292 | 3,066 |
| Change in NWC | | | (10,312) | 394 | (226) |
|
| Depreciation Schedule |
| PPE Opening | | | 37,521 | 37,413 | 37,407 |
| Plus Capex | | | 2,706 | 2,800 | 2,800 |
| Less Depreciation | | | 2,814 | 2,806 | 2,806 |
| PPE Closing | | | 37,413 | 37,407 | 37,402 |
|
| Debt and Interest Schedule |
| Debt Opening | | | 30,000 | 30,000 | 30,000 |
| Issuance (repayment) | | | – | – | (20,000) |
| Debt Closing | | | 30,000 | 30,000 | 10,000 |
| Interest Expense | | | 900 | 900 | 900 |
|
|