Cash Flow Projection For 12 Months Templates

This Excel template named Cash Flow Projection For 12 Months. Like its name, the purpose of this template is for recording your cash flow in a year. Cash Flow Projection For 12 Months can help you in managing your financial and accounting. Cash Flow Projection For 12 Months can be used for personal use or small to medium company.

THE MENUS

Cash flow projection for 12 months template has 4 menus displayed in each sheets or as the buttons on the right top corner.

12 month cash flow projection template
12 month cash flow projection template

Guidelines

Menu for explaining the purpose and brief instructions about how to use this template.

Explanation of Data

Menu that explain the legends used in cash flow forecast 12 months excel. It is like basic dictionary for each word used.

Because both Guidelines and Explanation of Data menus are not essential, you can delete or ignore them. Do not delete if you still not familiar on how to use this template.

Projected Cash Flow

Menu for recording the planned budget for a year.

Actual Cash Flow

Menu for recording the actual income and expenses for a year.

Both menus are main menus. The fields are all same, so the explanations for these menus will displayed at once below.

HOW TO USE

First, Change the Year, Company Name, and Update Date on the top left header.

The cash flow forecast for 12 months divided into 4 parts:

  1. Income and the Cash on Hand. Symbolized with blue color. Enter all your income source and amount here.
cash flow forecast for 12 months
cash flow forecast for 12 months
  1. Expenses, symbolized with orange color. Enter all expenses and liabilities sources and amount here. Remember to only input the expenses that require cash out.
cash flow forecast 12 months excel
cash flow forecast 12 months excel
  1. Cash Position, symbolized with green color. This is where you enter the adjustment value (income or expenses) that do not require cash in or cash out. The example is depreciation, where the value of items keep reduced, but it will not cost the cash in hand.
cash flow projection for 12 months template
cash flow projection for 12 months template
  1. Checking. The purpose is to determine whether the liabilities and assets are balance like accounting principles. The explanation of checks can be seen in Guidelines Sheet.
cash flow projection for 12 months example
cash flow projection for 12 months example

NOTES: there may be error in the row adjustment in this part. You may need to adjust the formula with right field name/code. Look at Guidelines to correctly adjusting the formula.

Other Notes

The first column is pre-startup which function to enter the balance from previous year. Remember to only input the previous cash flow amount on [Beginning of month] row. If you enter other row in this column, it may cause errors in Checking Verification. If you still insist to enter the other rows in this column, you may need to adjust the Totals calculation formulas to avoid the Checking Error, or simply write new formula for Checking part.

Related Template:  Detailed Sales Pipeline Management Template Excel

You can enter the values amounts to the rest of the fields. Do not change the fields that has been set up with formula, unless you totally want to edit or modify the template.

The last column is Total column. You can copy the value and paste to new Cash Flow template for next year.

You can use the 12 months cash flow projection template to compare and determine the over-budget or under-budget status. To make it easier to compare, you can make both sheet displayed side by side at the same time:

  1. On View tab, click New Window.
  2. Once the new window popped up, click View Side by Side button.
  3. Both window will automatically split into two parts. You can resize it into vertical view or horizontally.
  4. Click Synchronous Scrolling to scroll both worksheets at the same time.
cash flow projection for 12 months example-2
cash flow projection for 12 months example-2

CONCLUSION

Aside for monthly cash flow, you can turn the Cash Flow Projection For 12 Months for yearly use or for each project. The Cash Flow Projection For 12 Months is open source template, you can edit and modify it for free. The Cash Flow Projection For 12 Months can be downloaded for free.

Related templates

  • 12 month cash flow template
  • 12 month financial projection template
  • 12 month cash flow projection
  • cashflow projection for 12 months
  • cash flow projection template
  • twelve months cash flow projection
  • cash flow projection-12 months projections
  • cash flow projection template excel
  • cash flow for next 12 months
  • one year financial projections template
  • creating an accurate 12 month cash flow projection
  • exampls of 12 month cash flow forecast
  • cashflow projection free
  • easy 12 month cash flow forcast template
  • exemple cash flow 12 mois
  • financial flow monthly subprocces
  • financial projections template
  • TWELVE MONTHS CASHFLOW PROJECTIONS
  • how to write projection s for next 12 months
  • IC-12-Month-Cash-Flow-Forecast-Template
  • monthly cash flow template
  • projection for the month project the year
  • project 12 months
  • cash projection template
  • 12 month cash flow chart
  • 12 month cash flow excell
  • 12 month cash flow for gym template
  • 12 month cash flow forecast excel
  • 12 month cash flow spreadsheet
  • 12 month cash flow template excel
  • 12 month cash flow worksheet template excel
  • 12 month cashflow projection
  • 12 months Cashflow statement
  • 12 months projection
  • A 12 months cash flow projection template
  • cash flow projection template excel free
  • cash flow projection template word
  • 1 year cash flow projection
  • cash flow sheet printable 1 Month
  • www cash flow for two months