Question: what is ipmt and ppmt?
Answer: The IPMT function calculates the interest repayment for each period for a capital loan taken out over a term at a fixed interest rate. The parts of the IPMT functions are =IPMT(Interest, period number, periods, Amount). ... The parts of the PPMT functions are =PPMT(Interest, period number, periods, Amount).