Posts by: Guest 1
Re: WACC : Historical Beta Values
Fernandez from IESE business school in 2007 in a paper mentioned some formulae for levering/unlevering beta Fernández (2006): • If the debt is expected to be proportional to the book value of equity, the correct relationship between the levered beta (ßL) and the unlevered beta (ßu) is: ßL = Ã... Read More
Fernandez from IESE business school in 2007 in a paper mentioned some formulae for levering/unlevering beta Fernández (2006): • If the debt is expected to be proportional to the book value of equity, the correct relationship between the levered beta (ßL) and the unlevered beta (ßu) is: ßL = Ã... Read More
Making COUNTIF More Adaptable
I'm trying to count how many times a name occurs in a specific column. However, depending on where the person sits in the hierarchy, their name will appear in a different column. How do I make the "criteria range" in a COUNTIF function dynamic? I need a way to reference a key cell in the... Read More
I'm trying to count how many times a name occurs in a specific column. However, depending on where the person sits in the hierarchy, their name will appear in a different column. How do I make the "criteria range" in a COUNTIF function dynamic? I need a way to reference a key cell in the... Read More
How do you properly amortize debt items / paydown of debt?
Full Question:
How do you determine the amortization of debt items / paydown of debt for individual debt items?
Full Question:
How do you determine the amortization of debt items / paydown of debt for individual debt items?
RE: 338(h)(10) elections and NOLs
In that case, can a buyer who is a s-corp, llc, llp use section 338(h)10 or can it only be used by a buyer who is a c-corp bc only in this strucure is there double taxation events (the s corp, llc, llp pass through everything, so there would be no need to do a 338(h)10 if the buyer were somehting li... Read More
In that case, can a buyer who is a s-corp, llc, llp use section 338(h)10 or can it only be used by a buyer who is a c-corp bc only in this strucure is there double taxation events (the s corp, llc, llp pass through everything, so there would be no need to do a 338(h)10 if the buyer were somehting li... Read More
Watermark Help
I am currently viewing excel via the "Page Break Preview" mode. Is there any way to STAY in Page Break Preview, but remove the "Page 1", etc. watermarks that are present?
Thanks.
I am currently viewing excel via the "Page Break Preview" mode. Is there any way to STAY in Page Break Preview, but remove the "Page 1", etc. watermarks that are present?
Thanks.
What balances the LBO model in the Sources & Uses of Fun
Full Question:
What balances the LBO model in the Sources & Uses of Funds?
Full Question:
What balances the LBO model in the Sources & Uses of Funds?
RE: Negative Goodwill
Thanks for the fast reply. You are correct on your first remark. I ment book value. To be quite honest, once i have sent your email i tried to work it through your model with a trial and error method until i could balance it. Just for your info, until 31/12/2004 under IFRS 22 negative goodwill ... Read More
Thanks for the fast reply. You are correct on your first remark. I ment book value. To be quite honest, once i have sent your email i tried to work it through your model with a trial and error method until i could balance it. Just for your info, until 31/12/2004 under IFRS 22 negative goodwill ... Read More
Deal Comps Analysis: Quick model formatting question
Hi, This might seem like a dumb question, but does it really matter how we structure our models? Because the deal comps inputs doesn't have the "adjust EBIT" etc but the public comps do. Also, I feel a bit uneasy about hardcoding all these "adjustments": in the real working world, shouldn't we ri... Read More
Hi, This might seem like a dumb question, but does it really matter how we structure our models? Because the deal comps inputs doesn't have the "adjust EBIT" etc but the public comps do. Also, I feel a bit uneasy about hardcoding all these "adjustments": in the real working world, shouldn't we ri... Read More
How do you treat NOLs in a M&A deal?
Full Question:
What is the proper treatment of NOL carryforwards in a M&A deal for the acquiring company?
Full Question:
What is the proper treatment of NOL carryforwards in a M&A deal for the acquiring company?
if i have a set of same store sales growth for a retail company. i'm trying to see if the current recovery in those growth has actually made the sales level back to the pre-crisis level. hence... i index by putting 100 as 2007's monthly number. then i multiply that 100 with 1+SSS growth in 2008 and... if i have a set of same store sales growth for a retail company. i'm trying to see if the current recovery in those growth has actually made the sales level back to the pre-crisis level. hence...
i index by putting 100 as 2007's monthly number.
then i multiply that 100 with 1+SSS growth in 2008 and get a set of 2008 monthly new index number.
and for 2009 SSS growth, i multiply the 2008 monthly new index number with (1+SSS growth rate 2009) to get a new set of monthly index number for 2009
and then compare the 2007 the index number of 100 that i begin with to see if it grows above 100
is that how i can tell if the recovery has take place? or i can't do it this way as there are seasonality in the retail business, say winter and summer time? thx Read More