Posts by: Guest 1
Re: Macro error: compile error in hidden module: thiswork
Unfortunately I am not in the area... I played around with it and this what I was able to achieve: 1. Run WST add-in, the error message came up 2. Option + F11, choose run -> run macro 3. Select WST_CreateMenu, the WST showed up 4. Do the above again, select WSTShortCutKeyActivate, the shortcu... Read More
Unfortunately I am not in the area... I played around with it and this what I was able to achieve: 1. Run WST add-in, the error message came up 2. Option + F11, choose run -> run macro 3. Select WST_CreateMenu, the WST showed up 4. Do the above again, select WSTShortCutKeyActivate, the shortcu... Read More
Re: Enterprise Value
How to calculate the Enterprise Value?
How to calculate the Enterprise Value?
D&A is different on the I/S and CF, which to use ??
When the D&A figure is different from the I/S to CF statements, which one should I use on the income statement when modeling forward and what is the reason for the D&A figures being different?
When the D&A figure is different from the I/S to CF statements, which one should I use on the income statement when modeling forward and what is the reason for the D&A figures being different?
RE: DCF EBITDA multiple approach
Okay. Since we calculate the EV by multiplying EBITDA multiple with the last projected year EBITDA, then, why on the "Simple Company Valuation" worksheet, you added the NPV of unlevered free cash flow to the discounted EV? Would not that over value the company?
Okay. Since we calculate the EV by multiplying EBITDA multiple with the last projected year EBITDA, then, why on the "Simple Company Valuation" worksheet, you added the NPV of unlevered free cash flow to the discounted EV? Would not that over value the company?
Re: LBO - Quick & Dirty - for a early stage investment
Thank you for your reply. 1. In response to point 1) - I did not think I should give any equity value to the project, but perhaps I should, given the work the company gone through to get it off the ground. The logic for TEV would be, since we have no EBITDA, or a business yet, would be (project fo... Read More
Thank you for your reply. 1. In response to point 1) - I did not think I should give any equity value to the project, but perhaps I should, given the work the company gone through to get it off the ground. The logic for TEV would be, since we have no EBITDA, or a business yet, would be (project fo... Read More
Re: Reference Range (Corporate Valuation)
Thank you. That means we do not calculate the reference ranges. Do we estimate the reference ranges based on the implied enterprise values, implied equity values and implied price per share plus other factors of the company? In the football field, do we estimate the reference range as well? I notice... Read More
Thank you. That means we do not calculate the reference ranges. Do we estimate the reference ranges based on the implied enterprise values, implied equity values and implied price per share plus other factors of the company? In the football field, do we estimate the reference range as well? I notice... Read More
daily number and quarterly data on chart
Hi, i hv say a few years of daily stock price and i want to overlay some quarterly inventory number or the yoy change on the inventory number to see how it moves with the share price. but since i maybe hv 10-15 rows of quarterly number, but i hv thousands of row in the daily stock price, how can i l... Read More
Hi, i hv say a few years of daily stock price and i want to overlay some quarterly inventory number or the yoy change on the inventory number to see how it moves with the share price. but since i maybe hv 10-15 rows of quarterly number, but i hv thousands of row in the daily stock price, how can i l... Read More
CAGR Question?
if you calculate CAGR and it returns a #NUM!, what shall I do?
if you calculate CAGR and it returns a #NUM!, what shall I do?
RE: DCF EBITDA multiple approach
Sorry to bother you on this. I understand the perpetuity method which, of course, we have to add the interim cash flow to the terminal value because the terminal value represents the cash flows that the company would generate, say, to infinity from the terminal year. However, the EBITDA multiple... Read More
Sorry to bother you on this. I understand the perpetuity method which, of course, we have to add the interim cash flow to the terminal value because the terminal value represents the cash flows that the company would generate, say, to infinity from the terminal year. However, the EBITDA multiple... Read More
Hi,
In the Reference Range sheet, how are the reference ranges be calculated? However, I understand how I can calculate each implied enterprise value, implied equity value and implied price per share.