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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started