Scenario & Sensitivity Analysis in Excel - Financial Modeling

I'M LEARNING A LOT!

Excellent!

Definitely a fundamental course to expand financial analysis expertise. It is basically applicable in a day to day financial operation and critical for decision making processes. The key takeaways are the structure and easy interpretation this course gives you.

In this course I learned how to create a sensitivity analysis without the use of software as I previously learned.

I'm halfway through this course and I would highly recommend to each one of you who is likely to build a career in core finance.

It was good

no Need To review. All are Excellence, Need to try till Understand.

I must say, this has been nothing but an absolute pleasure! I cannot express my gratitude enough. I have been through so many courses already, from many places, none of them stacking up quite like these courses. Of course, anyone who wants to know more must learn take the initiative, as the CFI's FMVA program will prepare you to be a world-class analyst but cannot guarantee that anyone will capitalize on their potential! Something I've learnt from years of programming—recently working a lot more with XBRL—and various kinds of software engineering (vastly different from Excel, but also not too different) is bypassing the spectrum. What I mean by that is while you may think that forcing yourself not to accustom the actual programming behind any model—unless it is impossible to further improve the deployment structures—is the right way to go, it can also be the wrong way to go, or even be a huge mistake. You can end up with hundreds of separate models! That is why I agree with what Tim Vipond has so eloquently demonstrated here in this amazing course design for you to create easier-to-use models where the complexities are all neatly built around the core drivers. That's bypassing the spectrum, between simple and complex. I love it!!! I've used this technique many times in other areas of model building outside of Excel, and can attest to the fact that it is a universal concept that is applied in all areas of data handling. Whether you are a software engineer, a pharmaceutical data analyst, regularly making manufacturing projections, or if you are obsessed with trying to integrate environmental economic accounting systems into financial and managerial accounting systems—to make triple bottom lines rigorously and scientifically valid—you need Excel skills like these to do calculations on. Even better, if you are a financial analyst who sees the future of blockchain technologies, and the up-and-coming 5G which are all going to revolutionize the entire industry in terms of compliance and transparency, then I believe starting with this course is the way to go. You need to be world-class, and you need to get ready and be ready... That is why the CFI's FMVA program is exactly where you get to focus your mind on the world of possibilities that spreadsheet-based scenario and sensitivity analysis can unlock for you, as MS Excel will only continue to adapt with the times and remain a frontier-significant software... From forensic auditing, scientists in pretty much every field I can think of, to business people, use these skills — data validation, scenario analysis, and sensitivity analysis. The point is, these skills are extremely important in any field you are going to enter. Taking myself as an example, having financial experience and working in manufacturing sectors, you end up tuning into the financial sense that goes into so many systems that currently exist all around you. Completing this course means sharpening your skills in a way that will forever impact on how much you can succeed in finance.

This course really gave me a good insight on the Sensitivity and Scenario Analysis. The Step by Step excel instructions really aided in understanding how to perform the analysis efficiently. Loved it!

Excellent Course, learning a lot from CFI, great detail and simple steps to follow and understand the concept of the formulas.

This course is awesome and teaches you the basic knowledge everybody building a financial model should know about. It´s perfect exept for differences in the excel sheet the questions of the test rely on and the solution. The Excel Sheet for the questions says at the EV/EBITDA multiple sensitivity 5x, but the solution is based a 5% change.

Awesome formulas! Great explanations on the functionality of data tables, sensitivity analysis, and scenarios. I really enjoyed this course!

The course is comprehensive and highly educational when it comes to learning material and undoubtedly is a Level 3 Course, given the difficuly in the direct and indirect parts. The time allotted to each activity could have been more. Overall, it's a great course.

Hi Tim, This is what I always wanted to understand and showcase to my management and seniors. I love the way you link the variables in the indirect method and without actually chaining the inputs the probable results are there. Love from India...

The only suggestion I have is when you do the tornado topic the negatives and positives side can differ as it was in my working. Therefore maybe I would suggest instead of using ABS to separate positive and negative side calculation.

This course present good information but it was a quick course. Not nearly as in depth as the others.

Awesome course and vital for dynamic models and clearly understanding how our constructed financial models and valuation analysis with respond to future changing variables. Was awesome! Recommend this CFI course to professionals.

This is an excellent course! Advance financial modeling easy to follow and everything you need to know about sensitivity analysis. Very practical applications. Highly recommended for all finance professionals.

This was totally worth the time I like how the outputs are displayed in charts/graphs and definitely use the template in the future. Some parts are complicated but overall a very good course!

The tornado chart is super useful