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.

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

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

Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...

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.

If you have a recent pay stub, you can use Microsoft Excel to calculate your annual salary, as well as estimate how much a raise will affect your paychecks. Here are the steps to calculate yours. How ...

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