Excel GAEU interest function

Most of the loans are repaid within equal total installments, which include increasing principal repayments. However, it is not uncommon for a loan to have decreasing total installments that include equal principal paid back every month. In this video we explain how to calculate the total interests in such circumstances within yearly forecasting timelines without any supporting amortization tables that are commonly used instead.
Simultaneously, we demonstrate how to build custom functions using the tool that has been introduced in the recent versions of Excel.

Jerzy Klimowicz, MSc, Financial Manager, Partner