Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.

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.

Finding percentage change in Excel requires calculating the difference between two numbers, dividing that difference by the successive number and changing the decimal value to a percentage.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

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