Posts by: WST Expert 1
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.
Re: R&D Expense and Capital
projecting R&D expenditure as % of total sales sounds legit to us. but how did you justify the % split you used for expense vs capitalize portion? that is pretty important. AND then don't forget, you need to expense the capitalized portion. keep in mind, if the company is at run-rate (doesn't ... Read More
projecting R&D expenditure as % of total sales sounds legit to us. but how did you justify the % split you used for expense vs capitalize portion? that is pretty important. AND then don't forget, you need to expense the capitalized portion. keep in mind, if the company is at run-rate (doesn't ... Read More
Re: Identifiable Intangible Assets
1) You the man! You win! Thank you for digging that up.
Forget naught that in addition to tax experts, you will have accountants on the job as well.
The short answer is that you need to know enough, but you d...
Read More
1) You the man! You win! Thank you for digging that up.

Re: How can Excel pull stock quotes?
You can use a variety of third party services, including Bloomberg, FactSet, etc via their built in Excel add-ins. Even an etrade or other retail brokerage account will be able to handle that (on a real-time basis too!) However, if you are looking for a completely non-paid service, Yahoo Finance s... Read More
You can use a variety of third party services, including Bloomberg, FactSet, etc via their built in Excel add-ins. Even an etrade or other retail brokerage account will be able to handle that (on a real-time basis too!) However, if you are looking for a completely non-paid service, Yahoo Finance s... 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... 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 unrealized gains and losses are not recognized on IS nor does it flow thru OCI.
Please let us know specific questions that you have so that we may better assist you. Read More