Posts by: Guest 1
Re: 338h10 Election and pro forma balance sheet
Also, there would often be not a DTL...but more of a negative DTL (or I guess a DTA??) because cash taxes would actually be LESS than book taxes due to large amount of goodwill in a 338h10 that may be written off. Thus, do I need an asset on the balance sheet (or a contra liability to DTL) that woul... Read More
Also, there would often be not a DTL...but more of a negative DTL (or I guess a DTA??) because cash taxes would actually be LESS than book taxes due to large amount of goodwill in a 338h10 that may be written off. Thus, do I need an asset on the balance sheet (or a contra liability to DTL) that woul... Read More
How do you factor net operating losses (NOLs) in valuation?
Full Question: How do you factor net operating losses (NOLs) in valuation? I try to determine the NOL present value and add it to the enterprise value. This approach is very speculative, so I try to exclude NOLs from my valuation analysis unless I feel fairly confident the company/acquiror could us... Read More
Full Question: How do you factor net operating losses (NOLs) in valuation? I try to determine the NOL present value and add it to the enterprise value. This approach is very speculative, so I try to exclude NOLs from my valuation analysis unless I feel fairly confident the company/acquiror could us... Read More
Corporate Valuation Methodologies: about the case study
Hi there, a couple of questions here on the case study: (1). In the DCF page, how can you figure out these different diluted shares O/S if what you are trying to calculate (the price per share) is the input for our treasury stock method calculation for diluted shares O/S? (2). In slide 42 (WAC... Read More
Hi there, a couple of questions here on the case study: (1). In the DCF page, how can you figure out these different diluted shares O/S if what you are trying to calculate (the price per share) is the input for our treasury stock method calculation for diluted shares O/S? (2). In slide 42 (WAC... Read More
Thoughts after going through package3 (advanced modeling)
Hello i just finished package 3 and I have following thoughts: 1) In the third case of segment build-up session, I notice your projection puts depreciation aside of COGS and SG&A. Actually in accounting, depreciation is partly included in COGS and partly in SG&A. Hence it's not very much cl... Read More
Hello i just finished package 3 and I have following thoughts: 1) In the third case of segment build-up session, I notice your projection puts depreciation aside of COGS and SG&A. Actually in accounting, depreciation is partly included in COGS and partly in SG&A. Hence it's not very much cl... Read More
Why arent lease payments considered future debt obligations?
Full Question:
What is the rationale for not placing lease payments in the category of "future debt obligations" on your analysis sheet?
Full Question:
What is the rationale for not placing lease payments in the category of "future debt obligations" on your analysis sheet?
Re: Automatically Importing Formatted Data
This is good advice. Thanks for helping me figure out what Excel can and cannot do absent macros.
This is good advice. Thanks for helping me figure out what Excel can and cannot do absent macros.
For the WACC, should I use YTM or coupon for cost of debt?
Full Question:
For the WACC, should I use YTM or Coupon rate for the before tax cost of debt? I guess coupon rate, because the YTM can change if the bond is putable,callable,exchangeable,convertible etc.
Full Question:
For the WACC, should I use YTM or Coupon rate for the before tax cost of debt? I guess coupon rate, because the YTM can change if the bond is putable,callable,exchangeable,convertible etc.
Advanced Valuation Modeling: Share repurchase
Hi, I'm not understanding this small thing: When the company buys back shares, what happens to them - does the company just "destroy" them so that the s/out decreases, or does the new owner get the dividends now? If the latter, why would dividend payout decrease? Basically, what happens to sh... Read More
Hi, I'm not understanding this small thing: When the company buys back shares, what happens to them - does the company just "destroy" them so that the s/out decreases, or does the new owner get the dividends now? If the latter, why would dividend payout decrease? Basically, what happens to sh... Read More
Technology Sector Valuation
Hello,
I was wondering if there will be an industry specific model for the technology sector that will be created in the future? I'm very interested in this area but didn't hear anything about it coming soon. I thought I would ask. Thank you
Hello,
I was wondering if there will be an industry specific model for the technology sector that will be created in the future? I'm very interested in this area but didn't hear anything about it coming soon. I thought I would ask. Thank you
Hi WST, Hope all is well. While I am reviewing the Wal-Mart Advanced Financial Modeling excel, I realized that WM actually had a "share re-purchase program." However, I don't understand why on the projection we kept the common stock account in balance sheet constant. Should not we alloc... Hi WST,
Hope all is well. While I am reviewing the Wal-Mart Advanced Financial Modeling excel, I realized that WM actually had a "share re-purchase program." However, I don't understand why on the projection we kept the common stock account in balance sheet constant. Should not we allocate part of the deduction to the common stock account in order to adjust the correct basic share out instead of allocate the whole share re-purchase expenses to the retain earning? Of course, I am aware that on the excel we have properly adjusted the s/o of the calculation of EPS on the P&L. Many thanks... Read More