Analysis Tools » Cashflow Model

Cashflow Model

The Cashflow Model shows capital and operating expenditure over the modelling period.  The numbers will react depending on the Scenario you are looking at.

How to use the Cashflow Chart and Table

The Cashflow Modeling tools represent the total amounts being spent on Capital and Operating costs.  While it is useful to understand the cost of delivering an Application or piece of Infrastructure the most important number is the total spend since that represents actual budget.

As more information is fed into cloudstep its important to check these charts and tables against the actual budget.  The spend should be within the current state budget and reflect reality.  Use this in conjunction with the Cost Profile tool to make sure that costs are properly collected.

Cashflow Chart

The chart shows how the capital and operating costs vary each month as the model progresses.  Capital and oeprating costs are shown on the same axis for relative comparison.  A rolling 12 month monthly average total expenditure is also plotted to show the trend in spend.

Cashflow Table

Below the Cashflow chart the cashflow table summarises the numbers based on Financial Year.  The financial year is between the 1st day of the month and the corresponding last day of the previous month in the next calendar year.  The financial year can be set when you configure your cloudstep account.

There are a few sections in the cashflow table:

  • Application Operating Costs.  Each application and implementations of the application are shown.
  • Infrastructure Operating Costs.  Operating costs on a monthly or recurring basis are shown.
  • Infrastructure Capital Costs.  The initial or recurring capital costs are shown.
  • Project Capital Costs.  The once off capital costs for any projects.

The cashflow table can be expanded to explore these sections in more detail.

When you open up each section you'll see all the components that go to make it up.  The colour coding is important.  The more red a cell is the more the cost as increased in that financial year.  The more green is is the more it has reduced.  Use this to see how costs move and where large or important shifts occur.  You can also click through any elements you see in the table to explore them in more detail.