Sensitivity Analysis for Financial Modeling financial analysis of a company

by WEyuicvkjhAGF



Sensitivity Analysis for Financial Modeling Course | Corporate Finance Institute

Enroll in the full course to earn a certificate and advance your career:

This advanced financial modeling course will take a deep dive into sensitivity analysis with focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions.

See also  3 STOCKS IM BUYING NOW! JUNE 2021 financial education 3

Course agenda includes:

Introduction
Why perform sensitivity analysis?
Model integration – Direct and Indirect methods
Analyzing results
Gravity sort table
Tornado charts
Presenting results

By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your financial model. Form and function are both critical to ensure you can handle quick changes and information requests when you’re working on a live transaction. .

Images related to the topic financial analysis of a company

Sensitivity Analysis for Financial Modeling

Sensitivity Analysis for Financial Modeling

Search related to the topic Sensitivity Analysis for Financial Modeling

#Sensitivity #Analysis #Financial #Modeling
Sensitivity Analysis for Financial Modeling
financial analysis of a company
See all the latest ways to make money online: See more here
See all the latest ways to make money online: See more here

See also  FINANCIAL INTERMEDIARY financial intermediaries

You may also like

47 comments

Himanshu Chopra 25/09/2021 - 8:04 AM

Is there a course which takes you through the complete building of this model please?

Reply
jacksen 25/09/2021 - 8:04 AM

The Crypto market has been unstable people ask themselves if this is the right time to buy the dip or sell their Hodlings. before jumping into conclusion i think you should take a look at things first. BTC price fall means analyst remain divided over whether it is entering a bear market or is just suffering a brief correction on the road to more record highs.Investors who bought early are still in profit despite the recent price crash and they also earn by trading. i'm still an investor and still I'm winning by applying the same method in every trade you can also become a winner today. We should follow the way of earning more regardless of the current market (bulls or bears), which is trading. Buy the dip and trade…i have made over 5 btc profits not just buying the dip but implementing tradess with s!gnals supplied by Edward James. You can easily get to him on < at Telegram
@EdwardJames00

Reply
Suaine Graham 25/09/2021 - 8:04 AM

This video quality is distorted is there another link to the vide

Reply
mzar62458 25/09/2021 - 8:04 AM

Thanks!

Reply
Bruno Ferreira Queles 25/09/2021 - 8:04 AM

Good morning, congratulations on the course. Would you like this spreadsheet to be available?

Reply
Sherwin Elumir 25/09/2021 - 8:04 AM

Very helpful, Can someone give the excel file of that?

Reply
Reggie Rosario 25/09/2021 - 8:04 AM

Excellent ! The presentation was very informative and helpful. Thanks a ton !!

Reply
Syed Ali 25/09/2021 - 8:04 AM

where is the download link for the excel file?

Reply
kppphd 25/09/2021 - 8:04 AM

Stunning! Thank you.

Reply
Accounting and Quickbooks 25/09/2021 - 8:04 AM

Nice videos. Thanks posting

Reply
steffy domnic 25/09/2021 - 8:04 AM

Is there financial aid available

Reply
Augusta yarteh Yarteh 25/09/2021 - 8:04 AM

I want to know more about corporate finances 1. Nice video.

Reply
pragith prabhakaran 25/09/2021 - 8:04 AM

CFI videos are very informative and well presented.
I have seen almost all the videos posted by CFI.
My question is for CFI; please answer what extra can I get by enrolling for the course?
Thank you

Reply
Otgon Dugee 25/09/2021 - 8:04 AM

Such an amazing presentation!! Many thanks!

Reply
Alan Shibu 25/09/2021 - 8:04 AM

GG

Reply
Masseni MAKADI 25/09/2021 - 8:04 AM

Thank you so much

Reply
Nutrisia Sayuti 25/09/2021 - 8:04 AM

I try to use "what if" function for the model that parameter input and formula in the different sheet. And it's not work. So I do the one way sensitivity analysis manually by change each parameter to min and max one by one.

Reply
KL M 25/09/2021 - 8:04 AM

You absolutely suck at teaching. Skip through several steps, don't even mention the shortcuts. FAIL!

Reply
Malia Charman 25/09/2021 - 8:04 AM

Sensitivity analysis- Excellent post. Thanks.

Reply
Emil Hasanov 25/09/2021 - 8:04 AM

Great stuff. Thank you.

Reply
Michael Horne 25/09/2021 - 8:04 AM

F4.. Thank you, just thank you…

Reply
FL 25/09/2021 - 8:04 AM

What could be the reason for me getting the same numbers for every combination of change?

Reply
Bharat Singh Panwar 25/09/2021 - 8:04 AM

Please provide vedio for all courses of financial modeling in details…..

Reply
Enrique Cruz timitydRUM 25/09/2021 - 8:04 AM

At minute 22:21, why did you select the negative values as the value to numerator of your division (-5% revenue growth value / (reference value-1))…why you don't select +5% as the numerator?

Reply
SRIRAM KV 25/09/2021 - 8:04 AM

❤️

Reply
Vinayak Gupta 25/09/2021 - 8:04 AM

As you said you worked as investment banker and consultant in corporate development. why you get into teaching line ..?
Your reasons will be valuable for me thanks..

Reply
JeissonLancheros 25/09/2021 - 8:04 AM

This was so useful! Thank you so much!

Reply
Kev Sal 25/09/2021 - 8:04 AM

Can you please help… I created my own financial model and I implemented the direct and indirect sensitivity analysis shown in the video. The direct method matches the results with my model. However, the indirect method numbers are not matching. The values at 0% are matching the model. However, the values at different percentages, in my case +/-10%, are not matching. Where do you think I went wrong?

Reply
xiaolin geng 25/09/2021 - 8:04 AM

Hi, Thanks for the wonderful video. Can i know where to download the excel docuemnt which you used for the video? Many thanks

Reply
Uma Vijay 25/09/2021 - 8:04 AM

This course which time complect

Reply
Kaustav Bose 25/09/2021 - 8:04 AM

is this template available?

Reply
Daniel Rigby 25/09/2021 - 8:04 AM

When you take the inverse value of the positive (column J), aren't you assuming each component is a mirror image of the other? I don't think they all have symmetrical outcomes on either side of 0

Reply
Renata Bongo 25/09/2021 - 8:04 AM

Impressive. Thank you for sharing.

Reply
Muhammad Umair Altaf 25/09/2021 - 8:04 AM

The best video with great communication skill…..

Reply
Alex Lee 25/09/2021 - 8:04 AM

I love your work mate, I will have more free time soon and will buy your big course, looking forward! The problem with Excel is that you forget things you don't use frequently, that's why I am doing this model for the second time

Reply
cw 25/09/2021 - 8:04 AM

Gorgeous model that tells a story in a clean & concise way, I love it. I will definitely be using some of the visualization techniques from this in my FP&A role.

Reply
Sweeping Sweeper 25/09/2021 - 8:04 AM

Thanks for the video!

Reply
patric Enoume 25/09/2021 - 8:04 AM

Hello, I m actually working on a project finance. and I would like to perform a sensitivity analysis on the DSCR and IRR which variables should I take into consideration.
From Morocco best regards

Reply
陈雪彬 25/09/2021 - 8:04 AM

I don't understand why the change is always symmetric? Are there some cases which the change on +5% is not opposite of the change on -5%?

Reply
sam2017 25/09/2021 - 8:04 AM

what if all of your outputs are the same?

Reply
Supernova 25/09/2021 - 8:04 AM

I like your Excel file but I wonder if its too complicated for real life application. Looks like the worksheet you are working with is loaded with an insane amount of data analysis.

Reply
Anar Aghayev 25/09/2021 - 8:04 AM

very effective way of explaining sensitivity analysis for equities. Thanks a lot!

Reply
Ugo Virilli 25/09/2021 - 8:04 AM

But, I have a question regarding the sensitivity of growth rate in revenue, which actually affect the EBITDA value as well somehow. How do you overcome that issue ?

Reply
Ugo Virilli 25/09/2021 - 8:04 AM

Amazing method, tremendously useful

Reply
Gonzalo Fernandez 25/09/2021 - 8:04 AM

hi i would like to ask for your help , i meed to created a price list but is a bit complicit as im not usr to excel
im planning to buy stuff and they are different grade of the same product
example : grade A = 100% Grade B= 85% grade C 65% and so on
many thanks

Reply
Phway Ko Ko 25/09/2021 - 8:04 AM

how to write "if A and B are in the same row'' in vba programming.

Reply
Andriy Andrushko 25/09/2021 - 8:04 AM

Excellent

Reply

Leave a Comment