Get real, active and permanent YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

Calculating the Yield of a Coupon Bond using Excel

Follow
Edspira

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 yieldtomaturity 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 awardwinning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a highquality business education freely available to the world.

SUBSCRIBE FOR A FREE 53PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44PAGE GUIDE TO U.S. TAXATION
• A 75PAGE 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 ASSETLIABILITY 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/podcast2/

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:   / profmichaelmclaughlin  

ABOUT EDSPIRA AND ITS CREATOR
* https://www.edspira.com/about/
* https://michaelmclaughlin.com

posted by NeefWemiwerian6