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