Even though a project may be conceptually correct, it is necessary to carry out a study in economic terms, money, in order to ensure its viability. Then, the feasibility study is the best tool to increase confidence in the success of the project. The aim of this feasibility study is to identify which will be the economic benefits for our stakeholders.
First of all, we have to define the main parameters that we are going to consider for our analysis in order to make it clear and easy to understand:
4. Incomes definition:
5. Finally, the costs based on similar airports have been considered as follows:
Besides, we have considered an annual growth of the airport traffic of 7% and a discount rate of 6% based on the forecast analysis performed. Then, as we have calculated this annual growth of the airport traffic, our feasibility study is done for 12 years due to the 7% of annual growth obtained. In other words, in 12 years we will probably have to make a new investment to avoid the saturation of the airport and enlarge its installations. So, with all this information the traffic evolutions for the first and the last year is shown in table 4:
Hence, the feasibility study is (table 5):
As it can be seen, the cash flow will be 56,2 M$ in year 12. Besides, this positive cash flow is obtained since the first year (15,74 M$). The discount cash flow (M$) affects a lot the value of cash flow, although in year 12 it will be greater than in year 1 because the change of international behavior of the airport, which has been forecasted to achieve a 63% of the total number of passengers. The NPV, after 12 years, is 139,2 M€ and ROI is 1,3, what indicates the profitability of this project in this period of 12 years. The IRR (internal rate of return) has been calculated for 12 years that is the period until the next investment. The value of 8,81% is a good value, this value indicates us that this project will be profitable. And finally, the PBT is 6,22 years, it indicates that in 6,22 years the investment will be recovered.
All these indicators have good values which ensure us about the profitability of our business.
In the following link, you can find the whole analysis for the 12 years: feasibility study.
Although this analysis shows us that our business will be profitable, it just represents a base scenario. In order to increase the confidence in our project, it is mandatory to define two more scenarios: optimistic one and pessimistic one.
With all of these changes in the considered factors, we obtain the following results that are shown in table 6:
As can be seen, in all scenarios our business is profitable although obviously not at the same level.
Once we have performed the feasibility study, now we need to identify which are those factors that can be more risky. In order to do so, we will carry out a study for each variation of external and internal factors based on how they affect parameters such as NPV, ROI, IRR and PBT. It should be noted that the criteria used to define the sensitivity that one factor has over the considered parameters is:
In that manner, the following factors will be considered for this analysis (table 7):
These variations allows us to evaluate in which degree of sensitivity is each factor. To make easier the reading of this analysis, just the results of the first variation will be shown in table 8 and if you want to go further, you can enter here to access to all detailed analysis: sensitivity study. Remember the criteria shown above (red, orange, green).
After that, the control matrix can be fulfilled as follows in figure 1 so as to know which parameters need more control:
Finally, after performing all this analysis we obtain the following conclusions:
We already know which are the most risky factors, so we must keep it controlled and monitored while performing a risk analysis so as to have a plan in case of crisis of any of these factors or even others.