Excel for Finance

Calculate Future Investment Value with Inflation, Tax and Interest Rates

If you want to calculate future investment with inflation and nominal interest rates, then there is an essential article on How to calculate future ...

CAGR Formula in Excel: With Calculator and 7 Examples

In Microsoft Excel, there’s no exact built-in CAGR formula but we have numerous functions associated with the compound interest criteria. In this ...

Compound Interest Formula in Excel: Calculator with All Criteria

In Microsoft Excel, there are built-in functions to calculate future investment values and compound interest. We can also make our own formula by ...

Biweekly mortgage calculator with extra payments [Free Excel Template]

Biweekly mortgage calculator with extra payments "No Macro used. No installation is necessary. Just download and start using." - ...

How to calculate compound interest for recurring deposit in Excel!

In this short tutorial, I will show how to calculate compound interest (maturity value) for recurring deposits in Excel. If you don’t have a ...

Flat and reducing rate of interest calculator in Excel [Free Download]

Flat and reducing rate of interest calculator in Excel "No Macro used. No installation is necessary. Just download and start ...

Mortgage calculator with extra payments and lump sum [Excel Template]

Mortgage calculator with extra payments and lump sum (Free Excel Template) "No Macro used. No installation is necessary. Just ...

How to calculate future value with inflation in Excel

Do you want to know how to calculate the future value of money with inflation in MS Excel? Want to calculate inflation-adjusted return from your ...

Compound interest excel formula with regular deposits

In this tutorial, I will explain how to calculate compound interest using Excel formula with regular and irregular deposits. We shall also ...

Excel amortization schedule with irregular payments (Free Template)

Excel amortization schedule with irregular payments (free Excel template) "No Macro used. No installation is necessary. Just ...

How to calculate yield to maturity in Excel (Free Excel Template)

In this article, I will show how to calculate yield to maturity (YTM) in Excel. YTM is also known as the internal rate of return. I will ...

Effective Interest Rate Formula Excel + Free Calculator

In this article, I will discuss how to use the effective interest formula in Excel (the EFFECT Function). Also discussed topics like: What ...

Effective Interest Method of Amortization Calculator (Free Download)

I made an Excel template that you can use as the effective interest method of amortization calculator. Download the template from the ...

Effective Interest Rate Method Excel Template (Free)

Effective Interest Rate Method Excel Template "No Macro used. No installation is necessary. Just download and start using." - ...

Effective Interest Method of Amortization in Excel

Effective Interest Method of Amortization in Excel (for bonds sold on discount) Effective Interest Method of Amortization in Excel (for bonds ...

ExcelDemy
Logo