VAR calculation in EXCEL | Learn Financial Modeling | Step by Step | Session 18
In this FULL COURSE session on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know about VALUE AT RISK (VAR) in FINANCIAL MODELLING as a BEGINNER. It covers everything end to end. By the end of these sessions, you will feel confident about performing VAR modeling independently without any help.
Like our previous session in FULL COURSE on FINANCIAL MODELLING for BEGINNERS, it also breakdown everything in STEP BY STEP manner using LIVE PROJECT or EXERCISE file so you can PRACTICE it while watching this session (link below).
📥 Download Template - drive.google.com/drive/folder...
📌SUBSCRIBE NEWSLETTER - cutt.ly/gw2ozQbj
📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp channel (TVS Mentoring) - whatsapp.com/channel/0029VaLf...
--------------------------
👉JOIN:
🔥REGISTRATION LINKEDIN COHORT : cutt.ly/ieeOXuwl
🔥REGISTRATION EQUITY RESEARCH COHORT Latest Batch: cutt.ly/4wSDnDLA
📛 Please refer to this video for all the Details of the Cohort:
• Equity Research cohort... !
✅ For queries, please reach to us on our Instagram handle: / thevaluationschool or DM us on WhatsApp - +91 9302017656
👉Register here for our latest Advanced Valuations and Financial Modelling Cohort
🔥 AVFM LIVE - cutt.ly/rwXYEN2A
🔥 AVFM RECORDED - cutt.ly/VwXYW7Xp
--------------------------
✅ You can Connect with Parth Sir on Linkedin - linkedin.openinapp.co/097ag
✅Follow The Valuation School page on Linkedin - / thevaluationschool
✅Join our Instagram handle - / thevaluationschool
Пікірлер: 145
@The Valuation School sir , as you said that the VAR is determined to see the loss with a probability but the three scenarios when you are calculating the share price after taking consideration the current share price and VAR parcentage the hypothical share prices are gone up. IT seems that you have add the VAR percentage factor rather than substract, because as the VAR percentage is in negative when you substract it from 1 , minus minus gets plus and after multiplication with current share price the hypothical share price is gone up. If I am wrong please rectify me. One thing I must say the series is superb 🙏
@nileshdas9820
8 ай бұрын
i have the same doubt
Words cannot express my deep gratitude for the exceptional guidance and unwavering support provided by you Sir
Love you so much parth sir, I always wanted someone to teach finance like you do and you came like an angel into my life.... When I will be capable I will join your each and every cohort
Sir, I truly would like to appreciate the way you expalined and taught the tips & tricks please keep doing this noble cause.
Great one!! I was always curious to learn about Monte Carlo Simulation and finally learned from the Great Mentor itself.
sir, your energy and passion is infectious..so grateful for your selfless efforts..🥰🥰
You are really shower of knowledge I finished one you come with new one. Really great applause 👏 for your effort.
completely agree that persistent effort leads to progress. Thank you for reminding me of this important principle.
I am very greatful for that i have found mentor like you sir, i am watching this series and preparing model alongwith it. i feel like i can go on and on about and will never tire to watch sessions like this. thank you for Spreading Knowledge like this to everyone.
Super Content! I was waiting for such channels who can share authentic and detailed content. Valuation School is the ultimate destination for finance aspire folk
Amazing content. I still can't believe its on youtube and available for free !! Genuinely unbelievable
Much grateful to you Sir for taking this initiative. I rarely comment on social media platform but your efforts pushed me to write. Though I have not reached here but commenting on latest post so it reach to you Sir. May your channel grow faster and faster sir. Thank you so much.
Great content delivered as always 🙏☺️
I have no words to say THANK YOU. You are the best
Great content as always. Thank you so much 👍
Thank you so Much Sir!❤ Laate jaao Aise Practice videos
Thank you we are lucky to have a teacher like you
Dear Sir, really you are doing amazing job, keep up the good work..
Sir bhut maza aa raha hai aap plz aise hi aur informative videos banayein.
Excellent content Parth Bhaiyya !!
Sirr aapka ye series mast yahi jari rakho❤❤❤❤
Great learning from you Looking for more More power to you😇
The only one who teaches absolute practically thank you ss much sir
Sir paanch dosto ko toh bta diya already! Wishing you all the best!
Great video, thanks for sharing!!
Thank you for sharing such knowledge lessons ☺️
Such high quality content❤
Thank you soo much, you are the best🙏🙏🙏🙏🙏
Sir Thank You So Much, Recording Video Watching Is looking Like you are live And Real-time Your Talking to me < Thank you so much Sir .
Huge respect sir.....
Great content delivered as always
BEST TEACHER OF ALL TIME
Loving your videos sir, Suggestions and request for next videos : Breakeven Analysis & Budget vs Actuals
Thank you so much sir for such a good content..
superb explanation -
Sir You Are Great ❤🔥
Awesome explanation sir
Great mentor ❤
Great Work sir, please keep helping us
Great content ❤
thanku sir so much
Valuation aur modelling ka aur video chahiye, He is like god for us.
great content keep it up god bless you
Thank you sir!
Amazing video
Wonderful session
Valuable content sir
Sir Literally I can not express my gratitude 🙏 to you in words. You are amazing😇 sir and made financial modelling a cake walk🤩 I don't want you to end these series. Thankyou once again Sir for providing such a quality of content we value your efforts sir 🙌👏
Great Work Sir
very insightful content sir after every video me like " maja aa gaya"
Thank you so much! I already have recommended more than 5 people as they had reached out to me on LinkedIn and will continue to do so!
It was really a great session
Sir your conrent is really helpful thank you
You are the king of all time
thanks you sir for everything
best content ever
Thank you so much sir for giving valuable & practical knowledge to all the students. I just have one small question regarding the calculation of VAR. The current market price of Tata Elxsi was around 7115 and when we say we are 95% confident that on daily basis we will lose INR 322/- then as per my understanding the stock price should decreased from the levels of current market price but in the calculation of stock price, it has increased. Please clarify on it.
@pranayjain._
4 ай бұрын
Exactly! His concepts are not clear. Seems like he has just mugged up without logic of any sorts.
Thank you sir 😄
Thank you sir ji❤
Thank you so much sir ❤
hello sir first of all thank you very much for everything and this FM series is Gold mine .. no one puts so much efforts that too free and value driven content. I also follow on linkedin aur 5 nhi 10 dosto ko bola hai about this channel . .. just one thing we want to know 1) after which session number we can add Financial Modelling in our resume and how long to complete this entire series that u r bringing .. I personally like it but interview me which is scheduled in 2 days , they will certainly be asking as to how long will it take for u complete the course ..
really great, please also start a series on fixed income securities
Thanks A Lots🙏🙏🙏
Parth sir awesome video
❤ My Mentor forever ❤️
THNK U SO MCH SIR
great content
Thank You Sir
Thank you Sir
Amazing
Thankyou sir ❤❤❤❤❤
thank uuuu🥰😇😍
Thankyou
Sir I did liked, commented and subscribed your channel, like you said ♥
very nice🙂
Good sir
Great
besttttt💯💯💯💯
Nice video
Hello sir, I'm creating my second financial model because of you so THANKS!! Just a lil question... Is it possible that the reinvestment rate of a Banking institution gets higher than 100% for 4 consecutive years ?
Sir plz bring video on debt schedule, depreciation schedule.
Sir Future Stock price me CMP*(1+VAR) hoga kya?? Because VAR is already negetive to 1+ VAR to positive ho jaega na?? Genuine Doubt
confidenceeee
Hat's off sir sfm Mai yetna deep nahi samja aaja aapne pura Cristal clear Kiya..
Guru Dronacharya ❤🙏😁
Nice, can you create same for a portfolio
❤❤
Please make vdo for stress testing
💥
I will upload it tomorrow on Linkedin😝
Hi Parth sir, Why we are calculating returns by (current-next day)/next day price, instead we should calculate it by (Next/current)-1 and current should be blank
Hi, I want to calculate the VaR for the GSec Portfolio? any vedio on that pls?
Maja aa rha h sir 😂
❤️
sir ji aur video cahiye financial modeling ka
Thank you so much Parth bhai for wonderful learning! 17:08 pe humei 1+Var% nahi krna chahiye, so that we have the right price and then VAR ka bhi change ho jayega>> 7115 see kam hona chahiye, toh sahi report aayegi, Var INR theek hai but Price and formula nahi?
Sir, Today I have enrolled for Advance Valuation and FM Live classes which are going to start on 29.05.23. See you in the class sir....
Hi pruthvi sir . Do u have recorded financial modeling course ??? & pdf notes also . Do u have learning app for it??
Hi sir Which version of excel you are using???
Can we use these Modeling in Derivatives also like Nifty Banknifty?