Scenario & Sensitivity Analysis in Excel - Financial Modeling

The course provided me with very clear techniques and best practice methods to conduct scenario planning and sensitivity analysis

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

I really enjoyed the course. I progressed in my knowledge and skills and the Trainers teaching really enhanced this. Highly recommended.

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.

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.

Thank you so much for a great course. The skills I have learnt will help me in my professional career.

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

The course provided a good synopsis of sensitivity and scenario analysis. Have learnt a lot of formulae in this course. The course is very beneficial in financial analysis

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

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!

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.

I learned something new on this course that is vital and will be extremely resourceful for my future modeling projects. Excellent overview of sensitivity and scenario analysis. Good job CFI!

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.

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.

Scenario & Sensitivity Analysis is a very comprehensive and rigorous module. It helps a lot to understand howto use MS Excel for financial modelling and it equips future financial analysts and evaluators with significant accoutrements for their future careers.

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.

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

Very helpful and eye opener too. I recommend it to anyone building sensitivity and scenario models especially in this pandemic era. Thumbs up to the tutors at CFI.

This course provide easy and clear guidance to made scenario and sensitivity analysis. Its also help to determine when to use scenario and sensitivity doing the analysis

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.

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.

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

That is amazing course

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

It was good

I was really amazed at the level of precision in this course. I will definitely be applying my knowledge gained in my workplace. Thank you CFI!

I really liked this course. It was challenging, which is great. The content in this course is highly valuable for a professional developing in the finance field. Thank you CFI!

I'M LEARNING A LOT!

The course is extremely helpful and practical. The skills learnt can be immediately put into practice.

A detailed breakdown of one of the most important component of financial modeling and decision making. I enjoyed all the contents of the course. Highly recommended!

This course is very useful. I recommend it to every one!

this was very informative course with multiple dimensions of skills.

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!