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 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.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...