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.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

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.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

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 .