Excel Formulas for Finance

### How to Calculate Tracking Error in Excel (with Detailed Steps)

Tracking error is one of the most crucial metrics for evaluating a portfolio's performance and a portfolio manager's potential for outperforming the ...

### How to Calculate Time Weighted Return in Excel (2 Simple Ways)

We need to keep updated about an investment. There are many factors in order to keep track of it. Time Weighted Return is just like a parameter to ...

### How to Calculate Cash Flow in Excel (7 Suitable Examples)

In this article, we are going to focus on how to calculate cash flow in Excel. There exist different types of cash flow like annual, incremental, ...

### How to Calculate Annuity in Excel (5 Practical Examples)

In this tutorial, I am going to show you 5 practical examples of how to calculate annuity in Excel. Finding out the various aspects of an annuity is ...

### How to Calculate WACC in Excel (with Easy Steps)

WACC is a useful parameter that can help you to extract insight about a company. You can use this parameter to decide whether you should invest or ...

### How to Calculate VAT in Excel (2 Handy Ways)

In many situations, you may need to calculate value-added tax or VAT. When you have a tool like Microsoft Excel, you can easily perform this kind of ...

### How to Calculate Bond Price in Excel (4 Simple Ways)

Excel in-built has functions that are used to calculate financial components. Users trying to calculate the bond price in Excel are the reason for ...

### Mortgage Calculations with Excel Formula (5 Examples)

In this article, we are going to learn about how to do mortgage calculations with Excel formula. We will explain the whole process with 5 suitable ...

### How to Convert Percentage to Basis Points in Excel

In the financial world, you may encounter the term Basis Points. Itâ€™s the usual hearing percentage and basis point simultaneously. Today In this ...

### How to Calculate Depreciation in Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this ...

### XIRR vs IRR in Excel (Differences with Examples)

In order to assess the return on investment over time, the IRR function determines the internal rate of return on the capital after taking the ...

### Excel XNPV vs NPV: Comparison with Examples

In the case of investing money in a business, we need to consider many factors related to the investments and keep up to date. Net Present Value ...

Advanced Excel Exercises with Solutions PDF