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

  • @SUBHOMOY16
    @SUBHOMOY1611 ай бұрын

    @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

    @nileshdas9820

    8 ай бұрын

    i have the same doubt

  • @Harsh10111
    @Harsh10111 Жыл бұрын

    Words cannot express my deep gratitude for the exceptional guidance and unwavering support provided by you Sir

  • @dhruvkanabar1
    @dhruvkanabar1 Жыл бұрын

    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

  • @kiransumera6040
    @kiransumera604010 ай бұрын

    Sir, I truly would like to appreciate the way you expalined and taught the tips & tricks please keep doing this noble cause.

  • @shwetanksinha1142
    @shwetanksinha11429 ай бұрын

    Great one!! I was always curious to learn about Monte Carlo Simulation and finally learned from the Great Mentor itself.

  • @ektabhatt13
    @ektabhatt13 Жыл бұрын

    sir, your energy and passion is infectious..so grateful for your selfless efforts..🥰🥰

  • @govindgoel2442
    @govindgoel2442 Жыл бұрын

    You are really shower of knowledge I finished one you come with new one. Really great applause 👏 for your effort.

  • @sethbrown1616
    @sethbrown16168 ай бұрын

    completely agree that persistent effort leads to progress. Thank you for reminding me of this important principle.

  • @devangdarji5686
    @devangdarji56866 ай бұрын

    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.

  • @priyankakaria4232
    @priyankakaria423217 күн бұрын

    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

  • @Krish-zu7um
    @Krish-zu7um5 ай бұрын

    Amazing content. I still can't believe its on youtube and available for free !! Genuinely unbelievable

  • @shrutibansal6188
    @shrutibansal6188 Жыл бұрын

    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.

  • @akashdeepdhiman6775
    @akashdeepdhiman6775 Жыл бұрын

    Great content delivered as always 🙏☺️

  • @jawadhassan4917
    @jawadhassan49176 ай бұрын

    I have no words to say THANK YOU. You are the best

  • @kevinjose2545
    @kevinjose2545 Жыл бұрын

    Great content as always. Thank you so much 👍

  • @parthbhatt1226
    @parthbhatt1226 Жыл бұрын

    Thank you so Much Sir!❤ Laate jaao Aise Practice videos

  • @shravansalian1848
    @shravansalian18488 ай бұрын

    Thank you we are lucky to have a teacher like you

  • @Kausar-2.0
    @Kausar-2.0 Жыл бұрын

    Dear Sir, really you are doing amazing job, keep up the good work..

  • @chipstead7919
    @chipstead7919 Жыл бұрын

    Sir bhut maza aa raha hai aap plz aise hi aur informative videos banayein.

  • @prxbhxt_t
    @prxbhxt_t Жыл бұрын

    Excellent content Parth Bhaiyya !!

  • @digvijayjadhav3164
    @digvijayjadhav3164 Жыл бұрын

    Sirr aapka ye series mast yahi jari rakho❤❤❤❤

  • @satyamhandage9392
    @satyamhandage9392 Жыл бұрын

    Great learning from you Looking for more More power to you😇

  • @pratikshapatil_
    @pratikshapatil_4 ай бұрын

    The only one who teaches absolute practically thank you ss much sir

  • @canikitak
    @canikitak7 ай бұрын

    Sir paanch dosto ko toh bta diya already! Wishing you all the best!

  • @varundubey6787
    @varundubey67872 ай бұрын

    Great video, thanks for sharing!!

  • @Daud710
    @Daud7102 ай бұрын

    Thank you for sharing such knowledge lessons ☺️

  • @harshitbansal1356
    @harshitbansal1356 Жыл бұрын

    Such high quality content❤

  • @Growtogetherteam
    @Growtogetherteam Жыл бұрын

    Thank you soo much, you are the best🙏🙏🙏🙏🙏

  • @umeshdhole3666
    @umeshdhole3666 Жыл бұрын

    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 .

  • @rupeshbansod8499
    @rupeshbansod84998 ай бұрын

    Huge respect sir.....

  • @13Dipesh
    @13Dipesh7 күн бұрын

    Great content delivered as always

  • @sanjaymondal3412
    @sanjaymondal3412 Жыл бұрын

    BEST TEACHER OF ALL TIME

  • @anishsoni9929
    @anishsoni9929 Жыл бұрын

    Loving your videos sir, Suggestions and request for next videos : Breakeven Analysis & Budget vs Actuals

  • @atharvadahake3102
    @atharvadahake3102 Жыл бұрын

    Thank you so much sir for such a good content..

  • @manjuslecturer720
    @manjuslecturer720Ай бұрын

    superb explanation -

  • @akashgoyal5344
    @akashgoyal5344 Жыл бұрын

    Sir You Are Great ❤‍🔥

  • @rizwanamulla4996
    @rizwanamulla49966 ай бұрын

    Awesome explanation sir

  • @kunalpawar5546
    @kunalpawar5546 Жыл бұрын

    Great mentor ❤

  • @junobitumixpvt.ltd.5047
    @junobitumixpvt.ltd.50473 ай бұрын

    Great Work sir, please keep helping us

  • @AkashKumar-if7yr
    @AkashKumar-if7yr Жыл бұрын

    Great content ❤

  • @freelearning4549
    @freelearning4549 Жыл бұрын

    thanku sir so much

  • @saswata2696
    @saswata2696 Жыл бұрын

    Valuation aur modelling ka aur video chahiye, He is like god for us.

  • @prashantchauhan2895
    @prashantchauhan28954 ай бұрын

    great content keep it up god bless you

  • @urvivaidya5920
    @urvivaidya59202 ай бұрын

    Thank you sir!

  • @akhiltyagi342
    @akhiltyagi3423 ай бұрын

    Amazing video

  • @venkatsupreeth.s5211
    @venkatsupreeth.s52113 ай бұрын

    Wonderful session

  • @Aksh-co6pt
    @Aksh-co6pt25 күн бұрын

    Valuable content sir

  • @ghanshyam8254
    @ghanshyam82546 ай бұрын

    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 🙌👏

  • @prathameshshahane6262
    @prathameshshahane62625 ай бұрын

    Great Work Sir

  • @dharmikvaghasiya423
    @dharmikvaghasiya4233 ай бұрын

    very insightful content sir after every video me like " maja aa gaya"

  • @mandarmitra007
    @mandarmitra007 Жыл бұрын

    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!

  • @mehranahmad5294
    @mehranahmad52949 ай бұрын

    It was really a great session

  • @Thehrithikraj1
    @Thehrithikraj12 ай бұрын

    Sir your conrent is really helpful thank you

  • @mumar8522
    @mumar85225 ай бұрын

    You are the king of all time

  • @yashrajdubey1351
    @yashrajdubey13512 күн бұрын

    thanks you sir for everything

  • @nileshdas9820
    @nileshdas98208 ай бұрын

    best content ever

  • @prasadbaviskar4423
    @prasadbaviskar44238 ай бұрын

    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._

    @pranayjain._

    4 ай бұрын

    Exactly! His concepts are not clear. Seems like he has just mugged up without logic of any sorts.

  • @AdityaMagar-vz8kj
    @AdityaMagar-vz8kj2 ай бұрын

    Thank you sir 😄

  • @sameerrai2256
    @sameerrai2256 Жыл бұрын

    Thank you sir ji❤

  • @yashrajput7212
    @yashrajput721211 ай бұрын

    Thank you so much sir ❤

  • @cycle8077
    @cycle8077 Жыл бұрын

    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 ..

  • @sparkingbulls..1847
    @sparkingbulls..184710 ай бұрын

    really great, please also start a series on fixed income securities

  • @jhanwar4382
    @jhanwar43824 ай бұрын

    Thanks A Lots🙏🙏🙏

  • @rajuvalmiki5672
    @rajuvalmiki5672 Жыл бұрын

    Parth sir awesome video

  • @kundanthakur5604
    @kundanthakur5604 Жыл бұрын

    ❤ My Mentor forever ❤️

  • @lakshaygoel9737
    @lakshaygoel97377 ай бұрын

    THNK U SO MCH SIR

  • @MadhuriKambli-sr3ec
    @MadhuriKambli-sr3ec Жыл бұрын

    great content

  • @kumarsanu6643
    @kumarsanu66437 ай бұрын

    Thank You Sir

  • @rajbhalshinge5170
    @rajbhalshinge5170 Жыл бұрын

    Thank you Sir

  • @tejassarvaiya5346
    @tejassarvaiya5346 Жыл бұрын

    Amazing

  • @sumitkumarsingh6982
    @sumitkumarsingh6982 Жыл бұрын

    Thankyou sir ❤❤❤❤❤

  • @gopikrishnanvb408
    @gopikrishnanvb4089 ай бұрын

    thank uuuu🥰😇😍

  • @techasylum3542
    @techasylum3542 Жыл бұрын

    Thankyou

  • @shrutibansal6188
    @shrutibansal6188 Жыл бұрын

    Sir I did liked, commented and subscribed your channel, like you said ♥

  • @vaishalipaliwal7532
    @vaishalipaliwal7532 Жыл бұрын

    very nice🙂

  • @financetips829
    @financetips8293 ай бұрын

    Good sir

  • @anildubey7764
    @anildubey77649 ай бұрын

    Great

  • @harsheetprajwal2014
    @harsheetprajwal20147 ай бұрын

    besttttt💯💯💯💯

  • @sunnysingh-xi9vx
    @sunnysingh-xi9vx7 ай бұрын

    Nice video

  • @mayankpradhan5308
    @mayankpradhan5308 Жыл бұрын

    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 ?

  • @gkpmemes1967
    @gkpmemes1967 Жыл бұрын

    Sir plz bring video on debt schedule, depreciation schedule.

  • @shubhamchhalani9978
    @shubhamchhalani99783 ай бұрын

    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

  • @vishalvenkatesh4379
    @vishalvenkatesh4379Ай бұрын

    confidenceeee

  • @navnathchavan4870
    @navnathchavan4870 Жыл бұрын

    Hat's off sir sfm Mai yetna deep nahi samja aaja aapne pura Cristal clear Kiya..

  • @suchanshetty2149
    @suchanshetty2149 Жыл бұрын

    Guru Dronacharya ❤🙏😁

  • @ja-cz7iw
    @ja-cz7iw Жыл бұрын

    Nice, can you create same for a portfolio

  • @RohitKamath
    @RohitKamath9 ай бұрын

    ❤❤

  • @DEEPAKYADAV-vq7kn
    @DEEPAKYADAV-vq7kn2 ай бұрын

    Please make vdo for stress testing

  • @srirampanjala4419
    @srirampanjala4419Ай бұрын

    💥

  • @Harsh10111
    @Harsh10111 Жыл бұрын

    I will upload it tomorrow on Linkedin😝

  • @kartiklodha9996
    @kartiklodha99962 күн бұрын

    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

  • @mandargadgil909
    @mandargadgil9099 ай бұрын

    Hi, I want to calculate the VaR for the GSec Portfolio? any vedio on that pls?

  • @palashgadge3508
    @palashgadge3508 Жыл бұрын

    Maja aa rha h sir 😂

  • @praveenpatil6011
    @praveenpatil6011 Жыл бұрын

    ❤️

  • @user-tp6kc8rv3k
    @user-tp6kc8rv3k2 ай бұрын

    sir ji aur video cahiye financial modeling ka

  • @aakashverma9132
    @aakashverma91325 ай бұрын

    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?

  • @akashdeepdhiman6775
    @akashdeepdhiman6775 Жыл бұрын

    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....

  • @pranaliruge1193
    @pranaliruge1193 Жыл бұрын

    Hi pruthvi sir . Do u have recorded financial modeling course ??? & pdf notes also . Do u have learning app for it??

  • @sahilgahlyan667
    @sahilgahlyan667 Жыл бұрын

    Hi sir Which version of excel you are using???

  • @dcchase8225
    @dcchase82254 ай бұрын

    Can we use these Modeling in Derivatives also like Nifty Banknifty?