Debt Servicing Tool with Moratorium Period Option

Description
The tool dynamically calculates the period wise debt servicing based on payment frequency - annual, bi-annual, quarterly or monthly. The tool indicates all the payment dates with principal and interest portion of the debt servicing separately.

There is a provision of Moratorium period at the start of the debt period. There are options of paying the interest during Moratorium period or carry forward  and pay after the Moratorium period.

The tool can be made part of a project feasibility financial model or a housing/vehicle loan schedule or any infrastructure finance model.

The basic data are entered in tab "Option 1" in colored cells only. The "Option 1" and "Option 2" tab extends the payment schedule based on loan term and payment frequency. The model is ready for 240 period (12 months X 20 years) but can be copied further down.

The user needs to use only those codes (not case sensitive) provided in a table, for payment frequency. Use of any other code will result in error. The payment dates are based on number of days in the payment period and not on number of months, resulting one day off in some months.