Cash Flow Statement Template in Excel
Cash Flow Statement Template in Excel
Cash Flow Statement Template in Excel
INDIRECT METHOD
IMPERIAL COMPANY
1992 1991
Cash & equivalents 900 3,000 (2,100)
Accounts receivable (net) 5,600 4,000 1,600
Inventory 8,000 10,000 (2,000)
Prepaid Insurance 600 500 100
Prepaid Wages 1,000 600 400 One of the following is usually a plug:
Other Current Assets 400 900 (500) Acquisitions Disposals Depreciation Check
Long-term Investments 1,800 4,600 (2,800) 200 3,000 (2,800)
Net plant & equipment 70,000 53,000 17,000 22,000 1,000 4,000 17,000
Deferred tax asset 200 400 (200)
Intangible assets 2,000 3,000 (1,000) 5,000 4,000 2000 (1,000)
TOTAL 90,500 80,000 10,500
Acquisitions $
Disposals (at net book value) (73,000)
Depreciation (17,000)
Change in net plant & equipment $115,000