Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Bond Price Calculator Excel

How to Calculate Duration of a Bond in Excel (2 Examples)

Microsoft Excel is a powerful program. In addition to this, it is quite easy and handy to operate. Also, productivity and utilization are increasing ...

How to Create Convertible Bond Pricing Model 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. I will show ...

How to Perform Floating Rate Bond Valuation in Excel (2 Cases)

In this article, we will learn to perform floating rate bond valuation in Excel. The floating rate bond pays coupons that vary over their maturity. ...

How to Calculate YTM of a Bond in Excel (4 Suitable Methods)

Every company needs to buy or sell bonds for its financial activities. For these activities, every company needs to calculate Yield to Maturity (YTM) ...

How to Make Treasury Bond Calculator in Excel (2 Easy Ways)

In Excel, we often need to make Treasury Bond Calculator to calculate the Yield to Maturity and the Bond Price of the treasury bond. By definition, a ...

Preparing Bond Amortization Schedule in Excel (with Easy Steps)

We can perform various finance related tasks in Microsoft Excel very easily. In this article, you will learn about how to prepare a bond amortization ...

How to Calculate the Issue Price of a Bond in Excel

This tutorial will demonstrate how to calculate the issue price of a bond in excel. In Microsoft Excel, you can easily calculate the present value of ...

How to Calculate Present Value of a Bond in Excel (3 Easy Ways)

In Microsoft Excel, you can easily calculate the present value of a bond. Basically, Excel provides you with several ways to calculate the present ...

How to Calculate Bond Price with Negative Yield in Excel (2 Easy Ways)

People need to calculate the Bond Price considering the future value of the Bond. Some of the Bonds have the risk of having a Negative Yield. If you ...

How to Calculate Price of a Semi Annual Coupon Bond in Excel (2 Ways)

If you are looking for some special tricks to calculate the price of a semi-annual coupon bond in Excel, you've come to the right place. There are ...

How to Calculate Clean Price of a Bond in Excel (3 Easy Ways)

Generally, on financial news sites, the clean price of a bond is the quoted price. The price doesn’t include accrued interest. The clean price is ...

Zero Coupon Bond Price Calculator Excel (5 Suitable Examples)

If you are looking for zero coupon bond price calculator in Excel, this article is for you. Here, we will demonstrate to you 5 simple, easy, and ...

How to Calculate Face Value of a Bond in Excel (3 Easy Ways)

Looking for ways to calculate the face value of a bond in Excel? Then this is the right article for you. We will show you 3 different formulas to ...

How to Calculate Bond Payments in Excel (2 Easy Methods)

Looking for ways to know how to calculate bond payments in Excel? Then, this is the right place for you. Here, you will find 2 different step-by-step ...

Calculate Bond Price from Yield in Excel (3 Easy Ways)

Bond yield is the rate of return of an investment made to purchase a bond. The ratio between the Coupon/Interest Payment and the Bond Price is ...

ExcelDemy
Logo