Question: Complete all questions below: Prepare a report by Analyzing the Financial statements for XYZ Co and doing a trend analysis. The report will be used
Complete all questions below:
- Prepare a report by Analyzing the Financial statements for XYZ Co and doing a trend analysis. The report will be used in financial planning process.
| Sales |
| ||
| Cash | 2,100 | 1,700 | 2,480 |
| Credit | 19,200 | 15,800 | 16,320 |
| Total Sales | 21,300 | 17,500 | 18,800 |
| Cost of goods sold | 17,800 | 19,240 | 13,832 |
| Gross profit | 3,500 | (1,740) | 4,968 |
Operating expenses:
| General, admin, and selling expenses | 1,400 | 200 | 1,750 |
| Depreciation | 237 | 1,746 | 1,526 |
| Interest expenses (on borrowings) | 440 | 636 | 1,340 |
| Profit before tax (PBT) | 1,423 | (4,322) | 352 |
| Tax @ 30% | 427 |
| 106 |
| Profit/Loss after tax (PAT) | 996 | (4,322) | 246 |
Statement of Balance Sheet as at 31 December 2019 (USD "000)
2019 2017 2018
| Assets | |||
| Fixed assets (net of depreciation) | 2,670 | 14,900 | 13,500 |
| Current assets | |||
| Cash and cash equivalents | 1,360 | 447 | 1,200 |
| Accounts receivable | 23,000 | 4,000 | 16,000 |
| Inventories | 24,500 | 6,200 | 15,700 |
| Total | 51,530 | 25,547 | 46,400 |
2019 2017 2018
| Equity & Liabilities | |||
| Equity share capital (shares of USD 10 each) | 14,062 | 18,076 | 20,612 |
| Reserve & Surplus | 10,976 | 1,564 | 4,648 |
| Long-Term Borrowings | 3,162 | 3,560 | 10,960 |
| Current Liabilities | 23,330 | 2,347 | 10,180 |
| Total | 51,530 | 25,547 | 46,400 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
