JP Morgan DCF Model Part 2 & Sensitivity Analysis Solutions | Investment Banking Virtual Internship

#jpmorgan #investmentbanking #finance
This is part 2 of building the DCF model and completing the sensitivity analysis for the JP Morgan Investment Banking Virtual Internship. The focus is to go over a couple formulas for calculating the free cash flows, perpetuity growth portion, and exit EBITDA multiple.
Using the perpetuity growth method I calculated the EV to be $803M and $988.2M using the exit EBITDA multiple method.
Performing a sensitivity analysis allows us to see a number of possible values the EV can take based on changes to WACC and growth rate. Valuation is not a precise science so the range is crucial.
The second part of the video is summarising our findings in the slide deck.
Music:
Free Background Music For KZbin Videos No Copyright Download for content creators
• Free Background Music ...

[@adiofuhad2998]

To be very honest you are the most helpful human on the planet.... you deserve millions of views

[@zozazozi4380]

bro is out there saving lives

[@OmarSherif-xq7tf]

I would like to Thank you for the great effort Looking forward for the Task # 4

[@arthurkiselnikov]

Thanks! I appreciate it, Task 4 is up now

[@chunsiangyeoh]

really helpful. Thanks man

[@atharvajain9595]

Hey man! thank you so much it was very very useful !

[@xuanyi1291]

Thank you sooooooooooooooooooo muchhhhhhhhhhhhhhhhhhhhhhhhh .This is super helpful

[@arthurkiselnikov]

No problem happy it was helpful!

[@cuzogaming9129]

bro where you get illustrative DCF template to past that reports I couldn't found it

[@carlosrom6382]

after submitting excel sheet

[@nakedsock]

Just gave you a thumbs up, will be happy if you upload the task 4 walkthrough

[@arthurkiselnikov]

Task 4 is up!

[@ariamalik7344]

Do you know of any resources where we can learn exactly how to do this or even some sort of certification for beginners?

[@ASpecter007]

Hi, it was great work from you, but I'm having a doubt in Sensitivity analysis i've given values for all From Perpetuity growth rate to WACC step-up still in the table it shows like this #DIV/0! What should i do? a help here pls

[@sayanpradhan991]

Sor where do you find the sheet where you paste the datas of dcf output

[@1235-p4v]

Task 4 ASAP please thank youu!

[@arthurkiselnikov]

Will be working on it!

[@arthurkiselnikov]

Task 4 is up now!

[@ThisIsMy_Story]

Thank you so much for the help. May you also please help with the J.P Morgan Markets Virtual Experience program

[@arthurkiselnikov]

Thanks for the suggestion, I'll definitely take a look!

[@HARSHWAYNE-c1n]

Can you please make video on citi investment banking Forage

[@Pamilaugh]

Thank you man 👍 how do you set your slide to be that wide?

[@nathans6372]

For some reason I am getting different values for the ebitda multiple analysis any idea why?

[@jackhey8119]

Hey, I may have missed it but how did you find the step-up rates for perpetuity and WACC? Thanks for the videos.

[@arthurkiselnikov]

Pretty sure the step up rates where just in the instructions

[@YingHanChang]

I would like to ask why the enterprise value includes terminal value? Thank you!

[@_G.n.G_]

Why is my growth rate changing to 0.5 to 50 if I remove % sign after 0.5? 8.5% changes to 850% (key assumptions)

[@许文-j5d]

Task3 DCF input Perpetuity growth rate analysis and EBITDA multiple analysis There are no formulas, these 2 tables, is it convenient to share Excel with formulas?

[@dhonidhoni1345]

Bro i don't know where to start task 3 can you guide me

[@nazmeenshaikh2966]

can anybody tell me from where this template is downloaded (illustrative dcf model answer format)

[@yaoming42]

it comes up after u submit excel

[@mylordcoco]

I submitted the task but it is showing on reviewing your submission, we identified it as likely to be false upload or spam.

[@hash_caul976]

🤣🤣

[@hash_caul976]

Abbe bhai acha hua btta diya, mai to submit krne vlla tha, khali hi 🤣

[@mylordcoco]

😂 mehnat to krni padegi bhai .

[@Shuaib-j6c]

Hi where is this illustration dcf pdf, I am not getting it anywhere.

[@keysersoze7551]

After you submit the Excel

[@anasakhtar9793]

Where to subit

[@occhiverdi6129]

hi, thanks for everything but I'm having problems with line 67 of DCF input (Discount factor) I get #VALUE!. Could someone help me? PLSSSSS🙏

[@mohamedettaleby8160]

When you write a comma in excel, you write it with this ',' not this '.' . Change how you wrote the values in perpetuity growth, WAAC and ebidta multiple

[@Narendra-Kumar26]

But FCP Value shows different for me ? What's the reason remaining values are correct above the FCP

[@chiehtso6694]

I also need them

[@ayansarkar7880]

Same

[@mananvishwa8875]

where is the last file named Illustrative DCF analysis of Happy Hour where you pasted all excel files

[@ryuk7870]

i am also not getting that , can you help me with that

[@mananvishwa8875]

@@ryuk7870 it is there in next slide

[@Themayurchouhan]

​@@mananvishwa8875which next slide?

[@anasakhtar9793]

Am not able to get PPT template, what to do? Please tell me

[@Pranav_Singh_S]

Did u finish it?

[@anasakhtar9793]

Yes

[@Pranav_Singh_S]

@@anasakhtar9793 any other suggestions for internship?

[@carlosrom6382]

submit excel first

[@sukdevjana8124]

Where i will get the template. Pls help me out

[@arthurkiselnikov]

Hey! Templates are provided by JP Morgan through forage!

[@sukdevjana8124]

@@arthurkiselnikov yeah i get that, thank you Arthur

[@asdfgh950]

6:33

[@dhonidhoni1345]

Bro i don't know where to start task 3 can you guide me