Hi,
I'm trying to set up a simple DCF in Exel but get constantly a REF-error in my calculations for fully diluted shares (although I've allowed iterative calculations). In fact, I just tried to replicate an example from a textbook. Can someone help me out and spot the mistake?
| +119 | I think I’m logging off after ER visit | 23 | 1d |
| +101 | Is it Bad That I ALREADY Don’t Care? | 31 | 6h |
| +91 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 10 | 10h |
| +89 | AI Creating More Work | 27 | 8h |
| +62 | Shit PWP Culture | 43 | 7h |
| +59 | Consulting Son or CorpDev Daughter? | 6 | 4d |
| +44 | How easy was recruiting for you? | 21 | 5d |
| +36 | 22yo IB Analyst just had mental health breakdown | 11 | 1d |
| +25 | Is the life of a VP at a 'top-bank' really good? | 6 | 17h |
| +22 | Law school instead of MBA for RX Banking | 3 | 1d |
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.
removed
anybody
D28 is dependent on the results from F17 but to get the result in F17 you need a result for D28, it becomes a circular argument that cant be solved.
But this is pretty muchcopied from their approach. How would I have to link it instead?
Someone else with experience of modelling this would be better placed to answer, I'm just an excel jockey. Also none of the above should lead to a #REF! result, this can only happen if you've deleted a cell or cell/range name.
Use the current share price, not the implied share price, to calculate the ITM options.
hominem's comment should fix it.
For cases where a model is supposed to use circular references (interest expense on debt, financing fees for debt raise, etc) you can build in a circ switch. Designate any cell as your "switch". The switch will either have value 0 or value 1.
In the portion of the model that is circular, write the following formula: =if(A1,desired calculation,0) where A1 is your switch cell. Because A1 is boolean, you can just say =if(A1, ...), you don't need to specify =if(A1=1, ...). To make things easier, you can assign name "circ" to cell A1 using the name manager in the formula tab in excel. Then your formula is simply =if(circ,desired calc,0).
While building the model, you can keep switch on 1 (for more complex models I would suggest keeping switch at 0 for ease of auditing). To fix a #REF error from circularity, just flip switch from 1 to 0 and back to 1. Happy modeling.
No, they employed the implied share price.
Autem et libero necessitatibus ut fuga cum ut. Molestias quis tempora in mollitia non. Id eaque qui ducimus ut corrupti. Omnis voluptatem nesciunt quo qui dolorem voluptatibus exercitationem nobis. Aut vel sint consequatur. Officia facere sit autem eaque.
Ea reiciendis libero molestiae sapiente occaecati. Non natus impedit nihil voluptatem magni soluta magnam. Earum iure delectus ipsam qui dignissimos est. Eum officiis explicabo corrupti aut provident amet voluptatem. Doloribus quia doloremque reprehenderit eligendi.
Unde qui repudiandae consequatur aperiam quisquam debitis. Ut excepturi facilis sint mollitia. Sit quod esse quo ipsa.
Similique pariatur architecto expedita et at voluptates. Error et illo vel quia excepturi eligendi id amet. Quisquam a excepturi cum quasi quos voluptatum consequatur. Expedita qui sunt vitae qui odit. Optio sed libero ex officiis magni.
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...