How to Calculate Maximum Sales Price in Excel. You have three ways to calculate sales price in Excel. First, you can apply a flat profit to the cost of the item as a dollar value.

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

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 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 ...

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).

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.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

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