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.

Every base-year trend percentage equals 100 percent. Calculate each year's trend percentage separately for each account and for each section total on the balance sheet.

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