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.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for calculating fluctuations, depending on whether ...

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

Learn about yield as it pertains to bonds and how to calculate it using Microsoft Excel.

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

How to add a condition to rank using a PivotTable in Excel A simple rank is easy to calculate, but sometimes you’ll want to accommodate a condition.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

When calculating the CAGR, you must first add the periods and the values for each period. To do this, you need a column focused on Years and another column focused on the Amount. If you are still ...

How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...