Showing results:
Displaying 1 - 22 of 22
NEWBIE SEEKING FEEDBACK ON DCF MODEL
Hello all, I just finished a DCF course and tried to make a DCF Model of lululemon from scratch. It seems like its most likely wrong as it has a -66% downside for the implied share price. I'm unsure of how I should get assumptions so I just took the average of the past 7 year growth rates and...
Interview question: How to would you value a toll road / airport using a DCF?
Could someone help me prepare for this interview question? Interviewing for a greenfield listed infrastructure fund.
DCF Disparity between methodologies...Help
Hi All, I have a question about the disparity between the perpetuity DCF output vs. Exit Multiple outputs. I did a DCF and they are very different and wanted to know, is this normal? Or if they should be within a certain range of each other? For instance, the closing price on the stock was $77.83,...
DCF question: Need help calculating terminal value using exit multiple strategy
Once you calculate EV/EBITDA multiple, what do you do from there? How do you use it to calculate terminal value?
How to value properties overseas - DCF (?)
Okay so I have a DCF valuation problem/buyout problem. I'm basically valuating a company and as you guys may know you value the company itself and then add the value of the properties and that what I'm going to offer my seller. I have or can valuate the property that is in my home country but I...
DCF with subsidiaries overseas
Guys I really need your help. I'm new at this firm and I don't get much help, I most things by Googling or asking people I know. However, I took the biggest fucking project at the firm and now I need to do a DCF with multiple subsidiaries that I can't get data for, but that isn't the problem since I...
Help with DCF model
Hi guys, I'm a second year student and I have a problem with my DCF model which was prepared for my paper work at university. The problem is the following: % of Implied EV from TV is 87%. As far as I know, this is an extremely high percentage. That is why, I would like to ask you for your help. I...
Stock valuation with covid numbers
Hey guys, first timer here also big noob so sorry if this is obvious. I'm trying to do a valuation of a company(TJX) and do my first dcf, but i'm unsure as to how I should utilize fy21 statements for it. Like tax rates for wacc, some of the competitor tax rates were high relative to prior years and...
Depreciation in the FCFF DCF model
Hi all, I'm trying to calculate FCFF for a company for a DCF and depreciation ends up making up a massive proportion of the FCFF (~60-75%), overriding any effects of the net income projections on the projected price. How should I interpret these results and are there any red flags I should be...
Question about the FCFE DCF for high dividend stocks e.g. telecomms
Let's say I use the FCFE DCF to value a dividend stock: If company X stock is $3, it is expected to pay $0.30 in dividends a year and a 5-year FCF DCF into the future values it at $4, is the projected return on the stock according to the DCF A) 75% over 5 years because dividends are added after...
DCF - value is less than net assets - still useful / alternatives?
Hi all! Just done a DCF & the equity value (26.9m perpetuity / 41.3m exit EBITDA) is significantly less than net assets (52.5m). The perpetuity itself is worth less than just the fixed assets (29.3m). What ways/multiples might be more useful to value a business in a case such as this? Thanks all!
DCF Help: Not balancing (SOLVED)
Hi guys, new to the forum and I've been trying to build a DCF for AMD for preparation sake, but I'm having trouble getting the balance sheet to balance. I've looked at it for so long, I've probably missed something obvious or made a stupid mistake. Personally, I think something is off with my cash...
DCF non-cash add backs
Im working on a DCF and having trouble with add backs for FCF . When calculating FCF , I understand we need to add back non cash-expenses such as D&A. Do we also need to add back one time non cash expenses like impairments and G/L on disposal of assets? In addition, I think deferred income taxes are...
DCF for debt-reliant companies
Hi all, I'm an undergrad currently trying to build out a DCF (three-statement) model for a debt-reliant company -- solar panel farm manufacturer. I believe that the company will need to issue future debt in order to finance new projects, and was wondering how this will affect my DCF . I understand...
DCF - Valuing a private trucking / container shipping business
Hey everybody. Have a friend I met a while back who owns a private trucking / container shipping business. He asked me if I would be able to help him value it to sell. Being the eager person I am I told him I would be happy to help. Have only done a couple DCF 's in my day back in college which were...
DCF please help! beginner
Hey everyone, I have been trying to get into the whole valuation of stocks and what better way than to start with the DCF model. I am new to all of this and am looking for some guidance. I think I have the basic idea down but feel like I am missing something. I am trying to value Under Armour (UA)....
Is Line of Credit treated as LTD?
I am trying to figure out where a company's Line of Credit fits into my DCF model. I have a DCF model, using a WACC , where I am trying to find the equity value . The answer I receive after the sum of present values and residual value would be my enterprise value. I now need to deduct Long Term Debt...
minority interest??
im using the indirect approach to calculate the cash flow statement.. how to account for minority interest when calculating cash flow statement? should I start with net income after minority interest? and should the change in non-controling interest (from the balance sheet ) be added/subtracted?...
Problems with Model
What's up, guys? I'm doing a DCF for a company, but I seem to have run into a few problems: 1.) Circular references arise when I plug in my interest expense from my Debt Schedule. 2.) Company did a revolving credit facility in 2011 and my Debt Schedule is shaky at best. 3.) Balance sheet not...
DCF Projections...
I've learnt the key aspects of DCF analysis, but one thing that just sprung to mind is, what factors dictate how many years you choose as the projection period? Obviously the point of the model reduces the FCF's to NPVs, so every year the denominator in the equation for EV is getting larger. But, if...
DCF Analysis Equity Value < BV of Equity
Hey All, Need help, first time doing an LBO on a company whose cash flows are not sufficient to cover needed debt, as a result my DCF equity value is less than book value of equity at closing. Is this normal? Does it mean I should try to purchase the company for less that it is worth on the books?...
Stock Based Compensation and FCF modeling
Hi there, In my DCF model, I am considering subtracting the stock-based compensation from my unlevered free cash flows. Although some argue that stock-based compensation is a non-cash expense and should be added back to unlevered cash flows, if the options were issued to the market, the cash...
or Want to Sign up with your social account?