Posts by: Guest 1
Re: Zoom in Excel
No, just a beeping noise everytime I hit the J.
No, just a beeping noise everytime I hit the J.
338h10 Election and pro forma balance sheet
How would you go about modeling a 338h10 election on the balance sheet. Lets say all of the assets on the books were at $100, but you paid $200 for the company with a 338h10 election. How do you know how to allocate the extra 100 across the assets? Or would you create a new asset category that would... Read More
How would you go about modeling a 338h10 election on the balance sheet. Lets say all of the assets on the books were at $100, but you paid $200 for the company with a 338h10 election. How do you know how to allocate the extra 100 across the assets? Or would you create a new asset category that would... Read More
Tax expense for terminal year
Hi WST, If a company enjoys a tax reduction for whatever the reason for, say, our project years (5 years). Should we adjust the terminal year tax expense to the normal level in order to obtain the correct terminal value? EX, the effective tax rate for t+1 till t+5 would be 10%; however, it would ... Read More
Hi WST, If a company enjoys a tax reduction for whatever the reason for, say, our project years (5 years). Should we adjust the terminal year tax expense to the normal level in order to obtain the correct terminal value? EX, the effective tax rate for t+1 till t+5 would be 10%; however, it would ... Read More
Re: Excel Macros
But where would I enter those in, it seems like if I want to edit my macros, it only allows the ctrl or the ctrl + shift options
But where would I enter those in, it seems like if I want to edit my macros, it only allows the ctrl or the ctrl + shift options
COUNTIF, Then What?
I have a list. Columns are A.) Date Trained and B.) Certified? (this is TRUE or FALSE) I want to make multiple pie charts from one table. I need the pie charts to show percentage certified and percentage not certified. Each pie chart needs to depict a different Date Trained. I currently am usin... Read More
I have a list. Columns are A.) Date Trained and B.) Certified? (this is TRUE or FALSE) I want to make multiple pie charts from one table. I need the pie charts to show percentage certified and percentage not certified. Each pie chart needs to depict a different Date Trained. I currently am usin... Read More
still unsure as to what the proper methodology is
i see what you're saying. the situation is this. we're in the senior secured debt and we are certain that the company is headed towards bankruptcy. we are certain the senior lenders will get the equity post bankruptcy. based on the new accounting standards, we must fair value the converted equity on... Read More
i see what you're saying. the situation is this. we're in the senior secured debt and we are certain that the company is headed towards bankruptcy. we are certain the senior lenders will get the equity post bankruptcy. based on the new accounting standards, we must fair value the converted equity on... Read More
Re: Excel Macros
Basically, what I am trying to do is to set up a macro that uses the ctrl + shift + alt + arrow keys as the short cuts. I am not sure how to set the hotkeys other than going to Tools>Macro>Macros and then clicking options to change the hot keys. Let me know if you can help.
Basically, what I am trying to do is to set up a macro that uses the ctrl + shift + alt + arrow keys as the short cuts. I am not sure how to set the hotkeys other than going to Tools>Macro>Macros and then clicking options to change the hot keys. Let me know if you can help.
A quick question about TEV
In advanced modeling session, Hamilton uses tax-effected EBIT, instead of Free cash flow to firm, to calculate terminal enterprise value (TEV=EBIT(1-tax rate)(1+g)/(WACC-g), but almost all texts use FCFF in numerator). Given EBIT not including capx or working capital, how would this argument be ju... Read More
In advanced modeling session, Hamilton uses tax-effected EBIT, instead of Free cash flow to firm, to calculate terminal enterprise value (TEV=EBIT(1-tax rate)(1+g)/(WACC-g), but almost all texts use FCFF in numerator). Given EBIT not including capx or working capital, how would this argument be ju... Read More
Why is minority interest NOT included in M&A analysis?
Full Question:
I believe you characterized minority interest as a quasi-financing for earnings (which seems similar to interest-bearing debt). Therefore, it would seem that I should include minority interest in my enterprise value calculation.
Full Question:
I believe you characterized minority interest as a quasi-financing for earnings (which seems similar to interest-bearing debt). Therefore, it would seem that I should include minority interest in my enterprise value calculation.
You know what you could be right on both... Thanks. I got it.