Calculation of Interest during the construction period

Description
The tool applies different method of fund requirement during the construction period. The debt is drawn periodically based on fund requirement. The interest is calculated on the debt drawn, for the duration between draw date and end of construction period. The interest is compounded. The interest is then capatilised and added to the project cost.

The project comprises of various activities with start and end dates. The fund requirement during the construction period is based on the activity cost and its start and end dates. The unit of construction period is "months". The entire construction period is divided into number of months. The tool checks on the activity duration and allocates fund within that many number of months, under different methods. Within the different fund requirement flows, the equity injection and debt drawn is based on different methods such as - all equity injected before debt, in equity/debt proportion, equity injected randomly etc. The tool applies random numbers to generate fund requirement in some methods.

In this tool, the IDC is finally, propotioned on debt/equity ratio on the last month and added to equity and debt part. It is assumed that the equity part of IDC will be put in by the investor on the last month.

The tool compares the Interest During Construction (IDC) based on different methods, along with mean, standard deviation and coefficient of variation.