About this document
Yield to Maturity Calculation in Excel by Pranoy Sarkar is a document available to read on EtoBox.
The document provides instructions on how to calculate yield to maturity for bonds using given information such as market price, coupon rate, issue price, and bond term. It includes an example calculation of yield to maturity of 14.19% for a bond with a market price of $95, 6 year term, 13% coupon rate, and $100 issue price. A second example is given for calculating post-tax yield to maturity of 9.08% for a bond with a 5 year term, 9% coupon rate, $90 issue price, $105 redemption value, and tax rates of 30%
- Author
- Pranoy Sarkar
- Language
- EN