Cash Flow Projection - Monthly Template

Use this cash flow projection template to compile monthly cash flow projections for 36 monthly periods in Excel. Cash flow projections are based on user defined monthly turnover, gross profit and expense values and automated calculations based on a series of user assumptions. The template produces an automated monthly income statement, cash flow statement and balance sheet.

• Includes 36 monthly periods
• Suitable for service and trade based businesses
• Reporting periods based on a single user input cell
• User input limited to basic template assumptions
• Expense accounts can be customized & more accounts added
• Automated income statement, cash flow statement & balance sheet
• Accommodates loan amortization or interest-only loans
• Includes sales tax, income tax, payroll accruals & dividends