Cash Flow Statement Template with Budget Versus Actuals Analysis Excel by Henry Sheykin - Financial Models https://finmodelslab.com/ Last version published: 08/05/2019
COVER PAGE
The cover page is the name of your business project, company or Food Truck name. This name is put in a yellow cell and appears on every file page afterward.
2
Setu p Financial year end in the model - input the last month of the financial year. If you don't need to assume for the financial years, simply type in Dec. First Financial Year in the model - input the very first financial year you want to start from. If you have entered Dec in the Financial year end in the model, then, your calendar year equals the financial year. Model Currency - insert the currency sign or type in USD/EUR or any other abbreviation Denomination - use denomination if you want
3
Cash Inflow
Simply re-enter in the list of Revenue placeholders you want to forecast in the rows Revenues Of course, you may use a single product name, product group or even markets as revenue streams to be forecasted. Once you ready to go with revenue assumptions, input forecasted figures for each line item for the next 12 month.
Simply re-enter in the list of Financing placeholders you want to forecast in the rows Financing This section could be used in case of selling some financial assets you own. This is not your regular revenue stream, but you are not limited to rename this section and use it as you like. Once you ready to go with financing assumptions, input forecasted figures for each line item for the next 12 month.
Simply re-enter in the list of Financing placeholders you want to forecast in the rows Financing This section could be used in case of selling some financial assets you own. This is not your regular revenue stream, but you are not limited to rename this section and use it as you like. Once you ready to go with financing assumptions, input forecasted figures for each line item for the next 12
4
Forecast: COGS and Salaries- Outflow
The model is built to be easy to use to enter expenses. Simply re-enter in the list of COGS placeholders you want to forecast in the rows COGS expense (i.e. "cost of goods sold"). And input forecasted figures for each line item for the next 12 month
Simply re-enter in the list of Salary placeholders you want to forecast in the rows Salaries And input forecasted figures for each line item for the next 12 month.
5
Forecast: Expenses - Outflow
6
This is an additional tab with flexible features to forecast fixed expenses. Enter in the list of fixed expenses (i.e. ""running the business"") you want to forecast in the rows Fixed expense. You have multiple options of when to start to pay the expense and when to end paying. You may define periodicity of the payment for each expense. It could be One-time, daily, weekly, bi-weekly, monthly, quarterly and etc. This gives you the flexibility to manage expenses.
Forecast: Assets and Financing - Outflow
Simply re-enter in the list of Assets placeholders you want to forecast in the rows Assets You may purchase some assets or you can forecast other Assets purchases.
Simply re-enter in the list of Financing placeholders you want to forecast in the rows Financing This section could be used in case of purchasing some financial assets. Once you ready to go with financing assumptions, input forecasted figures for each line item for the next 12
7
Actuals: Inflow
Simply enter actual revenues received, asset sold and financial assets sold in a specific month
8
Actuals: Outflow
Simply enter actual COGS, Salaries, Expenses paid, Assets paid and financial assets paid in a specific month
9
Dynamics tracker Revenue break down chart. This one shows you actuals & forecasted revenue streams by month. OPEX break down chart. This one shows you actuals & forecasted Operational Expenses like COGS, Salary, Fixed Expenses by month. Cash Inflow break down chart. This one shows you actuals & forecasted Operational, Investing and Financing inflows by month. Cash Outflow break down chart. This one shows you actuals & forecasted Operational, Investing and Financing outflows by month.
10
KPI tracker
11
This is a snapshot of core components of the Cash Flow Statement - Cash Inflow, Cash Outflow, Cash Balance and Net Cash Movement
Summary
The Summary sheet is a Summary of the key financial reports of the
12
Variance tracker
That is the most detailed view on the Cash Flow Statement projection. Track actual performance versus forecasted figures by each line of the Cash Flow Statement Year to date - you can do a variance analysis of each line of the Cash Flow statement. Summarized numbers starting from the year start till the last month (chosen at the top) Month to date - variance analysis of the chosen month. Year to Go - you have 12 months, with actuals figures pulled from the actuals tab.
13
Thank you very much for your interest in my tools! If you enjoyed using my model, please let people know about your experience! Give 5-star feedback here & share this page across social networks If you have any suggestions or ideas of how to make this model more useful, don't hesitate, just send me a PM - Henry Sheykin