Consolidated Financial Templates December 2004

Consolidated Financial Templates December 2004 - MPTC...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: MPTC Holdings, Inc. Consolidated Management Summary Dec-04 Actual Budget Actual vs. budget Workdays 22 21 20 23 22 20 22 21 22 21 21 21 21 YTD Current month YTD Current month YTD Month Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Dec-04 Dec-04 Dec-04 Dec-04 Dec-04 Gross revenue $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- - - - - - - - - - - - - - - - - - - Net revenue 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 Cost of revenue- - - - - - - - - - - - - - - - - $- Gross profit 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 Gross profit margin #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Operating expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Selling expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 General and administrative expense 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Bad debt expense- - - - - - - - - - - - - - - - - - EBITDA $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- $- EBITDA margin #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Active customers Respiratory 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Diabetes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ostomy 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 0 0 Urological- - - - - - - - - - - - - - - - - - Total- - - - - - - - - - - - - - - - - - Orders shipped Respiratory 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Diabetes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ostomy 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - 0 0 Urological 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Wound Care- - - - - - - - - - - - - - - - - - Total- - - - - - - - - - - - - - - - - - Employees 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cash balance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,308,089 $3,308,089 $(3,308,089) $(3,308,089) Accounts receivable balance (net) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $27,380,846 $27,380,846 $(27,380,846) $(27,380,846) Inventory balance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $6,395,373 $6,395,373 $(6,395,373) $(6,395,373) Cash collections 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Collection percentage #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net days sales outstanding 47 49 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!- - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! 48 48 #DIV/0! #DIV/0! Inventory days on hand 23 30 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!- - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! 25 25 #DIV/0! #DIV/0! Capital expenditures $- $- $- $- $- $- $- $- $- $- $- $- $- $- $117,170 $2,500,750 (117,170) (2,500,750) Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 1A Adjustments MPTC Holdings, Inc. Consolidated Operating Margin Analysis Quarter ended December -04 Actual Year 2002 2003 2004 Quarter Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Net revenue $8,428,047 $10,903,820 $23,238,755 $24,621,356 $24,070,398 $25,561,393 $27,293,615 $34,613,106 $33,442,668 $35,168,528 $42,073,136 $- Costs and expenses: Cost of revenue 2,153,468...
View Full Document

This note was uploaded on 04/08/2010 for the course BUSINESS 4456 taught by Professor Blackwell during the Spring '10 term at West Liberty.

Page1 / 32

Consolidated Financial Templates December 2004 - MPTC...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online