The Excel FV function is a financial function that returns the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate. Syntax […]
Read more →
The PMT function returns a payment amount, so you can use it to: Calculate the monthly payment due on a personal loan Calculate the payment due for a Canadian mortgage loan, with interest compounded bi-annually Syntax The syntax for the […]
Read more →
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today’s dollars of a series of future payments, assuming periodic, constant payments and […]
Read more →