This article provides example scenarios and explains various approaches for calculating the time value of money using Microsoft Excel. The Excel tools discussed herein include the FV, FVSCHEDULE, PV, ...

Key Points Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252.

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.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .