Loan: amortization table
The bank's loan simulator: payment with PMT, a month-by-month table until it's paid off, total interest and an area chart showing interest falling and principal rising.
Area: Finance. Level: Advanced.
Functions used: PMT, SUM.