Cashflow (Revision) - Practice QA
Cashflow (Revision) - Practice QA
Cashflow (Revision) - Practice QA
1
The following information has been extracted from the draft financial statements of Alpha Limited for the year
ended 31 December 2015.
Rs. in '000’
Sales 273,000
Cost of sales (187,500)
Gross profit 85,500
Operating expenses (46,766)
Other income 11,200
Profit before interest and tax 49,934
Interest expense (2,000)
Profit before tax 47,934
Tax expense (15,000)
Profit after tax 32,934
Additional information:
(i) 60% of sales were made on credit.
(ii) UL maintains a provision for doubtful receivables at 6%. During the year, trade receivables of Rs. 7 million
were written off.
(iii) Depreciation expense for the year was Rs. 22.5 million. 70% of the depreciation was charged to cost of
sales.
(iv) Other income comprises of:
gain of Rs. 3 million on disposal of vehicles for Rs. 12 million;
maintenance income of Rs. 8 million; and
discount of Rs. 10 per debenture which were redeemed during the year.
Required:
Prepare UL’s statement of cash flows for the year ended 30 June 2017 using direct method. (15)
(Q1, Autumn 2017)
Solution No. 1
Alpha Limited
Statement of cash flows
For the year ended December 31, 2015
Rs in million
Cash flows from operating activities
Profit before tax (114 – 53 + 17) 78.00
Adjustments for:
Interest expense (40 × 0.13 × 5 ÷ 12) 2.17
Depreciation (W-1) 17.00
Gain on sale of building (20 – 18) (2.00)
Bad debts expense (W-2) 5.63
Provision for gratuity (6 + 6.5 – 3) 9.50
32.30
Operating profit before working capital changes 110.30
W-1 Customers
Rs.'000 Rs.'000
b/d 59,574 Receipts (bal.) 253,234
Sales 273,000 Write off 7,000
c/d 72,340
332,574 332,574
W-2 Suppliers
Rs.'000 Rs.'000
Payments (bal.) 181,750 b/d 39,000
c/d 42,000 Purchases 184,750
223,750 223,750
Inventory
Rs.'000 Rs.'000
b/d 45,000 COS [187.5 - 22.5 x 70%] 171,750
Purchases (bal.) 184,750 c/d 58,000
229,750 229,750
W-3 Operating expenses
Rs.'000 Rs.'000
Payments (bal.) 30,250 b/d 18,000
c/d 20,000 Exp. [W-3.1] 32,250
50,250 50,250
W-3.1
Cash expenses = Operating exp - Dep - Bad debts [W-3.2]
= 32,250
W-4 Tax
Rs.'000 Rs.'000
Payments (bal.) 27,500 b/d [6 + 8] 14,000
c/d 10,000 Expense 15,000
c/d 8,500
37,500 37,500
W-5 PPE
Rs.'000 Rs.'000
b/d 120,000 Disposal [12 - 3] 9,000
Revaluation 10,000 Depreciation 22,500
Addition (bal.) 60,000 c/d 158,500
190,000 190,000
W-6 Rs.'000
Other income 11,200
Gain on vehicle (3,000)
Maintenance income (8,000)
Discount on redemption [A] 200
Total redemption payment [A x 90/10] 1,800
W-7 RE
Rs.'000 Rs.'000
Dividends (bal.) - b/d 21,500
c/d 54,434 PAT 32,934
54,434 54,434