Ways to enhance underwriting in Excel
Im curious to know if you all use any extensions, excel add-ins, or AI that you’ve added into excel to make your underwriting easier and more efficient.
Trending Content - Real Estate Forum
| +45 | latest on Shorenstein? | 10 | 13h |
| +20 | To the veterans: What was institutional dev actually like during the last bull run? | 8 | 3d |
| +20 | Probability of S2 recap returning equity | 9 | 2d |
| +16 | Development vs. REPE pay gap | 8 | 3d |
| +15 | PGIM Real Estate Equity Opinions? | 10 | 1d |
| +14 | How do I break into a family office role | 3 | 1d |
| +13 | PGIM RE vs. Eastdil Secured | 5 | 1d |
| +12 | MBA Pipelines for REPE | 10 | 1d |
| +12 | Opportunistic Equity Acquisition Associate Role - Middle Market REPE | 1 | 1d |
| +12 | Reneging - What should I do? | 5 | 4d |
Career Resources
bump
Bump
Why are you bumping a post that’s already at the top of the RE forum page and was already bumped less than an hour ago
Not an add-in, but enabling iterative calculations in options. Helps with underwriting development and avoids circular references.
Can you explain the benefit? I’ve worked in development, debt and pure investment and have never found the need for this. I could be missing something. But in addition it frustrates the fuck out of me when I receive a model with iterative calcs enabled because it makes the model super laggy
How are you setting up the model to account for dev fees (based on total development costs)? That's an inherent circular reference since the dev fees are included in the total development costs unless there's a neat way to do it otherwise or your firm's dev fees were flat fees?
I mean one scenario is interest carry calculations. If your loan amount is tied to LTC and total costs include interest carry, enabling iterative calcs solves for this without the need for some side formula. CRE also mentioned dev fees which is another good example.
Really interesting. I'm the exact opposite- whenever I get a model that doesn't iterative calcs turned on, I assume the sender is an excel novice.
retail expense recoveries, management fees
calcing Pilots and unabated taxes, difference in NPVs
All loan sizings, interest reserves, interest rate caps, fees, self amortizing loans
equity broker and origination fees
calcing NMTCs and LIHTCs, tax exempt bonds,
Literally my whole budget is an iterative calc.
Macabacus has some fantastic features like auto coloring cells, way more intuitive cell tracing, etc.
100% agree, I used Macabacus for almost 2y and it has been a game changer. Deal with monthly cash flow models can be though, Macabacus makes it easier (formatting, auditing, and linking functions are top)
Adderall
I use the free A.CRE excel plug-in, very helpful
Add skynet into your model that’ll enhance it real good
Repudiandae quidem ut laboriosam magnam dolorum odio expedita. Quia nobis inventore dolorem sit. Aperiam sequi voluptates non magni.
A voluptas nobis culpa molestiae vero accusamus. Repudiandae laudantium et dolores. Alias et sint reprehenderit in. Quia consequatur quia a culpa.
Iste totam architecto voluptatem laboriosam dolores quasi. Veritatis totam tempore rerum officiis omnis magni. Perspiciatis quam nam sunt velit libero animi sit. Ducimus nisi officiis vero accusantium architecto aut.
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...