Have a fairly intricate model with plenty of moving parts already. Set a senior and subordinate loan to calculate as LTCs of a total capitalization which inherently accounts for their interest reserves.
The model calculates well enough when I set iterations to i.e. 200 - but is there are way to make it operate faster without changing the iteration count?
would like to hear some opinions
| +65 | Hiring Analyst/Associate - Advice | 26 | 1h | |
| +40 | Current CRE Phase | 19 | 1d | |
| +36 | Laid Off - Multifamily Acquisitions Help | 8 | 4h | |
| +29 | Megafund REPE Comp | 12 | 5d | |
| +26 | Capital Formation | 9 | 2d | |
| +26 | Best Brokerages in South Florida | 18 | 1h | |
| +25 | PART 2: Increasing RE Industry's Cash Compensation, Collectively | 1 | 3d | |
| +24 | URGENT - a list of Halal/Islamic real estate funds and investment companies for potential applications | 8 | 3d | |
| +23 | NYU MSRE Program | 7 | 2d | |
| How many days a week are you expected to be in the office? | 22 | 2h |
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.
Interested as well
don't run iterative calculations, but instead include a buffer in the rate. Iterative calcs are cumbersome and provide a sense of false accuracy.
Can't the same be said about static calcs? If the loan sizing for one of the debt tranches becomes static, it won't gauge the interest properly.
Can you give an example of the buffer?
In other words, run the model/waterfall one step forward i.e. calculate the interest off of the prior periods balance. Regarding the buffer, run a market rate + 50bps
Can you post the (abbreviated) spreadsheet?
Bump. would be interested in this too. I delay the calcs one period or start with BOP balance and i still usually need 200 iterations to to accommodate mezz construction. Heck just a construction whole loan I usually need iterative calcs
it works fine at 200 (max 2 refreshes) just annoying when you have a lot to crunch
ahhh, my apologies, forgot to mention my our model has a facility size and expected loan-to-cost...nevermind
Aspernatur necessitatibus nihil labore mollitia ut doloremque. Eius quaerat dolorem ducimus aperiam ut.
Corporis cum ad qui veritatis rerum et dolores. Enim sequi consequuntur et sit perspiciatis. Nobis labore dolorum iusto numquam eum velit fugiat. Eum totam a quidem numquam.
Et quia illum quas voluptas odit provident. Ipsam eveniet mollitia pariatur. Quasi cupiditate non autem atque quaerat ut.
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...