{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Consolidated Financial Templates December 2004

Consolidated Financial Templates December 2004 - MPTC...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full Document Right Arrow Icon
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 3,107,978 8,321,218 9,057,393 9,412,694 10,277,329 11,286,444 14,995,277 15,425,860 16,642,929 18,809,013 - Gross profit 6,274,579 7,795,842 14,917,537 15,563,963 14,657,704 15,284,064 16,007,171 19,617,829 18,016,808 18,525,599 23,264,123 - Operating expense 2,266,639 2,855,813 5,260,193 4,318,857 3,851,415 4,050,184 4,316,770 5,126,464 5,035,084 5,165,566 6,363,359 - Selling expense 183,576 462,952 1,816,432 2,425,450 2,555,486 2,866,293 3,143,631 3,324,210 3,227,323 3,094,539 3,136,610 - General and administrative expense 904,500 1,176,789 2,036,906 2,678,918 2,525,884 2,635,619 2,553,122 2,871,036 3,407,248 3,184,620 3,741,004 - Bad debt expense 426,469 656,472 1,581,379 1,371,178 1,470,474 1,545,728 1,648,192 1,719,611 1,531,853 1,551,961 1,571,117 - EBITDA 2,493,395 2,643,816 4,222,627 4,769,560 4,254,446 4,186,240 4,345,456 6,576,508 4,815,300 5,528,913 8,452,032 - Depreciation expense 74,963 118,280 334,626 206,826 281,781 269,942 264,473 313,142 316,213 308,934 364,335 - Amortization expense 481,752 508,437 1,785,673 4,489,313 2,190,445 2,263,266 2,352,255 1,953,695 2,123,394 1,749,404 1,589,075 - Other charges - 3,605,113 - - - - - - - - - - Operating income 1,936,680 (1,588,014) 2,102,328 73,421 1,782,219 1,653,032 1,728,729 4,309,670 2,375,693 3,470,575 6,498,622 - Interest expense 250,391 265,380 547,985 456,769 475,331 459,990 419,578 1,007,888 1,178,694 1,176,920 1,569,479 - Interest income (31,852) (35,766) (19,733) (14,907) (12,255) (2,085) (2,816) (5,769) (2,789) (3,055) (6,287) - Other (income) expense - - - - - 2,013 8,896 872,178 - - 6,074,363 - Net income before income taxes 1,718,141 (1,817,628) 1,574,076 (368,440) 1,319,143 1,193,116 1,303,071 2,435,373 1,199,789 2,296,709 (1,138,934) - Income tax 650,277 726,331 929,223 (1,832,490) 500,000 505,882 527,250 978,157 477,691 908,073 (430,549) - Net income $1,067,864 $(2,543,958) $644,853 $1,464,050 $819,143 $687,234 $775,822 $1,457,216 $722,098 $1,388,636 $(708,385) $-
Background image of page 2
MPTC Holdings, Inc.
Background image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}