Showing results:
Displaying 1 - 45 of 45
Reverse DCF
I'm moderately accustomed to creating DCF models and I came across a reverse DCF book written by Michael Mauboussin titled "Expectations Investing" so I thought I'd give it a try. In the book he explain his process for creating a DCF model. What he doesn't go into too much detail is when he...
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,...
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...
Negative UFCF in dcf analysis
Hi, I'm trying to build a dcf model analysis. I got a company and this company considered a bluechip company in my country. The problem is when I calculating a Unlevered Free Cash Flow the calculation shows a negative value, and it is not in the quartal but also annually. The company has a huge...
Including returns from reinvested project's net cash flows in the DCF analysis
I perform several DCF analysis daily and have to make analysis aligned to my company's investment analysis proceeds. There is a rule that returns from reinvestment of exceeding cash flows should not be part of a DCF analysis. From my own research on this subject I found out that it is probably...
DCF in School vs. DCF in Banking
So far, we've learned the basics of DCF 's and all the concepts behind them. However, this is my first time in a higher level finance class that requires us to build a full model for a private company. Although I've done quick models where the information was all given to us, I've been completely...
Calculating IRR of cash flows with terminal value
I have a project with an initial outlay (Year 0) and 10 years of forecasted positive FCFFs and FCFEs. After 10 years, I use a Gordon/Perpetuity Growth Model to determine Terminal Value. I built DCF model and discounted FCFFs with WACC (to arrive at Enterprise Value) and FCFEs with Cost of Equity (to...
Run me through a DCF interview question
Every interview I've had I've been asked "walk me through a DCF analysis". However how technical must you go? Should you go through it in a basic way expecting them to have some follow up questions or should you go in depth throughout? I try to keep my answer fairly structured so I don't drift away...
Formulas? Any insight is appreciated.
Hi Everyone, My friend currently works in PWM at a major firm as an Associate. He is basically an assistant but has learned a LOT about the industry. He has a second round interview with a global fund manager that services only institutional clients. Essentially he is making the switch from the...
Cost of Goods Sold (COGS) Urgent Quick Question
Hi everyone, This financial statement totally confused me. What's the cost of goods sold here for 2008? Is it 84,616 or 71,527? Thanks!!
How to account for principal payments in a dcf?
If a company is paying off a significant amount of debt one year, how would you account for this in a DCF ? Or would you at all? M&I gives such a confusing answer to this question so I am totally lost.. Thank you for all the help
Why can't you use private companies as part of your public company comperables analysis?
I understand that it wouldn't make sense to use a private company in your calc of cost of eq or wacc BC private companies don't have values for market cap or beta, but why couldn't you use private companies in public comps ? Is it just because it's literally called "public" comps? Thanks in advance
URGENT! Financial Modelling & DCF Test - How to determine assumptions?
Might be the wrong section as its for a Private EQUITY gig however it more of an Investment Banking question. Bit of background. I was in Oil and Gas finance where the modelling is much different especially in assumptions where the data is much more streamlined and projections are worked on many...
Purpose of Recreating DCFs by Other Investment Bankers?
Hi fellow monkeys, At my summer internship , I was asked to recreate DCFs of certain companies that other investment bankers had already done for shareholder litigation purposes. I never asked them why I was doing this, but I did hear the associates say that they were surprised by the previous...
Do you have to build a full operating model when performing a DCF analysis?
Doing one for a stock pitch for an investment club. Is there any quicker way to do it? Intuitively with the accounts needed for a DCF I could always take the shortcut and project capex as a % of sales and depreciation as a % of capex, but do industry professionals build a full 3 statement model with...
Short Term debt and DCF
How should I treat short term debt in a dcf? I know this has been asked, but what changes in this instance is that the company I am valuating only has 50M in short-term debt; no LT debt. I know this isnt included in NWC, but where would I implement this in the model? What im doing is im getting the...
Discounting cash flows back to 2015--use mid-year discounting?
Hey all, quick question about DCF valuation. If you're valuing a company right now (mid-2015), do you discount cash flows back to 2015, or do you account for the fact that it's the middle of the year? In other words, should you discount back to 2015.5? Thank you all in advance!
DCF Question -- Should Acquisitions be Included In Capex?
Hey Guys, Quick question on the DCF . After I have NOPAT and I add back D&A and changes to NWC, I was wondering if I need to subtract out just mtx. capex or growth capex as well including acquisitions? The firm that is being valued is very acquisitive and so my thinking is that if I assume its top...
Analysis/valuation of real-time advertiser
Does anyone have experience in analyzing or valuing companies operating in the online real-time advertising industry? I feel like the industry is very different from normal retailers etc and I have very limited experience in this space. So what are some of the key considerations I should be aware of...
Why Is Accounts Receivable A "Cash Outflow"?
When accounts receivable increases, you will be paying something in cash for that increase With accounts receivable, you have to record it as revenue on the income statement At this point you have NOT collected cash On the income statement, the recorded revenue WILL be taxed by the appropriate tax...
Real Estate Analysis
How do you value a real estate company? What metrics are different, or how are they different? What if it is a commercial real estate company? Thanks
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...
Cost of debt in a DCF model and target capital structure
Hello Monkeys, Can anyone provide some insights on how to find the cost of debt for a firm and the target capital structure. Cost of debt is the interest rate to borrow. However, a company may have all kinds of liabilities with different rates. How do you find the cost of debt? Rosenhaum's guide...
FCF projection tips?
Hello Monkeys, I'm wondering how to accurately forecast FCF . Investment Banking by Rosenhaum suggests that we project future sales and use that as a reference to calculate other elements of the FCF . It seems a little bit too simple to apply to all kinds of firms. My question is, what kind of...
Real case of a valuation fraud from an expert. Some advice needed.
Hi guys. This is a real case and there is a trial going on (in eastern Europe ), I would like some hints from you and maybe even some help based on International valuation standards. There are 2 companies: Company A has 21 mil cash in bank, that's all the assets. Company B has a hotel, a pool, some...
Small DCF Question about Valuing Fourth Quarter Cash Flows
I'm building a DCF to value a company whose fiscal year ends December 31st. What is the industry accepted way of valuing the remaining year? Should I make a separate column for "Remaining 2013", come up with a free cash flow , and then use n=.25 to discount it? Should I use n=.125? Or should I come...
DCFs
dcf
Exit-EBITDA DCF Approach
When modeling a DCF , I have always used both the Exit- EBITDA and Perpetuity Growth methods as a way to calculate terminal value. But, the more I think of the Exit-EBITDA multiple approach, and what it exactly is doing, I get sort of confused.
DCF- fast way to predict the FCF growth rate?
Can we use FCFi*(1+g) or the average growth from the past is a better choice? i=1,2,...,n Thanks
What's Your Personal WACC?
It’s a well-known fact that the vast majority of us finance types can do amazing things with other people’s money while consistently shitting the bed with our own. I was inspired to write a post addressing this topic today because I was trying to decide what to do with my car loan this weekend....
Calculating Return on Equity in a DCF
How do you find the rate of return on equity when you're looking at different financing options in a DCF . I know that the formula is net income/shareholder equity, but this isn't giving me different rates for the different financing options... Thanks for any input
WACC if there is no beta?
fellow monkeys, im fairly new to valuation so please excuse if this question is actually really easy. i currently have to valuate an automobil supply company that is not publicly traded (and therefore does not have a beta?) and i was wondering how to calculate the WACC if you dont have a beta to...
DCF Question: How valuation changes if I buy a factory with $100 cash?
Hello everybody, I am working on a valuation question I found in one of the popular interview guides. The question asks me to evaluate the impact on the DCF valuation from the purchase of a factory with $100 cash on year 4 My answer was not similar to the one I found on the guide so I would...
Financial Sector
I currently analyze the financial sector for St. Bonaventure University's Students in Money Management group. I'm running a valuation on First Niagara and am having trouble with the Dcf which I think is coming from crazy working capital projections I am getting because First Niagara has been...
Linking DCF to IRR analysis
Hi guys, I need a help! i just finished building my dcf model. My boss asked me what is the IRR return? How can i calculate that? the purpose of my DCF model is to find out how much i should pay for that company. but i dont know how to figure the IRR return. is the Cost of the equity is the IRR...
Midyear Adjustment Factor
Instead of using a Midyear Adjustment factor, does anyone utilize a exponential function? If so, does it drastically produce a different result from a basic midyear adjustment? I am assuming not or it would be used more often right? Thanks in advance for the information.
What do analysts base their projections on the DCF input pages off of??
When someone makes financial estimates on the DCF input pages, what do they base those expectations off of? Economic factors mainly? Solely previous earnings?
Help Building DCF Model
I'm currently trying to build my own DCF model. I've studied the Rosenbaum format as laid out in his Investment Banking: Valuation, Leveraged Buyouts, and Mergers & Acquisitions. Does anyone have any excel files of DCF models they've made themselves or at work that I could go off of? I would like to...
discounted cash flows
Is the cash available to start a company in the base year when calculating the value of the company using a discounted cash flows for the value of the company is currently
Mortgage Insurers Model
I am looking to model some of the mortgage insurers MTG RDN PMI, and MBI. Any good examples or templates out there?
Pro-Forma Question on Case Study Help!!!
All, One of my interviews is requiring me to value a fictitious company. They give me the Income and Balance Sheet for Yr 1. Its a very basic statement with Sales, COGS, OPEX and NI and CASH, AR , INV, PPE, AP , and Debt. No Dep or Int They basically project out the income statement and capex for...
Is Yahoo highly leveraged or not? Would you value it using DCF - FCFF or FCFE?
Thanks!
Different approaches of the DCF analysis
hello im very new to finance ,and i've been trying to study a bit the DCF analysis can anyone enlight me on the differencies between: -entity approach -equity approach -adjusted present value approach thanks
Why Would You Not Use a DCF for Financial Institutions?
The guide says it's because fin institutions are highly levered and they do not re-invest debt in the business and instead use it to create products. Also, interest is a critical part of a bank's business model and working capital takes up a large part of their balance sheet. What exactly does this...
or Want to Sign up with your social account?