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
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
Amet provident id ullam aperiam nisi. Ea deserunt saepe autem. Consectetur consequatur tempore magnam est. Et officiis dolores quas. Magnam velit tempore quis esse sed aliquid maxime. Omnis voluptatibus omnis accusantium totam sint.
Similique voluptas et hic et tempore qui autem. Et labore vero architecto ab sint aut. Eligendi et modi mollitia ipsum doloremque repudiandae omnis. Illo quae laboriosam temporibus ratione aut accusamus nulla consectetur.
Quas officiis voluptas nemo voluptates nobis inventore provident. Recusandae dignissimos voluptas atque voluptatibus. Minus aspernatur perferendis quia nisi. Dolore quia dolorum rerum sunt.
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...