Posts by: Guest 1
Re: Conditional Formatting
Sorry, my question was not very clear. Maybe an example would help: If I have the following numbers in a row: 99 100 105 105 100 100 99 The I would want the formatting to be as follows: 99 100 [color=#00BF00:33jx3nvr]105[/color:33jx3nvr] 105 [color=#FF0000:33jx3nvr]100[/color:33jx3nvr]... Read More
Sorry, my question was not very clear. Maybe an example would help: If I have the following numbers in a row: 99 100 105 105 100 100 99 The I would want the formatting to be as follows: 99 100 [color=#00BF00:33jx3nvr]105[/color:33jx3nvr] 105 [color=#FF0000:33jx3nvr]100[/color:33jx3nvr]... Read More
Debt and Capex
According to you model CAPEX requirements are calculated in the Cash before Debt figure. LT Debt and the respective CPLTD stays unchanged and the mdoe, balances with the Revolver. This implies that all CAPEX requirements for the year that are not financed through CFO and postitive CFI or CFF (excl d... Read More
According to you model CAPEX requirements are calculated in the Cash before Debt figure. LT Debt and the respective CPLTD stays unchanged and the mdoe, balances with the Revolver. This implies that all CAPEX requirements for the year that are not financed through CFO and postitive CFI or CFF (excl d... Read More
RE: Valuation
Thnaks for your replies. I really appreciate it. However i have some comments 1) In my projections the Co has NOLs of c 20m. The first 2 years the company has negative EBIT hence cash taxes on EBIT do not apply. This is possible from the 3rd till the 5th year.That way i included the "lowering on ... Read More
Thnaks for your replies. I really appreciate it. However i have some comments 1) In my projections the Co has NOLs of c 20m. The first 2 years the company has negative EBIT hence cash taxes on EBIT do not apply. This is possible from the 3rd till the 5th year.That way i included the "lowering on ... Read More
Re: R&D Expense and Capital
Got it. Just did the projection. What I did was taking a % of total sales as R&D expenditure and split that into R&D expenses and the rest as cash outflow for investing activities and capitalize the cash outflow on the balance sheet. No surprise the operating profit margin dropped but I t... Read More
Got it. Just did the projection. What I did was taking a % of total sales as R&D expenditure and split that into R&D expenses and the rest as cash outflow for investing activities and capitalize the cash outflow on the balance sheet. No surprise the operating profit margin dropped but I t... Read More
Fixing #VALUE errors in my model
I built my own lbo model that links IS, BS, CF stmts and some other tabs. After changing around my Summary page my entire model has "VALUE" errors. I traced it back to the Interest line on the IS ==> which is linked to the changes in debt figures on the BS that have the same "VALUE" errors ==>... Read More
I built my own lbo model that links IS, BS, CF stmts and some other tabs. After changing around my Summary page my entire model has "VALUE" errors. I traced it back to the Interest line on the IS ==> which is linked to the changes in debt figures on the BS that have the same "VALUE" errors ==>... Read More
Re: Identifiable Intangible Assets
(1) I want to disagree with this. After looking through FAS142, it seems there is distinction between finite and infinite intangibles for GAAP, as such: "Opinion 17 presumed that goodwill and all other intangible assets were wasting assets (that is, finite lived), and thus the amounts assigned... Read More
(1) I want to disagree with this. After looking through FAS142, it seems there is distinction between finite and infinite intangibles for GAAP, as such: "Opinion 17 presumed that goodwill and all other intangible assets were wasting assets (that is, finite lived), and thus the amounts assigned... Read More
Re: Conditional Formatting
Thanks.
Thanks.
Merging Models into one Excel file
I built a monthly model for 2008 and for 2009, but I saved them as
separate files. How do I merge them into one model by adding each tab in
the 2009 model to the 2008 model? Thanks.
I built a monthly model for 2008 and for 2009, but I saved them as
separate files. How do I merge them into one model by adding each tab in
the 2009 model to the 2008 model? Thanks.
RE: Valuation
Which rate should we use (Cost of Debt or WACC) to discount the unsuded NOLs of the last projected year? With regards to my reference on the interest expense i think i have not explained properly my thought. A company enjoys 2 different tax shields, one arising from the NOLs (hence to be used ... Read More
Which rate should we use (Cost of Debt or WACC) to discount the unsuded NOLs of the last projected year? With regards to my reference on the interest expense i think i have not explained properly my thought. A company enjoys 2 different tax shields, one arising from the NOLs (hence to be used ... Read More
(1) If i understand you correctly, you're saying that the differentiation between infinite/finite-lived intangibles as strictly a Tax thing, and that all intangibles except Goodwill are amortized under GAAP. (2) I understand that I can simply turn off the switch for tax deductibility purposes. Howe... (1) If i understand you correctly, you're saying that the differentiation between infinite/finite-lived intangibles as strictly a Tax thing, and that all intangibles except Goodwill are amortized under GAAP.
(2) I understand that I can simply turn off the switch for tax deductibility purposes. However, as the model stands, the switch is on for Tax Deductible Identifiable Intangibles under Tax Accounting, with a note to the right per Hamilton that reads "FINITE lives, hence considered to be tax deductible". I guess to be more specific, I am wondering if there are any circumstances where. in a NON-section 338 stock deal, intangibles are amortized for tax accounting purposes? Read More