How to get yield to maturity (YTM) with Excel

Bonds
Day Trading
Forex
Fundamental Analysis
Futures
Options
Personal Finance
Stocks
Technical Analysis

Yield to maturity (YTM, yield) is the bond's internal rate of return (IRR). It is the rate that discounts future cash flows to the current market price. The speaker provides the formula for YTM and also explains how to calculate this value for a bond in Microsoft Excel and the Texas Instruments calculator.

The calculate YTM in Excel, you will need to input the par value, market value, term to maturity, and coupon rate. Once you have these values, he will explain how to prepare them for use in Excel's internal YTM function.