Excel for Finance

### How to calculate effective interest rate on bonds using Excel

In this blog post, I will discuss how to calculate the effective interest rate on bonds using Excel. What is the effective interest rate? If ...

### Nominal Interest Rate Formula Excel (calculate from Effective Rate)

Except learning the nominal interest formula Excel, we shall also cover several topics in this article. What will you learn from this article? ...

### Mortgage payoff calculator with extra principal payment (Free Template)

Mortgage Payment Calculator with Extra Principal Payment "No Macro used. No installation is necessary. Just download and start ...

### Mortgage Payoff Calculator with Extra Payment (Free Excel Template)

Mortgage Payment Calculator with Extra Payment "No Macro used. No installation is necessary. Just download and start using." - ...

### How to calculate periodic interest rate in Excel (4 ways)

In this short article, I will show how to calculate periodic interest rates in Excel. I will show 4 methods of calculating the periodic ...

### How to calculate IRR (internal rate of return) in Excel (9 easy ways)

In this article, I will discuss how to calculate/find IRR (internal rate of return) in Excel. I will focus on several topics like: Calculating ...

### How to calculate monthly payment in Excel (with Excel calculator)

In this article, I will show you how to calculate monthly payments in Excel with some examples and criteria. Here are the criteria: You ...

### How to Use Compound Interest Formula in Excel

Compound interest is the interest that's calculated both on the initial principal of a deposit or loan and on all previously accumulated interest. In ...

### Best 7 Books on Financial Modelling Using Excel

Where do financial modelers work? The world of finance can be a very complex place that at times is quite tricky to navigate. One has, for example, ...

### Nominal Interest Rate vs. Effective Interest Rate Excel Formulas

There are different types of interest rates and it is prudent for every investor or potential investor to know the differences between interest ...

### The FVSCHEDULE Excel Function

We have already seen how to use the FV (Future Value) function to calculate the future value of an investment with a constant or fixed interest rate, ...

### How to Use the Excel MIRR Function

We have already seen how to use the IRR (Internal Rate of Return) Function in a previous tutorial. The IRR Function is used to calculate the internal ...

### XIRR vs IRR – How to Calculate IRR and XIRR in Excel

The IRR (Internal Rate of Return) function is used to calculate the internal rate of return for a series, of given periodic cash flows. These cash ...

### Calculating the Rate an Investment Achieves Using the RRI Function

We have already seen how to use the PV Function, the FV Function, and the PDURATION Function in a previous tutorial. We have also seen how to ...

### Excel Financial Function Tips – NPV vs XNPV

In this tutorial, you will learn how to calculate the net present value using Excel's NPV and XNPV Functions. The NPV (Net Present Value) Function ... 