Excel for Finance Archives - Page 5 of 6

How to calculate effective interest rate on bonds using Excel

Apr 17, 2022 Excel for Finance 2

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)

Sep 7, 2021 Excel for Finance

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)

Sep 7, 2021 Excel for Finance 2

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)

Sep 7, 2021 Excel for Finance

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)

Sep 15, 2021 Excel for Finance

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)

Jun 5, 2022 Excel for Finance 3

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)

Sep 15, 2021 Excel for Finance 6

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

Sep 13, 2021 Excel for Finance

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

Mar 1, 2022 Excel Books 1

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

Jul 19, 2022 Excel for Finance

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

Mar 3, 2022 Excel for Finance

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

Jun 13, 2022 Excel for Finance 1

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

Mar 3, 2022 Excel for Finance

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

Mar 3, 2022 Excel for Finance

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

Jul 17, 2022 Excel for Finance 2

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