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 .

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.

Calculating the future value of a present single sum with multiple interest rates This example shows how to use the ­FVSCHEDULE function in Excel to calculate the future value of a present single sum ...

When planning for retirement, you need to account for the value of any annuities that you own. Trouble is, there’s not just one value of an annuity—there are two: present value and future ...

To calculate the expected future value based on your growth rate, add one to the rate, and raise this to a power equal to the number of years you're looking at.

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