In: Accounting
The Trial balance for Jasmine Ltd for the year ended 30.9.18 is below:
Debit (£) |
Credit (£) |
|
Vehicles |
58,250 |
|
Tax paid for the year |
10,000 |
|
Sundry expenses |
1,360 |
|
Sales |
600,000 |
|
Salaries |
82,500 |
|
Reserves |
456,600 |
|
Rates |
16,250 |
|
Purchases |
110,000 |
|
Prepayments |
1,300 |
|
Plant & Machinery |
160,000 |
|
Land |
800,000 |
|
Inventory at 30.9.17 |
15,000 |
|
Interest paid |
6,000 |
|
Utilities |
22,000 |
|
Delivery costs |
3,640 |
|
Cash |
19,650 |
|
Capital |
850,000 |
|
Buildings |
750,000 |
|
Bank overdraft |
30,000 |
|
Administration costs |
14,300 |
|
Accumulated depreciation on vehicles at 30.9.17 |
11,650 |
|
Accumulated depreciation on plant & machinery at 30.9.17 |
16,000 |
|
Accumulated depreciation on buildings at 30.9.17 |
136,000 |
|
Accounts receivable |
250,000 |
|
Accounts payable |
120,000 |
|
8% Long-term loan |
100,000 |
|
2,320,250 |
2,320,250 |
The following supplementary information is available which has not been subjected to double entry
Required: Produce an Income Statement and a Statement of Financial Position for Jasmine Ltd for the yer ended 30.9.18
Annual Income Statement | Calculations | 2018 |
Sales | £ 600,000.00 | |
Cost of Goods Sold: | ||
Opening Inventory | £ 15,000.00 | |
Purchases | £ 110,000.00 | |
Closing Inventory | £ (55,000.00) | |
Total Cost of Goods Sold | £ 70,000.00 | |
ross Profit | £ 530,000.00 | |
Other Operating Income or Expenses | ||
Sundry Expenses | £ 2,010.00 | |
Utility Expenses | £ 18,500.00 | |
Delivery cost | £ 3,640.00 | |
Salaries | £ 82,500.00 | |
Administrative cost | £ 14,300.00 | |
Rates | £ 16,250.00 | |
Total Operating Expenses | £ 137,200.00 | |
EBITDA | £ 392,800.00 | |
Depreciation on Vehicle | £ 9,320.00 | |
Depreciation on Plant | £ 16,000.00 | |
Depreciation on building | £ 15,000.00 | |
Total Depreciation | £ 40,320.00 | |
Bad Debts | £ 10,700.00 | |
Provision for Bad Debts | £ 7,179.00 | |
EBIT | £ 334,601.00 | |
Interest Expenses | £ 8,000.00 | |
EBT | £ 326,601.00 | |
Tax paid | £ 10,000.00 | |
Net Income | £ 316,601.00 |
Annual Balance Sheet | Calculations | 2018 |
Current Assets | ||
Cash On Hand | £ 19,650.00 | |
Prepayments | £ 1,300.00 | |
Inventory | £ 55,000.00 | |
Account Receivables | £ 239,300.00 | |
Provision For Bad Debts | £ 7,179.00 | |
Net Receivables | £ 232,121.00 | |
Prepaid utility Expenses | £ 3,500.00 | |
Total Current Assets | £ 311,571.00 | |
Fixed Assets | ||
Plant And Machinery | £ 160,000.00 | |
Accumulated Depreciation on Plant & Machinery | £ (32,000.00) | |
Vehicles | £ 58,250.00 | |
Accumulated Depreciation on Vehicles | £ (20,970.00) | |
Land | £ 800,000.00 | |
Buildings | £ 750,000.00 | |
Accumulated Depreciation on Buildings | £(151,000.00) | |
Net Fixed Assets | £ 1,564,280.00 | |
Total Assets | £1,875,851.00 | |
Total Current Liabilities | ||
Account Payable | £ 120,000.00 | |
Bank Overdraft | £ 30,000.00 | |
Sundry Expense Payable | £ 650.00 | |
Interest Payable | £ 2,000.00 | |
Total Current Liabilities | £ 152,650.00 | |
Non-Current Liabilities | ||
8% Lon Term Loan | £ 100,000.00 | |
Total Non-Current Liabilities | £ 100,000.00 | |
Total Liabilities | £ 252,650.00 | |
Shareholder Equity | ||
Capital | £ 850,000.00 | |
Reserve | £ 456,600.00 | |
Net Income for the year | £ 316,601.00 | |
Total Shareholder Equity | £ 1,623,201.00 | |
Total Liabilities And Share Holders Equity | £ 1,875,851.00 |