347 647 9001+1 714 797 8196Request a Call
Call Me

How To Perform Sensitivity Analysis Using Two Input Variables

November 27, 2013
, ,

Have you ever been caught in a situation regarding data sensitivity analysis in Financial Modeling? If you have faced a problem before, find your answer right here! This is a step-by-step blog on how to overcome this problem using two variables!


While using scenario-analysis, people always get stuck between one variable and two variables by using one data set. So, to perform this we first need to create the basic assumptions on Excel and then set the Payment method.

See how simple it is? It can be implemented very easily while keeping in mind certain pre-requisites!

Sensitivity Analysis Example

Let’s move on to the next step.


After of doing this, you need to assume more variables and then select all additional variable portions. Then you select data tools from ‘What if’ analysis and put the values that need to be changed.

 Sensitivity Analysis in Excel

Here you can see that we have put D6(10%) and D5(60). Press ‘ok’ and it will automatically adjust the values according to data given.

Easy as a pie! There will be subsequent blogs about the following. So stay tuned for more!

To download the given Excel file so that you can play around with the numbers, just click on the link!


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 41231