Calculate Risk And Return Of A 3-Asset Portfolio In Excel (Expected Return And Standard Deviation)

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 ธ.ค. 2024

ความคิดเห็น • 9

  • @LAA2198
    @LAA2198 2 หลายเดือนก่อน

    your video does a better job explaining than my professor.

    • @theexcelhub
      @theexcelhub  2 หลายเดือนก่อน

      Thank you very much!

  • @JSquiff
    @JSquiff 2 ปีที่แล้ว

    I'm doing my MSc in Finance and this channel has been incredible for helping me utilise what I have learned practically and enforces what is contained in the course materials. Truly a youtube gem!

    • @theexcelhub
      @theexcelhub  2 ปีที่แล้ว +1

      That really means a lot Josh! Thank you and all the best with your Masters!

  • @budimanyang9248
    @budimanyang9248 2 ปีที่แล้ว +3

    Is the right table presenting variance or std deviation? since the formula for the portfolio risk is std deviation power 2, but in your calculation you didn't power 2 the std deviation.

    • @TheVoiceDVUzbekistan
      @TheVoiceDVUzbekistan 5 หลายเดือนก่อน

      I was also confused, but author haven't answered yet

    • @chuntochu5441
      @chuntochu5441 หลายเดือนก่อน

      Actually the table is called the Covariance table, but you just use sigma symbol to represent. It is a bit misleading, if the sigma table represents the Covariance Matrix, then the formula itself in the excel for calculating the S.D. for the portfolio does not need to "Power" to 2 for stock A, stock B and stock C itself. Please clarify further a bit for it.

  • @Itoquios
    @Itoquios 2 ปีที่แล้ว

    This was very helpful. 1 question: what were the weights associated with the variance/covariance matrix? Thank you :)

  • @mehdiiaryaiii
    @mehdiiaryaiii 2 ปีที่แล้ว

    🔥👌🏻