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
| +48 | Being asked to stay behind and train my replacement | 14 | 2d | |
| +36 | New Comp Database - Google Form (Now with Data Validation) | 24 | 14h | |
| +33 | Best CRE brokerage firms | 24 | 17h | |
| +30 | What does REPE actually do? | 12 | 19h | |
| +26 | Starting University LP Fund | 6 | 14h | |
| +24 | Leave brokerage to be GP | 1 | 7h | |
| +24 | Public Homebuilders | 9 | 20h | |
| +22 | REPE/Development GPA | 15 | 1d | |
| +17 | Seeking Career Guidance in Real Estate Development Post-Graduation | 2 | 5h | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 2d |
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
Dolor quibusdam cumque maiores sit assumenda facilis. Possimus quibusdam non molestiae et nulla. Vel facilis enim in sapiente eum. Et officiis tempora fugiat a suscipit qui.
Deleniti sunt explicabo odit. Aut perspiciatis quo dolorem.
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...