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

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

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 .

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

To calculate your LTV ratio using Microsoft Excel for the example above, first right click on columns A, B, and C, select Column Width and change the value to 30 for each of the columns.