Excel: payment against principal
Tutoring financial math, amortization arises. The tutor mentions the Excel function for it. Example: For a 25-year loan of $100,000 at 4%, compounded monthly with monthly payments, what is the amount against the principal of the 101st payment? Solution: Using …