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
| +24 | Hotel Recruiters | 14 | 1d |
| +15 | Senior Living Modeling Help | 5 | 5h |
| +12 | Leaving Self-employment for Commercial Real Estate Brokerage | 2 | 3d |
| +9 | REPE Analyst Firm Advice | 1 | 12h |
| +7 | KeyBank RE Underwriting | 6 | 2d |
| +6 | Rate Hikes | 2 | 2h |
| +3 | What are the best undergrad schools for placing in real estate finance? | 6 | 18h |
| +3 | BGO REPE LDN | 0 | 5h |
| +3 | Overtime approval | 5 | 21h |
| +2 | Anyone familiar with Migsun Nehru Place, Greater Noida? Thoughts on investing here? | 3 | 3d |
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
Doloremque sapiente et eius ea est aut illum. Accusamus excepturi voluptatem et. Quo nemo aut eos velit mollitia in. Aliquam nostrum perspiciatis numquam hic. Et amet et ut.
Ab nulla voluptas aspernatur voluptatum consequatur. Rerum id quis maxime quae quam nemo. Voluptatibus voluptatum animi aut illo ab.
Omnis ut explicabo eius sint consequatur. Ut et nulla ut et. Sint aut ducimus ut tempore accusantium.
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...