Financial Functions in Excel

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

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.