Financial Functions in Excel: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 4: Line 4:


=Interest Payment=
=Interest Payment=
==PMT==


* https://support.office.com/en-us/article/pmt-function-0214da64-9a63-4996-bc20-214433fa6441
* https://support.office.com/en-us/article/pmt-function-0214da64-9a63-4996-bc20-214433fa6441
Calculates the payment for a loan based on constant payments and a constant interest rate.


  PMT(interest_rate, number_of_payments, principal, [future_value], [type])
  PMT(interest_rate, number_of_payments, principal, [future_value], [type])


* https://support.microsoft.com/en-us/office/pv-function-23879d31-0e02-4321-be01-da16e8168cbd?ui=en-us&rs=en-us&ad=us
==PV==
 
* https://support.microsoft.com/en-us/office/pv-function-23879d31-0e02-4321-be01-da16e8168cbd
 
Calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal.

Revision as of 04:30, 4 June 2020

Internal

Interest Payment

PMT

Calculates the payment for a loan based on constant payments and a constant interest rate.

PMT(interest_rate, number_of_payments, principal, [future_value], [type])

PV

Calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal.