Two Variable Data Table - How to do Two dimensional Data Sensitivity in excel?

"Two-Variable Data Table Sensitivity Analysis (Valuation)

In this video, we look at two-variable data table or two-dimensional data table for sensitivity analysis in excel.

Two variable data table is where we can see the senstivity analysis in excel with changes in two variables and its corresponding impact on the output variable.

Two variable data table example
-------------------------------------------------------

Here we take an example of Alibaba Discounted Cash Flow sensitivity analysis. In DCF approach, we find the price of the stock using Free Cash Flow to firm approach where we require WACC (weighted average cost of capital) and Growth Rate (g) as the two variables.

By using the base case assumption of WACC and g, we get the fair price of the stock.

However, we can change the assumptions of WACC as well as g and find the effect on stock price using two variable Data Table.

Two variable data table in sensitivity analysis is the most useful function. It provides the effect of changing two variables at one time. Such a data table is extremely useful for Financial Analysts and their clients.

Connect with us!

[marcuslynn]

This video saved my group's ass for our decision analysis project.


THANK YOU!

[bradmorgan]

I did exactly what it said to do in the video but all of the columns in my table repeat the same number. I have no idea why

[sonumaheshwari]

Heya, I want to use two variable Sensitivity Analysis. Can anybody guide me abt it..
On one side it's Year driven & Other Side is Growth driven..M using NPV formula taking Cash flow for 180m With 10% growth rate..Now I want to use Sentivity analysis for different no of years & growth