MBA
International Project Finance
Unit 8: Project cashflow models

Using the Base Case cashflow model, create each sensitivity test described in Unit 8 of the course module. Note the effect on the project cashflows, control ratios (DSCR & LLCR), project and investors' returns and the loan repayment date.

You can generate each sensitivity test using the Base Case Model.

Examples of each of those sensitivity cases is available using the links opposite
.

Sensitivity tests cases - results
Table of results

Base Case
Base Case model

Sensitivity test cases
Electricity offtake tariff reduced by 10% from year 6
Incomplete fuel costs passthrough with costs 20% higher from year 6
Electricity offtake tariff increased by 8% from year 6
Interest rates increased by 4%pa from period 9
FX rates on equipment procurement increase by 15%
Construction delay of 6 months following a fire. Additional costs US$104m
Construction delay - insurance payout to restore economic damage
Worst case - example