Note: | ||||||||||||||
This section will provide you guidelines on how to prepare cash flow statement of your business. | ||||||||||||||
The statement templates provided, serve as a guide towards bare minimum line items that may be included in the financial statements. Please note that complete set of financial statements includes: income statement, balance sheet and cash flows along with explanatory notes. Further, you may seek professional guidance for preparation of formal financial statements, if deemed necessary. | ||||||||||||||
Entries in this template that are marked in black indicate use of formulae. Please avoid tempering with formulae based entries. | ||||||||||||||
Cash Flow (Amount in Rs.) | ||||||||||||||
Description | Reference | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||
A | Net Profit | Net profit / loss for the year | Income Statement 'S' | |||||||||||
B | Depreciation | Add depreciation charged for the year | Income Statement 'L' | |||||||||||
C | Interest Expense | Add interest charged for the year | Income Statement 'O' | |||||||||||
D | Accounts Receivable | Add
change in accounts receivable (current year minus previous year) |
Balance Sheet 'B' | |||||||||||
E | Inventory | Add
change in inventory (current year minus previous year) |
Balance Sheet 'C' | |||||||||||
F | Pre Paid Expenditures | Add
change in prepaid expenditures (current year minus previous year) |
Balance Sheet 'D' | |||||||||||
G | Accounts Payable | Add
change in accounts payable (current year minus previous year) |
Balance Sheet 'M' | |||||||||||
H | Other Liabilities | Add
change in other liabilities (current year minus previous year) |
Balance Sheet 'O' | |||||||||||
I | Cash from
Operations Inflow / Outflow |
(A+B+C+D+E+F+G) | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
J | Mark-up Paid | Subtract
expense for the year (Refer to loan schedule provided by the bank) |
||||||||||||
K | Net Cash
from Operations Inflow / Outflow |
(I - J) | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
L | Short Term Debt | Actual
cash paid for repayment of loan or cash obtained from acquisition of new
loan (Refer to loan schedule provided by your bank) |
||||||||||||
M | Long Term Loan | Actual
cash paid for repayment of loan or cash obtained from acquisition of new
loan (Refer to loan schedule provided by your bank) |
||||||||||||
N | Cash from
Financing Inflow / Outflow |
(L+M) | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
O | Capital | Add
change in owners' equity to reflect additions (current year minus previous year) |
Balance Sheet 'S' | |||||||||||
P | Fixed Asset Investment | Actual cash utilized for acquisition of fixed assets or cash received from disposal of fixed assets | ||||||||||||
Q | Cash from
Investing Inflow / Outflow |
(O+P) | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
Net Cash Inflow / Outflow |
(K+N+Q) | 0 | 0 | 0 | 0 | 0 | 0 | |||||||