Posts by: WST Expert 1
Re: Off Balance Sheet Capital Commitment
Correct - this is a pro forma adjustment.
However, future depreciation and debt paydown should be incorporated in your projections (again, not in historicals).
Correct - this is a pro forma adjustment.
However, future depreciation and debt paydown should be incorporated in your projections (again, not in historicals).
Re: Identifiable Intangible Assets
1) FASB 141/142 However, tax deductibility is not a GAAP item, it is a tax-related item; as such you won't find info on it in the FASBs. Impairment tests are for Goodwill. Don't confuse book vs tax! 2) Tax accounting for stock deal falls under Section 368, Tax-Free Reorg. Intangibles are amortized ... Read More
1) FASB 141/142 However, tax deductibility is not a GAAP item, it is a tax-related item; as such you won't find info on it in the FASBs. Impairment tests are for Goodwill. Don't confuse book vs tax! 2) Tax accounting for stock deal falls under Section 368, Tax-Free Reorg. Intangibles are amortized ... Read More
Re: Software for Financial Analyst
Your package expired! One of our account representatives should have just gotten back to you or will very shortly. Accounting for held-to-maturity is under the marketable securities section of the Accounting Bootcamp. The short answer for HTM securities is that it is not marked-to-market and the u... Read More
Your package expired! One of our account representatives should have just gotten back to you or will very shortly. Accounting for held-to-maturity is under the marketable securities section of the Accounting Bootcamp. The short answer for HTM securities is that it is not marked-to-market and the u... Read More
Re: Conditional Formatting
Let's say that you put 5% as your hard coded threshold in cell A1. In cell A3 you have the comparison figure. and in cell B3 you have a label or whatever you want to be formatted based on the A3 value. (we might have reversed this from your question since it's hard to figure out left vs right the w... Read More
Let's say that you put 5% as your hard coded threshold in cell A1. In cell A3 you have the comparison figure. and in cell B3 you have a label or whatever you want to be formatted based on the A3 value. (we might have reversed this from your question since it's hard to figure out left vs right the w... Read More
Valuation
1) Depending on the size and how material the NOLs are, you would value the NOLs separately. Please see other topics Q&A for discussion on NOL treatment for valuation and DCF purposes. 2) ST Debt is always considered debt, regardless of the use of the debt. Please see the topic entitled Treat... Read More
1) Depending on the size and how material the NOLs are, you would value the NOLs separately. Please see other topics Q&A for discussion on NOL treatment for valuation and DCF purposes. 2) ST Debt is always considered debt, regardless of the use of the debt. Please see the topic entitled Treat... Read More
Re: R&D Expense and Capital
Based on the wording you provided and accounting rules (which are ever changing especially with IFRS differences), it seems as if the $8MM on the IS relates to current period R&D. Whereas the $12MM (presumably in CFI) is capitalized, of which, only a PORTION of that constitutes the $8MM expensed... Read More
Based on the wording you provided and accounting rules (which are ever changing especially with IFRS differences), it seems as if the $8MM on the IS relates to current period R&D. Whereas the $12MM (presumably in CFI) is capitalized, of which, only a PORTION of that constitutes the $8MM expensed... Read More
Re: Identifiable Intangible Assets
1) yes
2) deal-specific issues as advised by tax attorneys on each deal might occur
1) yes
2) deal-specific issues as advised by tax attorneys on each deal might occur
Re: Conditional Formatting
Same concept.
Alter your formula as follows.
Assume your numbers are in row 2 and A1 is the 5%:
=B2>=A2*(1+$A$1) format as green
=B2<A2*(1+$A$1) format as red
Think outside the box!
Same concept.
Alter your formula as follows.
Assume your numbers are in row 2 and A1 is the 5%:
=B2>=A2*(1+$A$1) format as green
=B2<A2*(1+$A$1) format as red
Think outside the box!
RE: Valuation
You would add back the PV of future unused NOL (not interest as you first indicated).
Calculate when the NOL shall be used in the future and discount that stream back. Note that in the USA you are limited by section 382 of the tax code.
You would add back the PV of future unused NOL (not interest as you first indicated).
Calculate when the NOL shall be used in the future and discount that stream back. Note that in the USA you are limited by section 382 of the tax code.
This sounds like a bug in Excel. We encounter this every now and then except the chart is black instead of gray. Unfortunately there is no remedy other than to recreate the chart or retrieve an earlier version that is still good.