| |
|
| 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 |
fkotd
CompanyAFinancials.xlsx
