Exceldemy.com Blog

exceldemy.com
An authority site on Microsoft Excel. This site has 300 blog posts and monthly this site gets 30,000 unique visitors.

How To Calculate Yield To Maturity In Excel (with Template)

2018-11-05 09:09
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 calculate YTM in two ways:Using Excel’s RA… Read More

Effective Interest Rate Formula Excel + Free Calculator

2018-11-04 10:22
In this article, I will discuss how to use the effective interest formula in Excel (the EFFECT Function). Also discussed topics like:What is the effective interest rate (EAR)?How to calculat… Read More

2018-11-01 12:09

Effective Interest Rate Method Excel Template (Free)

2018-10-31 13:38
Effective Interest Rate Method Excel Template“No Macro used. No installation is necessary. Just download and start using.” – Kawser Ahmed (Template Developer)Created using… Read More

Effective Interest Method Of Amortization In Excel

2018-10-25 15:38
In this blog post, I will discuss the effective interest method of amortization in Excel. I will cover the method for both types of bonds:Bonds sold on discountAnd bonds sold on premiumEffec… Read More

How To Calculate Effective Interest Rate On Bonds Using Excel

2018-10-16 10:05
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 you know what an effective interest rate is, you ca… Read More

Nominal Interest Rate Formula Excel (calculate From Effective Rate)

2018-10-11 10:34
Except learning the nominal interest formula Excel, we shall also cover several topics in this article.What will you learn from this article?What is the Nominal and Effective Annual Interest… Read More

Mortgage Payoff Calculator With Extra Principal Payment (Excel Template)

2018-07-28 13:31
Mortgage Payment Calculator with Extra Principal Payment“No Macro used. No installation is necessary. Just download and start using.” – Kawser Ahmed (Template Developer)Cre… Read More

Create A Chart From The Selected Range Of Cells (4 Possible Ways)

2018-07-24 06:16
Creating charts is one of the main purposes for which you use Excel. The different kind of charts gives us the visual representation of the data we are working on. In this article, I will sh… Read More

Mortgage Payoff Calculator With Extra Payment (Free Excel Template)

2018-07-19 08:18
Mortgage Payment Calculator with Extra Payment“No Macro used. No installation is necessary. Just download and start using.” – Kawser Ahmed (Template Developer)Created using… Read More

ExcelDemy.com

×