Posts by: Guest 1
Correct Net Debt for TEV
First of all I would like to thank for a great website for learning. I have problem in defining net debt thereby getting a true value of TEV. I have found and heard many definitions of net debt, these are some of them: a) interest-bearing debt less cash & cash eq b) LTL + short... Read More
First of all I would like to thank for a great website for learning. I have problem in defining net debt thereby getting a true value of TEV. I have found and heard many definitions of net debt, these are some of them: a) interest-bearing debt less cash & cash eq b) LTL + short... Read More
Pref stock included in debt for target M&A?
Hello, I was wondering why on the merger summary type of the advanced financial model, particularly cell F20 where we are calculating the total existing debt for the target company, why is that we are adding preferred stock? Is this b/c preferred stock is a hybrid of debt and equity? Can someone ... Read More
Hello, I was wondering why on the merger summary type of the advanced financial model, particularly cell F20 where we are calculating the total existing debt for the target company, why is that we are adding preferred stock? Is this b/c preferred stock is a hybrid of debt and equity? Can someone ... Read More
Adjusting historical financials for non-recurring/XO items
I have a technical question related to the impact on taxes when adjusting historical financials for non-recurring/extraordinary items that you may be able to help me with. Let’s take a generic example: EBIT => $ 300 Interest => ($ 1000) Pre-Tax income => ($ 700) Taxes => $ 200 ... Read More
I have a technical question related to the impact on taxes when adjusting historical financials for non-recurring/extraordinary items that you may be able to help me with. Let’s take a generic example: EBIT => $ 300 Interest => ($ 1000) Pre-Tax income => ($ 700) Taxes => $ 200 ... Read More
DCF EBITDA multiple approach
I am a little confused with the DCF EBITDA multiple approach. The confusion is from applying EBITDA multiple times the last projected year's EBITDA which, according to your presentation, yields the[u:11soywht] "terminal value" but not the enterprise value[/u:11soywht]. In the other word, I would h... Read More
I am a little confused with the DCF EBITDA multiple approach. The confusion is from applying EBITDA multiple times the last projected year's EBITDA which, according to your presentation, yields the[u:11soywht] "terminal value" but not the enterprise value[/u:11soywht]. In the other word, I would h... Read More
Re: Reference Range: Valuation of other industries
Hello,
I was wondering what other industry models are available, I may be interested in the Technology Media Telecommunication or Energy Sector. Are these models available? Thanks
Hello,
I was wondering what other industry models are available, I may be interested in the Technology Media Telecommunication or Energy Sector. Are these models available? Thanks
WMT model question
Hi I've just attended the Advanced Financial Modeling - Core Model workshop. After going over the WMT model today I'm unsure about the following. Please can you clarify for me. In the WMT B/S you have "Minority Interest", in cell G36 =397+1794, under Liabilities. However in the actual ... Read More
Hi I've just attended the Advanced Financial Modeling - Core Model workshop. After going over the WMT model today I'm unsure about the following. Please can you clarify for me. In the WMT B/S you have "Minority Interest", in cell G36 =397+1794, under Liabilities. However in the actual ... Read More
DCF Terminal Value Discount Period
Hope you’re well. got a technical question for you: re the DCF: should the terminal value as per perpetuity growth rate method be discounted back at the same time period as the terminal multiple approach? Ie, doesn’t FCF * (1+g) / (r-g) = present value of terminal value, as of 1 year after the ... Read More
Hope you’re well. got a technical question for you: re the DCF: should the terminal value as per perpetuity growth rate method be discounted back at the same time period as the terminal multiple approach? Ie, doesn’t FCF * (1+g) / (r-g) = present value of terminal value, as of 1 year after the ... Read More
LBO - Quick & Dirty - for a early stage investment
I was hoping to clarify the use of the LBO model for a project. My inputs into the model would be as followed: 1. Transaction Enterprise value would be the the Max Debt (Ending Balance under the debt sweep) of the project, which in our case occurs in year 2 2. New Equity is a plug, and up to us to ... Read More
I was hoping to clarify the use of the LBO model for a project. My inputs into the model would be as followed: 1. Transaction Enterprise value would be the the Max Debt (Ending Balance under the debt sweep) of the project, which in our case occurs in year 2 2. New Equity is a plug, and up to us to ... Read More
Macro error: compile error in hidden module: thiswork
Hello, I am using Excel 2011 for Mac, when I tried to to install the WST macro from tool -> add-in menu, an error shows up: "Compile error in hidden module: thisworkbook" And the WST did not show up after the error prompted. Please advise how I can fix this, thanks. Note: I download... Read More
Hello, I am using Excel 2011 for Mac, when I tried to to install the WST macro from tool -> add-in menu, an error shows up: "Compile error in hidden module: thisworkbook" And the WST did not show up after the error prompted. Please advise how I can fix this, thanks. Note: I download... Read More
ah I see. in my case, other income is sizable enough that if I placed it above the line, it would materially affect margins. But your explanation helps a lot. Thank you.