All

Computing Annual Payment for a Loan

Google+ Pinterest LinkedIn Tumblr
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)

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close