Create A One Variable Data Table In Excel

Показать описание

A one variable data table allows you to test how multiple scenarios of one input affect the value of an output. In our example, we want to determine how changes in the value of our mortgage will impact the monthly mortgage payment. This may help us make choices on how much money we want to deposit upfront. We’re assuming that the interest rate of the mortgage is fixed at 5% and the mortgage term is 25 years long. Firstly we’re going to calculate the monthly payment for these inputs. We’re then going to put together a data table which will allow us to see how changes in the mortgage amount impact the monthly payment.

Set Up A Data Table For Sensitivity Analysis In Excel:

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Calculate Output: (0:53)
Create Data Table: (1:53)