Answer:
Burgess Company statement of cashflows shows a Net decrease in Cash & Cash Equivalents of $30 Million and Closing Cash & Cash Equivalents of $49 Million. Complete solution using indirect method is presented below and also attached in Excel format.
*Please note that all figures are 'dollars in millions' and figures in brackets represent negative figures
Explanation:
Burgess Company
Statement of Cash flows
Net Profit before tax $178
Adjustment of Non Cash Expenses:
Depreciation (Working 1) $132
Gain on Sale of Equipment $(3)
Increase in Accrued Liabilities $25
Working Capital Changes:
Increase in Inventory $(45)
Increase in Accounts Receivables $(65)
Increase in Accounts Payables $95
Cash generated from Operations $317
Tax Paid (Working 2) $(57)
Net cash from operating activities $260
Cash flows from Investing Activities
Purchase of Property, Plant & Equipment Working 3) $(62)
Proceeds from Sale of Equipment $8
Net cash from investing activities $(54)
Cash flow from Financing Activities
Repayment of Bonds Payable $(170)
Dividends paid (Working 4) $(66)
Net cash from Financing Activities $(236)
Net decrease in cash and cash equivalents $(30)
Opening cash and cash equivalents $79
Closing cash and cash equivalents $49
<u>Workings </u>
<u>Working 1</u>
Opening Accumulated Depreciation $641
Add: Depreciation Charge for the year (Balancing Figure) $132
Less: Depreciation of Equipment Sold $(8)
Closing Accumulated Depreciation $765
<u>Working 2</u>
Opening Tax Payables $70
Add: Tax Payable charged to Income Statement $63
Less: Cash Payment (Balancing Figure) $(57)
Closing Tax Payable $76
<u>Working 3</u>
Opening Property, Plant & Equipment $1,466
Add: Purchases during the year (Balancing Figure) $62
Less: Sold during the year $(13)
Closing Property, Plant & Equipment $1,515
<u>Working 4</u>
Opening Retained Earnings $928
Add: Net Income for the Year $115
Less: Dividends Paid During the year (Balancing Figure) $(66)
Closing Retained Earnings $977