Anyone have any good operating models they could point me to? I know of macabacus and a few others, but just want a basic, forecasted financial statements model with iterations, etc.
Trending Content - Investment Banking Forum
| +69 | Wealthy Parents / Jaded | 22 | 17h |
| +48 | How are hours rn for SA (interns) | 29 | 5h |
| +45 | Venezuela Debt Restructuring - LAZ vs CVP | 20 | 4h |
| +40 | Background check issue IB Full Time | 23 | 17h |
| +36 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 8 | 1h |
| +30 | Boutique firm wants access to my LinkedIn? | 13 | 9h |
| +27 | Investment Banking in Mexico | 7 | 1d |
| +25 | MM bottom bucket bonus | 9 | 2d |
| +24 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 12 | 13h |
| +21 | Excel macros for QOL formatting | 0 | 2d |
Career Resources
actually, i was wondering if someone could critique an operating model i made this weekend for a company...
just got done with the 7 year forecasted operating model - but my circular reference is not working....anyone know any good ways to find out why? i saw that net income is showing up, but the direct link from the cash flows statement to the net income number shows a Div!/0 thingy....circular is definitely on...
Are you using average interest? Change to beginning period then back to average to break circ.
Or alternatively, go to the first cell that "works" (net income, or interest expense line), and re-drag it over the projection period.
Thank you for the advice.
Yes, the net interest line takes the average -LT debt * interest rate + average cash balance * assumed return...
The company has no real other items to consider...
I tried re-doing the formula and it worked! You're a genius! All i had to do was as you said, change to beginning, then back to average...
Why did that work now?
PM and I'll have a look at it... Got the spare time..
sent you a pm with my contact information
Dashri.... this is a relatively undocumented headache that i once had to figure out too, it works because you have to "jump start" the model sometimes in order to start the iteration process.
What alot of analysts do is have a toggle from average int exp to beg of period balance int exp, and switching this on and off helps break the circ bust.
Operating model (Originally Posted: 01/16/2013)
Does anyone have a good source that discusses operating model (revenue and expense model) in depth? I faced some questions asking about how to forecast revenue of consumer retail business vs. industrial (maybe semi-conductor business). Also I got asked how to project revenue of a construction firm whose revenue history has been very volatile. Do you guys have any thoughts on these question or know online sources?
Consequatur exercitationem ipsa ipsa enim deserunt voluptatem. Distinctio laudantium aut quaerat ipsa. Aliquam sunt exercitationem est. Ut voluptate cum consequatur voluptate vero. Illum autem autem voluptatem explicabo eligendi.
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...