I am calculating IRR from a 10 years projected cash flow + a terminal value.
The terminal value I understand is usually calculated as FCFF(1+g)/(r-g).
Incase of using terminal value for IRR calcuation should the r= cost of capital or r=IRR (in this case it will be iterative as its being used to calculate IRR itself). Please let me know the usual practice.
Thanks.
| +83 | LP coming into deal at higher land basis. How to model returns to GP? | 19 | 13h | |
| +76 | Increasing RE Industry's Cash Compensation, Collectively | 43 | 1d | |
| +73 | Major Decisions | 13 | 2d | |
| +44 | Being asked to stay behind and train my replacement | 11 | 10h | |
| +34 | Niche down to an operator or stay an allocator | 11 | 11h | |
| +24 | Breaking into CRE late 20s | 7 | 5d | |
| +23 | Thoughts on joining an early-stage REPE fund | 7 | 1d | |
| +22 | Self Storage ECRI | 9 | 3d | |
| +20 | Public Homebuilders | 7 | 9h | |
| +20 | How to get good at RE Modelling? | 18 | 13h |
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.
(discount rate - growth rate)
Why would you ever discount something by the IRR that you are trying to calculate?
The terminal value is a shortcut to projecting cash flows to perpetuity.
IRR is the discount rate that makes the NPV = 0. Why would you abirtrarily say you will stop discounting CF @ IRR the moment you reach the 10th year?
I believe you should do the iterative process. Doing a goal seek to find the right discount rate that would make your NPV = 0 would let you find the IRR.
smh
That's not how I would calculate a restaurant's value in time 10 (or even in time 1). I'd multiply earnings by an industry-standard ratio, e.g. 8 times earnings. I don't think "the market" values a for-sale restaurant using a DCF calculation. Exceptions might be McDonald's or Taco Bell. Regardless, if you're using a DCF calculation I'd use a multiple of earnings calculation for terminal value.
I guess I'm not following the question. You have (a) forecasted cash flows, (b) a purchase price (presumably) and you want to estimate an IRR. Why can't you goal seek the IRR? You're solving for the IRR given (a) and (b). It's not an issue at all.
Well he's looking for an exit price as part of the IRR calc.
I agree with Dances though, this is a pretty esoteric approach that I've never seen actually used. Just use a GMI or cap the NOI
So he has a target IRR and wants to see what the value is? That's not hard to do either. Yeah, you could use the WACC to get a price and estimate the IRR off that, but you'd have to explain what's driving the difference in the WACC/IRR.
On a semi unrelated note... How should one calculate TV for a non-profit affordable housing developer? (Government Housing Authority) Cost of Capital = 0%.
I applied a projected cap rate and ran with it. Is this appropriate?
How much would you pay for 0 profits?
I understand that we would target a Leveraged IRR of 0%. I am wanting to to know how you would calculate the Terminal Value of the property with a WACC of 0%. The Gordon Growth Model doesn't work in this case.
Should I just apply a multiple or cap the property at an appropriate rate?
I assume you're talking about the terminal value of a specific property. A property's "value" is not determined by the owner's cost of capital; it is determined by what the "market" would pay for the property. So if the government decided to sell the property, how would the market value the property? By capping the before debt service cash flow by a cap rate the "market" would be willing to pay for an income-restricted property.
I would try to find recent sales of the franchise in similar markets and use the sales comp approach.
If you can get that the physical uniformity of franchises should give you an accurate representation of the value.
Well the variations in franchisee credit could be significant
Repellat eligendi sunt ipsa cum quae quis quod aut. Aut neque tempore harum cum dolorem aliquid quam fugiat. Iusto nemo accusantium omnis dolorem cupiditate consequatur. Repellendus esse aperiam mollitia aut.
Provident vero error aspernatur assumenda maiores iusto unde. Enim voluptatem totam rerum tempora nostrum. Sit eos eligendi sit rerum. Impedit voluptatibus fugit quod dolores ducimus ea quis.
Sit dignissimos distinctio voluptatem nisi qui voluptate. Non qui possimus ad ex non delectus. Labore autem animi qui cupiditate.
Dolor voluptas aliquam exercitationem aut. Tempora accusantium id qui sed eos repellendus quasi error. Suscipit voluptate qui architecto necessitatibus maxime. Ut amet sit nam consequuntur accusamus eos qui ut.
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...