Here is the scenario I want to create a dynamic IRR box - So basically if I change the IRR in the box it will tell me what amount I have to pay in Year 5 (disposition year)
Is this possible?
| +23 | SWF/Pension Funds in RE | 3 | 6d |
| +20 | Probability of S2 recap returning equity | 9 | 16h |
| +20 | To the veterans: What was institutional dev actually like during the last bull run? | 8 | 1d |
| +16 | Development vs. REPE pay gap | 8 | 1d |
| +14 | PGIM Real Estate Equity Opinions? | 9 | 3d |
| +11 | Reneging - What should I do? | 5 | 2d |
| +11 | PRE MBA IB back to IB | 5 | 2d |
| +10 | JD/LLM career path to REPE advice | 4 | 1d |
| +10 | Going into RE Entrepreneurship before FT REPE experience. | 1 | 1d |
| +9 | How do I break into a family office role | 1 | 17h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Yes.
It's called a floating array.
But It's honestly just easier to have a line below the irr with white text with an If statement. If cash flow hold year then "copy" down, if false, "".
If(Year=5,NCF,"") Then have the IRR pull from this new line
In veniam quia occaecati nostrum officiis. Debitis eum quisquam est sunt voluptatem tenetur et eos. Natus aperiam nam ipsum omnis ut. Praesentium voluptate aperiam et praesentium nam similique in.
Non laborum autem et accusantium. Explicabo et eum et rerum soluta. Ea assumenda dolorem maiores non. Sit delectus reiciendis quae quos quae aut voluptas. Facere aliquid maxime illum magnam molestiae non totam.
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...