Calculating the Yield of a Coupon Bond using Excel

[@opelomakoba6783]

Nice, but i wish you could manually solve it. excel and financial calculators are not allowed in exam rooms at my school.

[@mwansachikoti3187]

+Opelo Makoba thank u

[@SwannGrl713]

As I live in a world where both excel and financial calculators are not only allowed, but encouraged, I found this very helpful. Thanks.

[@Edspira]

Happy to help!

[@MrWizzball]

too bad FINRA and NASAA won't allow you to use a financial calculator or excel in the exam

[@fierce10]

It's stupid to not allow financial calculators. Someone send the exam organizers this Ted talk: www.ted.com/talks/conrad_wolfram_teaching_kids_real_math_with_computers 106 human lifetimes of effort is wasted per day by students trying to do shit by hand that shouldn't be done by hand because educators don't get it.

[@lifeskillz9393]

I like the way you present it! Very easy to understand like your other videos. What are you using to present it? The different colours help a lot. Keep up the good work!

[@mayadaelnehrawy3044]

I heard there is an equation for solving it to calculate the YTM

[@nufcfromsg]

Calculate the convexity for a three-year 3.5% coupon rate with a face value of $500,000 loan with amortised payments? How do I do this exact question in excel or on paper?

[@benberdejo7157]

No sense to learn an Excel Formula... thanks for the effort

[@amjadmwaffaq5062]

2020 still helpful and saved my life. thanks a lot :)

[@YunamiOfficial]

I tried to use this formula and the excel didn't provide me the result, saying its wrong, (the formula)

[@reynardyonatan5521]

how to solve this manually?

[@hannichan2573]

Best vid ever.. Thank you

[@Edspira]

Thanks Hanni Chan! I have 8 videos on valuing stocks and bonds if you'd like to learn more: edspira.com/lessons/valuing-stocks-bonds Thanks for watching!

[@nasiruhamisu7673]

amortize the interest expense of a 10% 2-year bonds payable with a par value of 3,200 and quarterly payments, in return for cash of 3,081.52representing a market rate of 7%. Please, help me with its solution.

[@postusinterruptus]

This is very helpful. Thank you.

[@templecharas]

do u have to hold the bond till maturity to get the YTM?what if u decide to sell before maturity date?

[@kaydeeamundson3534]

I have a question so I have some homework, but I have no idea what the par value of this bond would be the question is PK software has 8.3 percent coupon bonds on the market with 22 years to maturity. The bonds make semiannual payments and currently sell for 110% percent of the par. I don’t know how to figure out the par of 110% and also nice video by the way!

[@khanhphamgia1276]

It means the selling price is 110%, or 1.1 times the par value of the bond, and it is the number on the left side of the formula mentioned in the explanation

[@matinajazmine]

I still dont get it.so is interest rate and discount rate same or?

[@mitchrijkaard6757]

Hey, I have a question; why is the price of the bond 92,227 if the face value is 100,00? Might be a stupid question. Thank you.

[@sankha252838]

The bond in given example in trading at discount... Probably because Fed has hiked the interest rate after the launch of this bond.. So, it's price decreased

[@Tigeressss0051]

cant we use a formula by hand or something I cant use excel in my exam

[@haniahm.pamanay4871]

we're not allowed to used excel in our exam, i hope you showed un the calculation by hand :(

[@arieskatkov467]

great video

[@Wfgjfesy]

okay i know "100000" is correct but why the last number in the formula is not "100000+4000"? :(((

[@Wfgjfesy]

i mean in the excel RATE formula

[@arieskatkov467]

you should have more subs

[@kevinwatts6120]

looooool guy cops out and uses excel. waste my time bro

[@gabrielm6422]

For real😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂

[@sakibhossainkhan1173]

Please keep the background color white or other but not black

[@arieskatkov467]

no keep it black

[@saimatasnim5054]

need to improve