Calculating the Yield of a Coupon Bond using Excel

UPDATE: You can also find the YTM by trial and error. If you plug in 0.06 for the YTM in the equation this gives you $91,575, which is lower than $92,227. YTM = 0.058 gives you $92,376, which is a little bit higher than $92,227. YTM = 0.0585 gives you $92,175, but YTM = 0.0584 gives you $92,215 which is very close to $92,227. Thus, 5.84% is the approximate YTM

This video explains how to calculate the yield-to-maturity of a coupon bond. A comprehensive example is provided that shows the formula for calculating the yield, but the video also provides a Microsoft Excel formula that provides an easier means of determining the yield.—
Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world.
—
SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44-PAGE GUIDE TO U.S. TAXATION
• A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS
• MANY MORE FREE PDF GUIDES AND SPREADSHEETS
http://eepurl.com/dIaa5z
—
SUPPORT EDSPIRA ON PATREON
*  / prof_mclaughlin  
—
GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT
https://edspira.thinkific.com
—
LISTEN TO THE SCHEME PODCAST
Apple Podcasts: https://podcasts.apple.com/us/podcast...
Spotify: https://open.spotify.com/show/4WaNTqV...
Website: https://www.edspira.com/podcast-2/
—
GET TAX TIPS ON TIKTOK
  / prof_mclaughlin  
—
ACCESS INDEX OF VIDEOS
https://www.edspira.com/index
—
CONNECT WITH EDSPIRA
Facebook:   / edspira  
Instagram:   / edspiradotcom  
LinkedIn:   / edspira  
—
CONNECT WITH MICHAEL
Twitter:   / prof_mclaughlin  
LinkedIn:   / prof-michael-mclaughlin  
—
ABOUT EDSPIRA AND ITS CREATOR
https://www.edspira.com/about/
https://michaelmclaughlin.com