« ALEA Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

editRe: Quick est. of Q2 new billings required*

By: DigSpace in ALEA | Recommend this post (0)
Mon, 04 Jun 12 6:37 PM | 70 view(s)
Boardmark this board | The Trust Matrix
Msg. 08304 of 54959
(This msg. is a reply to 08301 by tkc)

Jump:
Jump to board:
Jump to msg. #

Does anybody have a QtoQ list of new billings for Wave over the last year or two?, I never had that as a separate column and I am loath to parse through things.

edit, I had about $9m as required for new billings based on perceived ATM usage, didn't do any of the billings to AR push tkc did, just assumed one nets the last Qs push and its a wash.

I have more ATM than just the Apr11 and am factoring in more for a total of $3m ATM activity on the Q.

Mostly jibberish


- - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Quick est. of Q2 new billings required*
By: tkc
in ALEA
Mon, 04 Jun 12 6:07 PM
Msg. 08301 of 54959

to avoid add'l ATM use in the Q. Basic assumptions: 1) SG&A + R&D will decrease to $13.8M (no cash bonuses in Q2). 2) No change in A/P. 3)60% of new business will be rec'd in the Q, 40% will be A/R. 4) Gross margins will be 94% 5) $1.57M was rec'd via ATM on 4/11 and there has been no more.

$2.256M (COH, EOQ1) + 4.35 (A/R, EOQ1) + 1.57 (ATM) = $8.176M. Less 13.8 (SG&A + R&D) = 5.624 divided by 94% margins = $6M cash needed from Q2 new billings. If 60% of new billings is rec'd during the Q - Total new billings required is $10M. It is doable.

EDIT: didn't consider non cash expenses such as good will amortization, depreciation, share based comp. thus it new business req will be less.

Note: the $1.57M via ATM is from recollection, thus not sure it is correct. This was quick and loaded w/ assumptions so feel free to point out errors.


« ALEA Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next