Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

Microsoft Excel offers four inherent functions for calculating the monthly payments, present value, number of payments and the interest rate of an annuity.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Net present value (NPV) represents the difference between the present value of cash inflows and outflows over a set time period. Knowing how to calculate net present value can be useful when ...

Everything you need to know to calculate an interest rate with the present value formula.

To calculate the future value of a single amount compounded daily, you must write your own formula. The set values you need to know are the starting amount and the rate of interest.

We can use a simple formula to calculate the present value of a perpetuity annuity. This formula will tell us what a perpetuity is worth based on a discount rate, or a required rate of return.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.