Pro Forma Cash Flow Statement Template

To create a pro forma cash flow you need to know your current cash position.

Pro forma cash flow statement template. It can be defined as the probable amount of cash inflows and outflows expected in future periods for a specific duration of time. To demonstrate the steps of building a pro forma cash flow let s use a hypothetical company west coast shoe wholesalers inc. Includes all 161 global currencies. The following excel spreadsheet provides a template of a typical cash flow statement which may be useful for your small business accounts. Cap table investor return summary and key metrics reports.

Detailed staffing report with all employee driven costs. Full year pro forma projection. Pro forma financial statement excel template. The fields in the tan colored cells of the spreadsheet are left blank for you to enter your own figures and you can also change labels for these rows to reflect your own categories of cash flows. Income statement balance sheet and cash flow.

Examples of pro forma statements. For more templates check out our collection of proforma balance sheet templates. According to the sec when the dividends from stock exceed or are planned to exceed the current earnings the eps must be calculated. Bank cash flow statement template. Pro forma cash flow statement is a popular accounting practice that reports a voluntary statement prepared by a firm for presenting financial projections.

That means taking info from the income statement then using the cash flow statement format to plot out where your money is going and what you ll have on hand at any one time. Creating a pro forma cash flow statement. This is a projection of an organization s year to date results to which expected outcomes for the rest of the year are included to arrive at a set of full year pro forma financial statements. Detailed capex and depreciation calculations. Detailed sales report with all customer lifetime value metrics.

Once you download this file you should print it and use it as is. This is a very useful pro forma excel template that can be used to create a pro forma balance sheet for a company by listing its various assets liabilities and surplus. Pro forma cash flow statement template in excel. You create a pro forma cash flow statement much the same way you d create a normal cash flow statement. Pro forma eps are calculated in the pro forma income statement but the figure is also used in the pro forma balance sheet and the pro forma cash flow statement when necessary.

Pro forma cash flows predict inflow and outflow of cash to your business. The cash flow statement or statement of cash flows summarizes a company s inflow and outflow of cash meaning where a business s money came from cash receipts and where it went cash paid by cash we mean both physical currency and money in a checking account.