Excel-Skills.com

Which Excel cash flow template do you need?

All six cash flow templates turn a few assumptions into a full 3-way forecast: an income statement, cash flow statement and balance sheet that stay in balance. Working capital, sales tax, income tax, payroll accruals, dividends and loan repayments are calculated for you.

Two questions decide which one fits: how far ahead and in how much detail you need to forecast, and whether you also want to compare actual results with the forecast.

Quick answer: which template should you choose?

Feature comparison

Feature Cash Flow Projection - WeeklyCash Flow Projection - MonthlyCash Flow - Business Plan ForecastCash Flow Projection - AnnualCF Weekly - Forecast vs ActualCF Monthly - Forecast vs Actual
Forecast periods 52 weeks 36 months 12 months + 5 years 5 years 52 weeks 36 months
Income statement, cash flow statement and balance sheet ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Working capital, sales tax, income tax and payroll accruals ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Loan and lease repayments ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Compare actual results with the forecast –No –No –No –No ✓Yes ✓Yes
Forecast vs actual management report –No –No –No –No Weekly, quarterly and year-to-date Monthly and year-to-date

The templates in detail

Cash Flow Projection - Weekly Template

Weekly cash flow forecast with reports for 52 weeks.

Best for:
Businesses that need a rolling 13-week or full 52-week cash flow forecast
Not suitable for:
Comparing the forecast with actual results (use Cash Flow Weekly - Forecast vs Actual)

View the Cash Flow Projection - Weekly template

Cash Flow Projection - Monthly Template

Monthly cash flow projections with reports for 36 months.

Best for:
Businesses forecasting cash flow month by month for up to 3 years, with a full income statement and balance sheet
Not suitable for:
Comparing the forecast with actual results (use Cash Flow Monthly - Forecast vs Actual)

View the Cash Flow Projection - Monthly template

Cash Flow - Business Plan Forecast Template

Business plan forecast with 12 monthly and 5 annual periods.

Best for:
Start-ups and business plans that need 12 monthly and 5 annual periods for lenders or investors
Not suitable for:
Annual-only forecasts (use Cash Flow Projection - Annual) or monthly forecasts beyond 12 months (use Cash Flow Projection - Monthly)

View the Cash Flow - Business Plan Forecast template

Cash Flow Projection - Annual Template

Annual cash flow forecast with reports for 5 years.

Best for:
Business plans and lenders that need a 5-year annual forecast with an income statement, cash flow statement and balance sheet
Not suitable for:
Monthly or weekly forecasts (use Cash Flow Projection - Monthly or Weekly) or comparing forecasts with actual results

View the Cash Flow Projection - Annual template

CF Weekly - Forecast vs Actual Template

Weekly forecast vs actual results over a 1 year period.

Best for:
Businesses that forecast weekly and compare actual results with the forecast
Not suitable for:
Forecast-only projects (use Cash Flow Projection - Weekly) or monthly tracking (use the monthly version)

View the CF Weekly - Forecast vs Actual template

CF Monthly - Forecast vs Actual Template

Monthly forecast vs actual results over a 3 year period.

Best for:
Businesses that forecast monthly and track actual results against the forecast over 3 years
Not suitable for:
Forecast-only projects with no actual results to compare (use Cash Flow Projection - Monthly) or weekly tracking (use the weekly version)

View the CF Monthly - Forecast vs Actual template

Frequently Asked Questions

What is the difference between a cash flow projection and a forecast vs actual template?
A cash flow projection template forecasts future results only. A forecast vs actual template does the same, then lets you enter or copy actual results and compare the two in a management report.
Which cash flow template should I use for a business plan?
Use the Business Plan Forecast template, which covers 12 monthly periods followed by 5 annual periods. If the lender only asks for annual figures, the Annual Cash Flow Projection template is enough.
Do the cash flow templates include a balance sheet?
Yes. All six produce an automated income statement, cash flow statement and balance sheet from your assumptions, with cash as the balancing figure.
Are the cash flow templates suitable for service and trade businesses?
Yes. They work for both: turnover, gross profit percentages and expenses are entered by you, and the expense accounts can be customised and extended.
How do the cash flow templates handle loans?
Loans and leases are calculated with amortization tables that split each repayment into interest and capital. Amortising and interest-only loans are both supported, with repayment periods of up to 30 years.