Ric Thomas
Ric Thomas
  • Видео 24
  • Просмотров 192 478
Dividend Discount Models Made Easy!
Here is a brief tutorial covering the basic calculations in dividend discount models. This video is very helpful for students in intro finance classes and covers typical DDM exam questions.
Просмотров: 31

Видео

How to Calculate Forward Rates from Spot Rates
Просмотров 1943 месяца назад
This short video shows you an easy and intuitive way of calculating and thinking about forward rates, using a spot rate yield curve.
Calculating Bond Duration - Easy in Excel !!!
Просмотров 2173 месяца назад
This video gives a brief overview of bond duration - what is it, how it is used, and how to calculate it. I do both a bottom's-up method in Excel, and then show how you can use built-in excel functions to calculate it.
Triangle Arbitrage - Currency Trading
Просмотров 1466 месяцев назад
This short video shows how Triangle Arbitrage works with a simple example. This will be very useful for students in Multinational or International Finance classes.
How to use a Financial Calculator to Calculate Bond Prices and Bond Yields
Просмотров 3378 месяцев назад
This short video demonstrates how to calculate bond prices and bond yields using a Texas Instrument BA II Plus financial calculator. Very easy!
Calculate performance ratios in Excel! Sharpe, Sortino, Treynor, and Information Ratio!
Просмотров 4,8 тыс.Год назад
This video shows how to calculate the key portfolio performance ratios in Excel.
How to Calculate Bond Prices and Bond Yields using Excel!
Просмотров 4,3 тыс.Год назад
This short video walks you through how to calculate bond prices, if given the yield, and how to calculate the yield-to-maturity, if given the bond price. Very simple!
Screening and Finding Stocks Made Easy!
Просмотров 165Год назад
This short video shows you how to use Yahoo Finance! to easily narrow down a stock universe. You can screen on various favorable attributes that you favor to get the number of potential buys down to a workable number. This is a great tool for students looking to buy stocks in an investment class. Even stock pros can use this simple tool. It's easy!
How to Calculate Portfolio Tracking Error in Excel!
Просмотров 8 тыс.Год назад
This short video shows you how to both calculate and interpret portfolio tracking error. We do all of our work here in Excel. It's pretty easy!
Elon Musk's Hostile Takeover of Twitter Explained!
Просмотров 1802 года назад
This video updates the status of the Musk bid for Twitter as of April 16, 2022. I cover the offer, compare it to a friendly takeover, discuss the Poison Pill, the potential White Knight scenario, and the most likely next steps.
How to Make a Chart in Excel in 1 Easy Step!
Просмотров 2052 года назад
This short video shows a quick trick for how you can easily make a chart in Excel. This simple trick greatly simplifies the process!
Covered Interest Arbitrage Made Easy!!!
Просмотров 2,1 тыс.2 года назад
This short video demonstrates how Covered Interest Arbitrage works. Students in an international finance course, focusing on currencies and interest rates should find this very helpful.
Interest Rate Parity Made Easy!
Просмотров 15 тыс.2 года назад
This short video shows how forward currency rates are aligned with the differences in interest rates - creating "Interest Rate Parity". This shows how to calculate currency forward rates based on interest rates and gives a bonus real-world example using Euros vs. Dollars.
DCF Analysis Part 4: Final Valuation - and Sensitivity Analysis!
Просмотров 3,9 тыс.2 года назад
This video shows you a simple way to estimate a company's stock price, by discounting back projected cash flows over the horizon period and estimating a terminal value. I also show how to put together a cool table that can do sensitivity analysis (tweaking the WACC and the terminal growth rate).
Portfolio Performance Attribution: The Brinson-Fachler Model
Просмотров 10 тыс.2 года назад
This video demonstrates how to do performance attribution using the Brinson-Fachler model. This is one of the more popular methods for performance attribution in the investment management industry.
Discounted Cash Flow Analysis Part 3 - Forecasting Free Cash Flow
Просмотров 2,9 тыс.2 года назад
Discounted Cash Flow Analysis Part 3 - Forecasting Free Cash Flow
Discounted Cash Flow Analysis Part 2 - Weighted Average Cost of Capital (WACC): Live Example!
Просмотров 1,5 тыс.2 года назад
Discounted Cash Flow Analysis Part 2 - Weighted Average Cost of Capital (WACC): Live Example!
Discounted Cash Flow Analysis Part 1 - Patrick Mahomes' Salary
Просмотров 1,2 тыс.2 года назад
Discounted Cash Flow Analysis Part 1 - Patrick Mahomes' Salary
Estimating Jensen's Alpha
Просмотров 5 тыс.2 года назад
Estimating Jensen's Alpha
How to Download Company Financial Statements For Free!
Просмотров 18 тыс.2 года назад
How to Download Company Financial Statements For Free!
How to Run a Regression in Excel
Просмотров 3622 года назад
How to Run a Regression in Excel
Portfolio Optimization in Excel Using Solver
Просмотров 24 тыс.2 года назад
Portfolio Optimization in Excel Using Solver
How to create a Variance Covariance Matrix in Excel
Просмотров 48 тыс.2 года назад
How to create a Variance Covariance Matrix in Excel
How to Use a Financial Calculator
Просмотров 42 тыс.3 года назад
How to Use a Financial Calculator

Комментарии

  • @ohangkana1809
    @ohangkana1809 20 часов назад

    It is very helpful. Thank you! How do you calculate the price of bonds, if you do not have Yield to Maturity? The question only has "Face Value", "Maturity" and "Coupon". Find the prices for the following coupon bonds : • Face value: $100 Maturity Coupon Bond A 3 1.75% Bond B 7 2.875% Bond C 10 3.250%

  • @avs__1702
    @avs__1702 21 день назад

    Hi Ric - when calculating the beta, why aren’t you using the excess returns above the risk-free rate for the portfolio and the benchmark as your inputs? Is it okay to just use the returns of those inputs without first calculating the excess returns?

    • @ricthomas6436
      @ricthomas6436 20 дней назад

      Hi, the stock's beta is first estimated using the market index model, which simply regresses the stock return (or asset return) against the market index. It is true that the CAPM subtracts the risk free rate from the market expected return, then multiplies this by beta and adds in the risk free rate. However, the beta itself is estimated by directly regressing the asset return against the market return. Even if you did subtract the risk free rate, you'd get a similar beta estimate, however. I hope this helps. Thank you.

    • @avs__1702
      @avs__1702 20 дней назад

      @@ricthomas6436Thanks Ric! So when calculating beta, I would regress the asset itself against the market return. Although not covered in this video, when calculating alpha, would I use the CAPM method of subtracting the risk-free rate from the market return and benchmark return before regressing the market return against the benchmark return? I’m struggling to distinguish when to subtract the risk-free rate from the market return and benchmark return and when not to. I’ve seen videos where they subtract the risk-free rate to calculate both beta and alpha other videos where they don’t. Thanks again for the help!

    • @ricthomas6436
      @ricthomas6436 18 дней назад

      @@avs__1702 Yes, in this case you regress the return of the asset - risk free rate against the return of the market - risk free rate. You are testing to see if, assuming we live in a CAPM world, the alpha (constant term) is different than zero. Assuming we live in CAPM world, and the market is efficient, the constant term should be 0. I do have a video on my channel that covers this as well. But in this case, the reason that you are regressing against the market - risk free, is that you are now testing to see if the CAPM holds, if the asset has "alpha", and if the market is efficient. Hope this helps. RT

  • @ashishp520
    @ashishp520 Месяц назад

    Thanks, very informative

  • @yashjain8200
    @yashjain8200 Месяц назад

    You're the best man. Just needed the exact thing for my assignment :)))))))

  • @abedadra533
    @abedadra533 2 месяца назад

    What i dont get is why the jpy is at a premium in the long term if they offer lower interest

  • @moshintayub4112
    @moshintayub4112 2 месяца назад

    So helpful and well-explained!

  • @Zangar-ft2fc
    @Zangar-ft2fc 2 месяца назад

    Thank you habibi from me, Sikandar, Berna, Azamon, Nisanur 💌

  • @andreaardemagni6401
    @andreaardemagni6401 2 месяца назад

    I think you got the financial interaction wrong. It’s -7 - (-4) …

    • @ricthomas6436
      @ricthomas6436 2 месяца назад

      You are correct. Actually, I just typed it in wrong, but the math was correct. As you point out, its -7% - -4% = -3%. Then when we multiply by the 11% underweight, we get the 33 bps. that is shown, which is correct. But my bad on on typing this in incorrectly, and good catch. Thank you.

  • @AjayYadav-kg3cc
    @AjayYadav-kg3cc 2 месяца назад

    super Thomas

  • @sailedship6530
    @sailedship6530 2 месяца назад

    Thanks for the great share . Would save users time by explaining the basics early on. The µ divided by σ in first table D col is difficult to tell at first so one can follow along. was wondering what that 0.23 for as you went over the first two cols but not that one. It took me up to 5:02 to figure out it's the ratio of weighted average. Hope it helps someone...

  • @Persian5life
    @Persian5life 2 месяца назад

    Ric please please please start a course in Udemy that summarizes all of your videos and starts from scratch. there are no videos on Udemy on Portfolio analysis like this. If anyone knows any course that does this in Excel please let me know.

    • @ricthomas6436
      @ricthomas6436 2 месяца назад

      Thank you, I can look into that. Regards, RT

  • @jjbammomm451
    @jjbammomm451 2 месяца назад

    Please do fixed income attribution and factor risk attribution

  • @jc_777
    @jc_777 3 месяца назад

    Many thanks. Wow Excel is so stupid that you have to manually copy paste the upper triangle in the end.

  • @rutwikantre7092
    @rutwikantre7092 3 месяца назад

    Thank you so much Mr Thomas, can't express how useful your practical examples were for me !! Keep going, God Bless You

  • @tuongmy3796
    @tuongmy3796 3 месяца назад

    can u help me graph efficient frontier constructed from the index model and the full covariance matrix ?

  • @tuongmy3796
    @tuongmy3796 3 месяца назад

    can u help me graph efficient frontier constructed from the index model and the full covariance matrix ?

  • @user-yj6jv8ef1x
    @user-yj6jv8ef1x 3 месяца назад

    Thank you! That was really helpful!

  • @allykolesnik5222
    @allykolesnik5222 3 месяца назад

    How would I go about using solver to find optimal weights for a portfolio with a specific return, say 2%?

    • @ricthomas6436
      @ricthomas6436 3 месяца назад

      In that case, you would open solver, at the top you want to MINIMIZE volatility, and then one of the constraints would be that the solved return would equal 2 percent. This is similar to the video where I am MAXIMIZING return, and constraining volatility to be a fixed level (like 6 percent).

  • @shawn8847
    @shawn8847 4 месяца назад

    Great work Ric. Thanks again for the Wisconsin leads. Moving soon!

  • @tawalters35
    @tawalters35 4 месяца назад

    Ric, many thanks for the detailed explanations. I am trying to measure performance of my accounts as if they were hedge funds. I would love to have a copy of your spreadsheet to use your data sets in my spreadsheet to assure the numbers tie out. I'll send you a copy of my spreadsheet report format when done. (Sort of like turning in my homework.) Any chance I could download a copy?

  • @supersaverguyful
    @supersaverguyful 5 месяцев назад

    how does the Yen get stronger when the US has higher interest rates and in theory creates a stronger currency as we've seen over the last year???? it seems like the equation should be 1.02/1.01 *150 = 151.49

    • @ricthomas6436
      @ricthomas6436 5 месяцев назад

      The forward yen rate will trade at a premium to the spot yen rate when the US has higher interest rates. However, what you say is true in the sense that, over time, the yen spot may continue to depreciate in the face of higher rates. But even so the yen forward will continue to trade at a premium to the yen spot. Both can be true. In fact, one of the reasons the yen has depreciated is that many traders borrow yen (due to its low rates) and invest in dollars (due to the higher rates). This is the yen-carry trade and is what we’d call “uncovered” interest rate arbitrage.

    • @ricthomas6436
      @ricthomas6436 5 месяцев назад

      In the second sentence above, my comment should read “… in the face of higher US interest rates.”

  • @jacobfoster6639
    @jacobfoster6639 5 месяцев назад

    Thank you Ric. I’ve been searching for the past hour and glad I came across your video. Everything I needed. Cheers!

  • @alexvir9986
    @alexvir9986 5 месяцев назад

    I had never heard about this method of Arbitrage, it's so interesting!

  • @namelessbecky
    @namelessbecky 6 месяцев назад

    thanks

  • @marcoboldini7180
    @marcoboldini7180 6 месяцев назад

    Mr Thomas, I cannot thank you enough for this free content! You're helping a lot of students and early professionals globally! Thank you

  • @VipulMehta817
    @VipulMehta817 6 месяцев назад

    Hello, this is very explanative. Thanks. Can you also make a video on computing up capture and down capture vs benchmark for this fund over the same time horizon?

  • @danielcsanadi
    @danielcsanadi 6 месяцев назад

    thanks man, it was very helpful to my project!

  • @sophy_262
    @sophy_262 6 месяцев назад

    Hi sir how u calculate the yen can grow to 108070000 divide or what

  • @geoffreyg5659
    @geoffreyg5659 6 месяцев назад

    Hello, why do you calculate the performance ratio with the portfolio return of the last month instead to use the mean of each month of the portfolio return? i saw 2 manners to calculate the performance ratio but the result is not the same... i don't really get it

  • @user-ju6pq4yi9m
    @user-ju6pq4yi9m 7 месяцев назад

    This is fantastic. Great education. Easy to follow. I added all of these performance ratios to my own spreadsheet in Google Sheets to evaluate our investments. It would've taken me a LOT longer without this. Thank you very, very much.

  • @user-nm8dw5qr2v
    @user-nm8dw5qr2v 7 месяцев назад

    Thank you Sir, this was really so helpful, greetings from Yerevan, Armenia 🇦🇲

  • @zahidislam9829
    @zahidislam9829 7 месяцев назад

    can u giv the file?

  • @boredonatuesday8793
    @boredonatuesday8793 7 месяцев назад

    This was good. Thank you

  • @kamranashraf3921
    @kamranashraf3921 7 месяцев назад

    Wonderful Explanation ♥️

  • @farrahday_allday
    @farrahday_allday 8 месяцев назад

    Great video! Thank you for helping me understand this better.

  • @ttb2905
    @ttb2905 8 месяцев назад

    Y is he using the words discount rate and interest rate interchangeably

  • @rodrigoaeng6635
    @rodrigoaeng6635 8 месяцев назад

    This is a great video thank you!

  • @eoeo1382
    @eoeo1382 8 месяцев назад

    thank you, your explanation really helped me

  • @z93g43
    @z93g43 9 месяцев назад

    why do we use benchmark and not portfolio weights for selection effect?

  • @user-bc3ny1fu9x
    @user-bc3ny1fu9x 9 месяцев назад

    If I want to get the annualized tracking error from weekly excess return, should I multiply by sqrt(52)?

    • @ricthomas6436
      @ricthomas6436 5 месяцев назад

      Yes. And if you use daily returns, multiply by sqrt of (252) since that is approximately the number of trading days in a year.

  • @yevgeniykats6410
    @yevgeniykats6410 9 месяцев назад

    Thank you very much! Excellent tutorial!

  • @Quanthc5574
    @Quanthc5574 9 месяцев назад

    it's so well explained, thank you, that help me a lot!!!

  • @yvettecheng8516
    @yvettecheng8516 9 месяцев назад

    Very useful, thanks

  • @pankidan
    @pankidan 9 месяцев назад

    Superb ! content !

  • @Ayayron131
    @Ayayron131 10 месяцев назад

    my grad school finance management professor hasnt taught anything/been away for 4 weeks so far. just using a textbook. this helped greatly because... doing these by hand i could not figure out for the life of me

  • @laurazhang509
    @laurazhang509 10 месяцев назад

    Great video! Thank you so much!

  • @kaibaing4288
    @kaibaing4288 11 месяцев назад

    I have a doubt pertaining to the formula for tracking error Do we take the standard deviation of (the differences obtained between benchmark return & portfolio return) Or Do it as shown in the video I.e (calculate deviation from benchmark return,and use the sum of squares for the same,for TE)?

    • @ricthomas6436
      @ricthomas6436 10 месяцев назад

      Hi @kailbaing4288, excellent question. You can do it either way, as they will give you almost identical answers. In the manual method that I used - I did not subtract the mean excess return. In reality, the mean excess return is going to be a number very close to 0, so the differences between the two methods will be close. Technically, the manual method (where you do not subtract out the mean) is what many authors on the subject recommend when they show the formula. However, in practice you will find that most investment professionals will use an excel stdev function (also shown in the video) which does subtract the mean. In fact, the only reason my two calculations show the same number here is because of rounding. In reality they are (very slightly) different.

  • @AndreasSebastianHealdGon-qw9kq
    @AndreasSebastianHealdGon-qw9kq 11 месяцев назад

    Great video thanks

  • @XristosBlackJack
    @XristosBlackJack 11 месяцев назад

    Thank you Ric, this is appreciated.

  • @user-ic5os5in9o
    @user-ic5os5in9o 11 месяцев назад

    how does this differ from factor analysis of hedge funds? Thanks!