Calculating Present Values With Microsoft Excel

The PV function calculates the present value of an annuity, or future value, given the periodic rate, number of periods, payment, future value (or balloon payment), and, optionally,the type-of-annuity switch. Sometimes, why you would use this function seems strange. But it’s often useful when working with loans or with investments. For example, if you want […]

Read more