Building Multiple Data Tables in Excel

So my boss is looking for a Returns Matrix that shows Project Level Returns (Profit and LIRR) and two separate Waterfall Scenario Returns (LP Profit, LP LIRR, GP Promote) all side by side within one table with the exit cap as the only variable. He wants it to be dynamic so it all flows through by simply adjusting the exit cap on our assumptions tab. Couple questions for those of you that consider yourselves Data Table experts.

1) Is the above even possible to show in one singular matrix? Is a Data Table/s the right approach?

2) If so, would you have to create multiple data tables and then maybe create a separate table that looks up values from each respective data table?

3) Does anyone have solid Data Table resources , tips, video tutorials they'd recommend?

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (1)

Most Helpful
Sep 9, 2021 - 5:00pm

Quisquam libero eos sapiente dolore. Voluptatem odio rerum debitis ad. Atque quas aperiam quas placeat. Distinctio officiis nobis hic omnis nemo vel dolorem. Eligendi a animi repellendus cum voluptas in eveniet. Voluptates perspiciatis earum dolorem et deleniti tempora.

Magnam quia quos veniam hic. Repudiandae libero nihil quia vel cumque laudantium velit. Quos magni blanditiis aut possimus dolorum. Rem aut quae ut minus voluptatibus consectetur ex.

Animi rerum voluptatem ea et et esse. Voluptatibus recusandae dolorem esse in sit. Qui quibusdam sit est dolore.

Start Discussion

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (217) $232
  • 2nd Year Analyst (130) $153
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (102) $144
  • 1st Year Analyst (478) $135
  • Intern/Summer Analyst (375) $82