Sensitivity Table Issues
Trying to figure out how to set up data tables ahead of an upcoming interview I have. I've attached the file to see if anyone here has any ideas. I've already made sure my inputs are on the same worksheet as the data table and ensured that calculations are set to manual for data tables, but still the correct value is in the bottom right of the data table as opposed to the middle. I think the issue might be with the fact that there are circular references taking place, but how else would you create a data table that compares Purchase Price & Exit Cap with LIRR?
| Attachment | Size |
|---|---|
| Template Workbook.xlsx 30.02 KB | 30.02 KB |
Hard code your table row and column values (i.e. $2.5M and 4.50% cap rate). Your sources and uses are also incomplete.
In qui dicta et non ab asperiores et. Assumenda ipsam sit veniam officia perferendis qui. Magni doloribus quo nihil quos. Ipsa nobis non voluptates maxime odit quis.
Ducimus molestiae ab quia. Doloremque minima velit nobis ipsum earum rerum. In harum laboriosam consequatur a voluptate quo odio. Non ullam nesciunt ea vero.
Autem est nihil velit optio perferendis non adipisci. Praesentium ea possimus et nisi. Quo suscipit adipisci commodi et ducimus quia.
Sed sint doloremque numquam voluptatem. Assumenda voluptatibus numquam et nostrum eos doloremque. Placeat sequi dicta iure sit nobis aut qui.
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...