Powerful and Customizable Debt Module Excel Model

Description
This module allows calculating a schedule of principal and interest debt payments with high customization:

- annuity, amortization or custom debt repayment scheme
- monthly, quarterly, semiannual or annual payment schedule
- maturity and interest rate settings
- support of grace periods for interest and principal payments
- customizable timeline grid - monthly, quarterly, semiannual or annual
- upfront fee
- auto check for errors

This module could be used as a separate tool for debt planning or integrated into financial models.

Debt is something, usually money, borrowed by one party from another. Debt is used by many corporations and individuals to make large purchases that they could not afford under normal circumstances. A debt arrangement gives the borrowing party permission to borrow money under the condition that it is to be paid back at a later date, usually with interest.
The most common forms of debt are loans, including mortgages, auto loans, personal loans, and credit card debt. Under the terms of a loan, the borrower is required to repay the balance of the loan by a certain date, typically several years in the future. The terms of the loan also stipulate the amount of interest that the borrower is required to pay annually, expressed as a percentage of the loan amount. Interest is used to ensure that the lender is compensated for taking on the risk of the loan while also encouraging the borrower to repay the loan quickly to limit his total interest expense.