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

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.

Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft Excel.

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.

Original Price * (1 – Percentage Decrease). If you need to reverse a discount or calculate the original price from a tax-inclusive amount, divide the adjusted price by: (1 – Percentage Decrease).

In this article we will take a quick look at simple formulas in Excel, especially the calculation of VAT and inclusive of the sale price (including tax) for a purchase price without VAT (tax).

How to Calculate Breakpoints in Excel. A price breakpoint is a discount you offer your customers based on the amount of units that they order. The breakpoint is the lower value of the range that ...

An ideal way to calculate inflation-adjusted prices is by collecting data on a particular indicator, preferably a consumer price index.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.