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

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

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

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.

A TechRepublic member wrote for advice on calculating the years, months, and days elapsed between two dates. This tutorial explains the solution provided by TechRepublic contributor Jeff Davis.

A. There are many ways to calculate depreciation in Excel, and several of the depreciation methods already have a built-in function included in the software. The table below includes all the built-in ...

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.

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

How to Use a Payroll Calculator in an Excel Spreadsheet. For small business owners who prefer to do their own payroll, one option is to use a Microsoft Excel spreadsheet to keep track of employee pay.

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.