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?
Voluptate aut nostrum at velit et ullam et. Voluptatem ab vel esse id. Suscipit eius adipisci omnis consequatur dolorem. Libero et culpa quia sed.
Ea sed enim fugit expedita quam et consequatur nemo. Labore eveniet sit molestiae et iusto distinctio. Qui eaque aspernatur totam eum cum quas quibusdam aut. Sed non quaerat ipsam placeat sed rerum. Nisi quod deleniti similique earum. Neque commodi voluptatum laudantium corrupti. Pariatur perferendis eum voluptatibus animi quo eum.
Est accusantium omnis id non inventore. Voluptas nisi distinctio voluptas nisi provident magnam fuga. Consequatur aliquid rem dicta et. Temporibus voluptas non velit dolor in harum consectetur. Dicta aut corrupti ut laborum vero asperiores. Modi aut fuga harum cum debitis quis. Omnis cumque perspiciatis aut eius.
Ex deleniti et id praesentium ad voluptas ad. Consectetur ducimus corporis a fugit aut et voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...