Hello.My name is Chandra Shekhar Bhatnagar and I continue to be a student of Finance. For bread and butter, I teach it as well. I am not a finance wizard, but as I have realized, I don't really need to be out of the ordinary to learn financial concepts. Though the episodes in my show are specifically aimed at younger fellow learners but anyone interested in financial calculations can benefit from them.Have fun and be kind enough to point out any errors.
This video demonstrates the use of Excel in implementing the single index model
The discussion is focused not only on the return, variance and covariance but also on how the single index model may be easier to implement compared to the full covariance model. In conclusion, a few caveats have been discussed.
This video demonstrates the use of Excel Solver to arrive at optimum portfolio weights that minimize portfolio risk subject to achieving a desired return
This video demonstrates the use of Excel Solver to arrive at portfolio weights that maximize the Sharpe Ratio
This video demonstrates the use of Excel to arrive at optimum portfolio weights that maximize the Sharpe Ratio.
This video derives optimal portfolio weights that maximize the Sharpe ratio for an n-asset portfolio, using matrices and matrix differentiation
This video is dedicated to maximizing the overall performance of a 2-asset portfolio by deriving optimum portfolio weights that maximize the Sharpe ratio.
This video discusses and explains the derivation of optimum portfolio weights for a 2-asset portfolio for minimizing portfolio risk
This video looks at two formulas for computing variance of returns for a 2 asset portfolio and shows that both are same.
This brief video demonstrates the computation of portfolio return and variance of a 2-asset portfolio in Excel