Basic excel question but I am stumped - I'm not sure if I am having a brain fart (plus i've been in the office for 14 hours at this point)
Assuming a 65% LTC how do I tie in the expense of the loan when it is based on the overall expense of the project without receiving a circular reference?
Thanks
| +111 | Is anybody just going to leave the industry? | 36 | 3m |
| +41 | CRE Recruiting for a Career - crazy? | 10 | 2h |
| +31 | Exits from REPE | 16 | 1h |
| +26 | Multifamily firms collpasing in Dallas whose next? | 8 | 2d |
| +21 | Q3/Q4 CRE Job Market Optimism (or lack thereof) | 10 | 1h |
| +19 | Arbor Realty Trust in 2026 | 10 | 19h |
| +18 | LOI Underwriting / Due Diligence | 1 | 21h |
| +15 | NYC Real Estate Job Market | 5 | 2d |
| +14 | Red Flag? Commissions-only acquisitions roles | 7 | 9m |
| +13 | Family Office vs REPE | 9 | 21m |
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.
What do you mean tie the expense of the loan in? Like the loan fee? As far as I know, it'll be a circular reference unless you don't include it in your uses. You could do 65% of the total project without fee and then just add the fee in. Why do you need to avoid the circular reference? Maybe I am misunderstanding you though.
I figured it out - thanks though. I'm going to have to write a macro (I was trying to avoid it). Assuming we are shooting for a specific ROC the land and construction/perm loan will be our only variable expenses
Run the model iteratively, no need for a macro. File > Options > Formulas > Enable iterative calculation. You can set for a lower number than the default 100 for this calc, I do 30 so it doesn't drag every time I change a cell.
This..
I will look into this - thanks
Natus deserunt aut aperiam cupiditate aut. Ipsa ab est dolorem rerum ullam ut. Perferendis eos repellendus aut occaecati excepturi ut voluptatibus.
Eaque et ut eveniet magnam quia optio iste. Facere facilis odio exercitationem dolorem. Iste consequatur officia saepe sed fugit est. Et omnis voluptatum quos ut. Ipsum harum in qui. Hic omnis eius velit dolore. Ut dolorum aut tempora voluptatem.
Minus accusantium modi libero dolorem consequatur et quis. Atque harum voluptatem aspernatur quas sint. Eos officiis quam earum nostrum nihil et omnis nam. Quis iste quia aliquam. Vel error praesentium et excepturi. Est doloremque tenetur expedita eius fuga. Et molestiae aut iusto.
Rerum tempore in praesentium voluptatibus enim velit harum. Soluta ullam optio voluptatem esse laborum sapiente. Minima cupiditate laudantium temporibus 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...