Data Tables Tutorial Series Part 1 [One Variable Data Tables]

In this video, I show you how to build a basic one variable data table in Microsoft Excel.
One variable data tables allow you to sensitize one input in your model and analyze what would happen to whatever outputs you choose in those different scenarios.
To elaborate, data tables allow you to input numerous potential options for one of your assumptions (in real estate financial modeling this may be the hold period or the going-in cap rate) and review the impact on outputs all at one time. The outputs in real estate financial modeling will typically be the return metrics such as the IRR and Equity Multiple.
This is the first video to the three part series created on data tables. Below are the links to all the videos in the series.
Part 1: One Variable Data Tables: • Data Tables Tutorial S...
Part 2: Two Variable Data Tables: • Video 2 of 3 on Data T...
Part 3: Two Variable Data Tables That Return Multiple Results: • Video 3 of 3 on Data T...
Bonus Video: Fix A Non-Functioning Data Table
You can also check out the post on our website Adventures In CRE (www.AdventuresInCRE.com) by clinking on the link below:
www.adventures...

[@henripopa]

Hi Michael, I am following this method, and my IRR and EM returns the same value, for the different purchase price.

[@MichaelBelasco]

This usually happens because you have workbook calculations set for 'Automatic except for data tables'. Just put together a quick video to show you how to fix. th-cam.com/video/sH-m1oT6Q_s/w-d-xo.html

[@vitalmalyardoff]

Hello Michael, Inspite of choosing Automatic in the Formula page, my results are same for all scenarios. Can you help pls.