Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

Calculating Nonadjacent Values in Excel Even if you have values that are not in an adjacent cell, you can still calculate them.

We will use this GCD function in Excel to calculate the ratio. We have created a sample data shown in the above screenshot. First, we will calculate the GCD, then we will use this GCD value to ...

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

How to Calculate Percentage Change Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.

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

It is fairly straightforward to calculate the equity risk premium for a security using Microsoft Excel; you can even find out how to estimate the expected return.