2.1.4.1 Outputs

In the Deviations Graph you will then see how the deviations between the to different plans are formed. In the example below, Plan A had an expected return of 4.8% (Equity IRR), while Plan B has an expected return of 3.2% (Equity IRR). As seen in the graph, these differences are due mainly to the negative impact on sales but recovered partially due to lower Opex and Taxes. You can change this Deviations graph to Payout IRR and Payout IRR 2.

On the right side you also see the differences between the main KPIs of the two project versions. You can change the Min DSCR fwd and bwd looking period by clicking on Edit next to the KPI Table title.

Below those two charts, you also find a further Deviations graph / table (see screenshot below). In this graph, the amounts of the P&L r the cashflows of the cashflow statement, respectively dependen on the selection, are compared to each other. It is important to note that the Plan is always set to a 100%. Right of it (in green if positive from IRR perspective, in red if negative from IRR perspective) you see the total PL / CF of the actual version as % of the total of the original version. To clarify a calculation example: If the total production  in the original plan was 100, and the total production in the actual plan is 80, the original plan is set to a 100% while the value of the actual plan is 80/100 = 0.8 or 80%. You can change the aggregation period to Lifetime, YTD and the time-period with actual figures.

YTD-Tab

In the YTD view you see a comparison between the original project version and the actual version regarding Production, Sales, Opex, EBITDA and NOPAT. This on a monthly basis. The dark blue stands for the actual plan, the light blue for the original plan. You can see this as either bulk, line or table. If you switch to forecast, you also see the differences based on forecasted figures for the year.

 

On the bottom you have this same analysis but over the whole YTD period for PL, CF and Balance Sheet. Here you can also include the forecast if you wish to do so.

LTD

Lifetime To Date (LTD) offers the same analysis as YTD, but over the whole period that has been concluded and on a yearly basis. If you select forecast you also see the differences in the forecasted period.

 Financial Model

In the financial model tab you see the differences in PL, CF, Balance Sheet and Production over the whole lifetime of the project. This can be seen as graph and table and on a yearly, quarterly and monthly basis. Please note that you see in the title whether the figures belong to actual figures or to plan figures. Depending on which it is, it will state Plan or Actual.

Â