You are presented with the following information: Concord Lid. Trading and profit and loss account for the year ended 31 December 2009 C000 C00 Sales Less: Costof goods askd: Opening Stock Purchases 1.000 200 700 900 300 Loss: Closing Stock 600 400 (240) Gross profit Operating expenses Operating profit Debenture interest Net profit before taxafon Taxation Net profit ater taxation Dividends Retained protit for the year 160 (10) 150 (50) 100 (60) 40 Cencerd Ld. Balance sheet asat31 December 2008 C000 2009 C000 1,050 C000 F000 Fixed assets at cost Less: Accumulated Depreciation 900 150 750 255 795 Current assets: Stocks Trade debtors 300 150 45 495 200 120 Cash 20 340 Less Currentliatilitien. Trade creditors Taxation Proposed dividend 70 40 30 140 50 200 950 206 1.090 200 Capital and reserves: Ordinary shares of £1 each Profit and loss accounts 750 200 950 750 240 990 Loans Debenture stock (10% issued on 1 Jan 2000) 100 1.090 950 Required: Prepare a cash flow statement (in accordance with IAS 7) by using Microsoft Excel for the year ended 31 December 2009. Part (b) Cash flow statement is one components of financial statements, and it provides information to aid users of financial statements for decision making. Explain usefulness of cash flow statement. 8888

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question
You are presented with the following information:
Concord Ld.
Trading and profit and loss account for the year ended 31 December 2009
£000
1.000
E000
Sales
Less: Cost of goods aold:
Opening Stock
Purchases
200
700
900
Less: Closing Stock
300
Gross profit
Operating expenses
Operating profit
Debenture interest
Net profit before taxation
Taxation
600
400
(240)
160
(10)
150
(50)
100
(60)
40
Net profit after taxation
Dividends
Retained profit for the year
Concord Ltd.
Balance sheet as at 31 December
2008
C000
2009
L000
E000
FO00
1,050
255
Fixed assets at cost
900
Less: Accumulated Depreciation
150
750
795
Current assets:
Stocks
Trade debtors
Cash
200
120
300
150
20
340
45
495
Less: Current liabilities:
Trade creditors
Taxation
Proposed dividend
70
90
50
40
30
140
60
200
950
200
295
1,090
Capital and resenes:
Ordinary shares of £1 each
Profit and loss accounts
750
200
950
750
240
990
Loans
Debenture stock (10% issued on 1 Jan 2009)
100
1.090
950
Required:
Prepare a cash flow statement (in accordance with IAS 7) by
using Microsoft Excel for the year ended 31 December 2009.
Part (b)
Cash flow statement is one components of financial
statements, and it provides information to aid users of
financial statements for decision making.
Explain usefulness of cash flow statement.
8888
Transcribed Image Text:You are presented with the following information: Concord Ld. Trading and profit and loss account for the year ended 31 December 2009 £000 1.000 E000 Sales Less: Cost of goods aold: Opening Stock Purchases 200 700 900 Less: Closing Stock 300 Gross profit Operating expenses Operating profit Debenture interest Net profit before taxation Taxation 600 400 (240) 160 (10) 150 (50) 100 (60) 40 Net profit after taxation Dividends Retained profit for the year Concord Ltd. Balance sheet as at 31 December 2008 C000 2009 L000 E000 FO00 1,050 255 Fixed assets at cost 900 Less: Accumulated Depreciation 150 750 795 Current assets: Stocks Trade debtors Cash 200 120 300 150 20 340 45 495 Less: Current liabilities: Trade creditors Taxation Proposed dividend 70 90 50 40 30 140 60 200 950 200 295 1,090 Capital and resenes: Ordinary shares of £1 each Profit and loss accounts 750 200 950 750 240 990 Loans Debenture stock (10% issued on 1 Jan 2009) 100 1.090 950 Required: Prepare a cash flow statement (in accordance with IAS 7) by using Microsoft Excel for the year ended 31 December 2009. Part (b) Cash flow statement is one components of financial statements, and it provides information to aid users of financial statements for decision making. Explain usefulness of cash flow statement. 8888
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education