Question

In: Accounting

Extracts Income Statements and Balance Sheets 2017 2018 2019 Sales 3,840 5,760 8,448 Cost of Sales...

Extracts Income Statements and Balance Sheets

2017

2018

2019

Sales

3,840

5,760

8,448

Cost of Sales

1,920

2,688

5,608

Distribution costs

384

462

676

Administrative expenses

1095

1,268

1,260

Interest expense (paid)

135

192

576

Taxation

76

268

150

Retained Profit

115

652

128

Fixed assets at cost

1,765

2,285

4,915

Accumulated depreciation

192

422

1,690

Closing Inventory at cost

154

346

752

Trade receivables

384

961

1,589

Prepayments

55

192

230

Overdraft

176

211

2,262

Trade payables

190

308

624

Accruals

155

384

576

Taxation payable

76

268

150

Debentures

640

385

250

Ordinary share capital £1

775

1000

1000

Retained earnings/Reserves

154

806

934

Looking at above, can you fill the below?

Thank you in advance.

Item

Year 2018

Year 2019

Net Profit

1,150

+Depreciation

+Interest Expense

-Increase in Inventory

-Increase in Debtors

-Increase in Prepayments

+Increase in Creditors

+Accruals rise

-Interest Paid

-Tax Paid

-Dividends Paid

Net Cash Flow (Operating Act.)

Net Cash Flow (Investing Act.)

Net Cash Flow (Financing Act.)

Net Cash Increase

Opening Balance

Closing Balance

Solutions

Expert Solution

Statement of Cash flow
Item Year 2017 Year 2018 Year 2019
Net Profit        306.00 1,150.00         328.00
+Depreciation        192.00      230.00     1,268.00
+Interest Expense        135.00      192.00         576.00
Operating profit from before working capital changes        633.00 1,572.00     2,172.00
-Increase in Inventory (154.00) (192.00) (406.00)
-Increase in Debtors (384.00) (577.00) (628.00)
-Increase in Prepayments (55.00) (137.00) (38.00)
+Increase in Creditors 190.00 118.00 316.00
+Accruals rise 155.00 229.00 192.00
Inccrease/(decrease) in taxation payable 76.00 192.00 (118.00)
Cash generation from operation        461.00 1,205.00     1,490.00
-Tax Paid                 -   (76.00) (268.00)
Net Cash Flow (Operating Act.)        461.00 1,129.00     1,222.00 A
Cash flows from investing activities:
Net proceeds/(Purchase) of Building (1,573.00) (290.00) (1,362.00)
Net Cash Flow (Investing Act.) (1,573.00) (290.00) (1,362.00) B
Cash flows from financing activities:
Net proceeds/(Repayment))of Debenture payable 640.00 (255.00) (135.00)
Net proceeds/(Repayment))of Overdraft payable 176.00 35.00 2,051.00
Net proceeds/(Repayment))of Issue of Common stock 775.00 225.00 0.00
Dividends Paid (115.00) (230.00) (50.00)
Net Cash Flow (Financing Act.)    1,476.00 (225.00) 1,866.00 C
Net Cash Increase        364.00      614.00     1,726.00 (A+B+C)
Opening Balance                 -        364.00         978.00
Closing Balance        364.00      978.00     2,704.00
Income Statements and Balance Sheets
2017 2018 2019
Sales    3,840.00 5,760.00     8,448.00
Cost of Sales    1,920.00 2,688.00     5,608.00
Gross Profit    1,920.00 3,072.00     2,840.00
Less: Expenses
Distribution costs        384.00      462.00         676.00
Administrative expenses    1,095.00 1,268.00     1,260.00
Operating expenses    1,479.00 1,730.00     1,936.00
EBIT/Operating profit        441.00 1,342.00         904.00
Interest expense (paid)        135.00      192.00         576.00
Profit before tax(PBT)        306.00 1,150.00         328.00
Taxation          76.00      268.00         150.00
Profit after Tax(PAT)        230.00      882.00         178.00
Dividend paid        115.00      230.00           50.00
Retained Profit        115.00      652.00         128.00
Fixed assets at cost    1,765.00 2,285.00     4,915.00
Accumulated depreciation      -192.00     -422.00    -1,690.00
Net fixed assets    1,573.00 1,863.00     3,225.00
Closing Inventory at cost        154.00      346.00         752.00
Trade receivables        384.00      961.00     1,589.00
Prepayments          55.00      192.00         230.00
Total Asset    2,166.00 3,362.00     5,796.00
Overdraft        176.00      211.00     2,262.00
Trade payables        190.00      308.00

Related Solutions

Extracts Income Statements and Balance Sheets 2017 2018 2019 Sales 3,840 5,760 8,448 Cost of Sales...
Extracts Income Statements and Balance Sheets 2017 2018 2019 Sales 3,840 5,760 8,448 Cost of Sales 1,920 2,688 5,608 Distribution costs 384 462 676 Administrative expenses 1095 1,268 1,260 Interest expense (paid) 135 192 576 Taxation 76 268 150 Retained Profit 115 652 128 Fixed assets at cost 1,765 2,285 4,915 Accumulated depreciation 192 422 1,690 Closing Inventory at cost 154 346 752 Trade receivables 384 961 1,589 Prepayments 55 192 230 Overdraft 176 211 2,262 Trade payables 190 308...
Extracts Income Statements and Balance Sheets 2017 2018 2019 Sales 3,840 5,760 8,448 Cost of Sales...
Extracts Income Statements and Balance Sheets 2017 2018 2019 Sales 3,840 5,760 8,448 Cost of Sales 1,920 2,688 5,608 Distribution costs 384 462 676 Administrative expenses 1095 1,268 1,260 Interest expense (paid) 135 192 576 Taxation 76 268 150 Retained Profit 115 652 128 Fixed assets at cost 1,765 2,285 4,915 Accumulated depreciation 192 422 1,690 Closing Inventory at cost 154 346 752 Trade receivables 384 961 1,589 Prepayments 55 192 230 Overdraft 176 211 2,262 Trade payables 190 308...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux's accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 33 $ 20 Accounts receivable 48 50 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 3 2 Inventory 55 50 Long-term investment 15 10 Land 70 40 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for National Intercable Company. Additional information from NIC’s accounting records is provided also. NATIONAL INTERCABLE COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions) 2018 2017 Assets Cash $ 106 $ 95 Accounts receivable 280 275 Less: Allowance for uncollectible accounts (8 ) (6 ) Prepaid insurance 4 10 Inventory 262 255 Long-term investment 50 75 Land 180 180...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 47 $ 27 Accounts receivable 51 61 Less: Allowance for uncollectible accounts (3 ) (2 ) Dividends receivable 5 4 Inventory 69 57 Long-term investment 29 17 Land 96 50 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux's accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 121 $ 40 Accounts receivable 43 71 Less: Allowance for uncollectible accounts (5 ) (4 ) Dividends receivable 4 3 Inventory 100 95 Long-term investment 54 50 Land 95 85 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 52 $ 31 Accounts receivable 41 78 Less: Allowance for uncollectible accounts (3 ) (2 ) Dividends receivable 4 3 Inventory 100 95 Long-term investment 54 50 Land 95 85 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 47 $ 27 Accounts receivable 51 61 Less: Allowance for uncollectible accounts (3 ) (2 ) Dividends receivable 5 4 Inventory 69 57 Long-term investment 29 17 Land 96 50 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Wright Company. Additional information from Wright's accounting records is provided also. WRIGHT COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 143 $ 130 Accounts receivable 171 175 Short-term investment 70 30 Inventory 175 170 Land 130 160 Buildings and equipment 800 600 Less: Accumulated depreciation (235 ) (175 ) $ 1,254 1,090...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 57 $ 32 Accounts receivable 56 71 Less: Allowance for uncollectible accounts (5 ) (4 ) Dividends receivable 5 3 Inventory 79 62 Long-term investment 39 22 Land 123 64 Buildings and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT