RE: Deal Comps Analysis: Quick model formatting question
For the adjustments for normalizing, can we have a separate support page (in addition to commenting) with adjust EBIT, adjust EPS, and adjust net income columns? Or is this just out of the norm?

Explain the difference between Stock vs Asset deals.
Full Question:
What are the different treatment of Stock vs Asset sales and how does it affect the M&A model?

Re: Core Model Enhancements - Tax Schedule
Thank you for your quick reply.

Based on your answer, I have a further question--then why is this same line item (Amortization of Other Intangibles) added back in order to calculate Pre-NOL taxable income? G12=sum(G7:G11)

Regards,
Illana

RE: Deferred Maintenance Revenue treatment for TEV
Thank you for your response. The deferred maintenance liabilities relates to software maintenance contracts.  Normally the company receives cash upfront at the start of the 3 year maintenance contract and then has an obligation to perform on such contract over the 3 year period. These obligations ... Thank you for your response. The deferred maintenance liabilities relates to software maintenance contracts.  Normally the company receives cash upfront at the start of the 3 year maintenance contract and then has an obligation to perform on such contract over the 3 year period. These obligations are what the deferred maintenance liability account balance on the balance sheet are comprised of.  Each month, this liability is reduced as the company recognizes a portion of the maintenance contract revenues into income.
 
Much of the cash received from these contracts may have already been spent by the existing owner and therefore, the new owner of the business would still be liable to perform on these maintenance contracts even though the cash that was originally received for these contracts are no longer available to the new owner to cover the related expenses of performing on these contracts.
 
In addition, when the original maintenance contract is just about to expire, the company will invoice customers about 30 to 90 days in advance of the termination of the original contract.  The company will record the maintenance contract revenue on these renewal maintenance contracts upon invoicing and not when the maintenance contracts are accepted by the customer. 
 
I understand  that normally TEV + cash - debt = Equity Value. However in this case, how would you treat the deferred maintenance liability which is shown below the current liabilities but above the stockholder's equity section on the balance sheet considering 1) the fact that some of the cash that has been collected on the maintenance contracts is no longer at the company and 2) that some of the deferred liability represents future obligations that are booked prematurely because the company invoices 30 to 90 days in advance of the termination of the original contract and will record the maintenance contract revenue and liability on these renewal maintenance contracts upon invoicing and not when the maintenance contracts are accepted by the customer. 
 
Thank you in advance for your help!! Read More

Displaying Color Info
[b:2azaf549]Why I'm Asking[/b:2azaf549]: I have a list of dozens of different job positions I am trying to sort and classify. The conditional formatting of "Text begins with" "text ends with" and "Text Contains" is the best way I know to easily color code then sort the... [b:2azaf549]Why I'm Asking[/b:2azaf549]: I have a list of dozens of different job positions I am trying to sort and classify. The conditional formatting of "Text begins with" "text ends with" and "Text Contains" is the best way I know to easily color code then sort the positions.

(eg. "Lead Analyst", or "Sr. Analyst P/C Processing" might appear. I'd need to ID every entry of thousands that contains the word "analyst" and pull it out, then do the same with "Sr. Analyst").

I end up with dozens of colors I want to sort. The autosort has no easy way to sort multiple colors, so I've chosen all my colors based on the HSL spectrum. I keep my sat. and lum. constant and change the hue by 10 for each color. Then I filter the data and sort by color, choose custom sort, and choose the color.

[b:2azaf549]Issue:[/b:2azaf549] It displays the color in RGB info, which is worthless to me when trying to sort.

[b:2azaf549]Question:[/b:2azaf549] Can I change the default display from RGB to HSL? Or am I making this way too difficult and there's a super text function to ID these generic positions within longer non generic positions. Read More