How to get yield to maturity (YTM) with Excel

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.

Tim Ord
Ord Oracle

Tim Ord is a technical analyst and expert in the theories of chart analysis using price, volume, and a host of proprietary indicators as a guide...

Tradingsim.com
Day Trading Simulator

Tradingsim.com provides the ability to simulate day trading 24 hours a day from anywhere in the world. TradingSim provides tick by tick data for...

Send this article to a friend.

Enter multiple addresses on separate lines or separate them with commas.