Posts by: Guest 1
Re: Inventory Writedown
ah thank you for the confirmation. I manually adjusted the formula in Inventory to capture it. Thank you very much!
ah thank you for the confirmation. I manually adjusted the formula in Inventory to capture it. Thank you very much!
AFM Core Model: mandatory debt payment for commercial paper
Hi, why in the model , we don't have model out the mandatory payments for commercial paper? in cell i28, why the number is zero?
Hi, why in the model , we don't have model out the mandatory payments for commercial paper? in cell i28, why the number is zero?
Financial Modeling - Enhancements Part 2
Hi - I am having a little trouble understanding how Goodwill impairment is treated in the GAAP financial statements. I am under the impression that if there is an impairment, the impairment is deducted from Operating Income to arrive at the GAAP Pre-Tax Income. Is my understanding correct? If yes, t... Read More
Hi - I am having a little trouble understanding how Goodwill impairment is treated in the GAAP financial statements. I am under the impression that if there is an impairment, the impairment is deducted from Operating Income to arrive at the GAAP Pre-Tax Income. Is my understanding correct? If yes, t... Read More
Modeling Questions for Mature Company
Hello, I have a few questions for modeling a mature company relative to the model Hamilton showed us for GT a few weeks ago. Please feel free to answer these one at a time or all together, which ever is earier. 1) I’m modeling a company (Medtronics) which has consistent commercial paper borrow... Read More
Hello, I have a few questions for modeling a mature company relative to the model Hamilton showed us for GT a few weeks ago. Please feel free to answer these one at a time or all together, which ever is earier. 1) I’m modeling a company (Medtronics) which has consistent commercial paper borrow... Read More
Financial Modeling - Enchancements Part 2
Hamilton explains at the end of the video how to integrate the Tax Schedule file with the financial model developed in Part 1. I had a query regarding this, while integrating the Tax Schedule with the model, where does one obtain the Ending NOL figure (if any) in cell F23 from (this was hard coded f... Read More
Hamilton explains at the end of the video how to integrate the Tax Schedule file with the financial model developed in Part 1. I had a query regarding this, while integrating the Tax Schedule with the model, where does one obtain the Ending NOL figure (if any) in cell F23 from (this was hard coded f... Read More
AFM Core Model: Current Portion of LT Debt
Hi, in the "Current Portion of LT Debt" calculation we are considering next year's Mandatory Repayment (line 11). However, if we look at the Mandatory Repayment formula it also includes the Commercial Paper paydown, and the same mandatory repayment cell (line 11) is used to determine the "Current Po... Read More
Hi, in the "Current Portion of LT Debt" calculation we are considering next year's Mandatory Repayment (line 11). However, if we look at the Mandatory Repayment formula it also includes the Commercial Paper paydown, and the same mandatory repayment cell (line 11) is used to determine the "Current Po... Read More
Merger Modeling & LBO Modeling - FASB 141r
With the new FASB 141r in place, can you let me know how transactions costs (which were earlier added to Purchase Price to compute Goodwill) is to be treated? Do we directly expense it via the IS or hit Retained earnings in BS (just like tender costs)? I know the impact is the same, but just want to... Read More
With the new FASB 141r in place, can you let me know how transactions costs (which were earlier added to Purchase Price to compute Goodwill) is to be treated? Do we directly expense it via the IS or hit Retained earnings in BS (just like tender costs)? I know the impact is the same, but just want to... Read More
Re: Stock issued: calculated off Equity Value or EV?
Ok thanks! Sorry i must've missed the caveat in the simple merger model video. But that's what I figured and yes that makes logical sense.
Ok thanks! Sorry i must've missed the caveat in the simple merger model video. But that's what I figured and yes that makes logical sense.
Re: Modeling Questions for Mature Company
Thank you, I appreciate your feedback. I am finding the class very helpful in my analysis and look forward to investigating some of the online offerings. I will also stay tuned for any of your other course offerings in Chicago.
Thank you, I appreciate your feedback. I am finding the class very helpful in my analysis and look forward to investigating some of the online offerings. I will also stay tuned for any of your other course offerings in Chicago.
In the int-Adv model (and this is the case for the AdvFM Model as well, why do we build the Cash Available Before Debt calculation to include a dividend payout when, in theory, dividends have the last priority to payouts. Shouldn't the debt sweep sweep through first and then we decide if dividends a... In the int-Adv model (and this is the case for the AdvFM Model as well, why do we build the Cash Available Before Debt calculation to include a dividend payout when, in theory, dividends have the last priority to payouts. Shouldn't the debt sweep sweep through first and then we decide if dividends are payable? Or is the dividend payout simply an assumed recurring action and we don't consider canceling it unless there is a severe liquidity issue? Read More