Consider a loan with an annual interest rate of 6%, a 20-year duration, a present value of 150,000 EUR (amount borrowed) and a future value of 0 (that’s what you hope to achieve when you pay off a loan).
Present Value (pv) 150000
Future Value (fv) 0
Annual Interest Rate (rate) 6%
Terms (Years) (nper) 20
Compounding periods per year 1
Annual Payment (pmt) -13.077,68 €
Calculate the annual payment of a loan with
the PMT function
Τύπος κελιού F10 =PMT(F7;F8;F5;F6;0)
Views: 0
Comments are closed.