course bg
EduPristine>Blog>How To Perform Sensitivity Analysis Using Two Input Variables

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!

STEP 1:

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.

STEP 2:

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 Author

avatar EduPristine

EduPristine is a member of Adtalem Global Education (NYSE: ATGE), a global education provider headquartered in the United States. Adtalem is a 3 billion dollars (20,000 crores) company that has about 9 institutions and companies with more than 16,000 employees spread across 145 locations. Adtalem takes pride in training 142,000 degree-seeking students all over the world.The organization's purpose is to empower students to achieve their goals, find success and make inspiring contributions to our global community. EduPristine is one of India's leading training providers in Analytics, Accounting, Finance, Healthcare, and Marketing. Founded in 2008, EduPristine has a strong online platform and network of classrooms across India and caters to self-paced learning and online learning, in addition to classroom learning

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

Post ID = 41231