{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Consolidated Financial Templates December 2004 Values only

Consolidated Financial Templates December 2004 Values only...

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 $13,012,703 $11,012,655 $10,829,248 $12,406,985 $11,642,281 $11,322,477 $13,117,575 $14,202,606 $14,919,132 $15,464,536 $14,543,388 $14,767,247 $15,818,948 $160,047,078 $17,180,333 $165,814,200 $(1,361,385) $(5,767,122) (316,266) (231,530) (228,575) (346,114) (304,284) (277,704) (331,817) (721,624) (879,203) (912,312) (860,529) (822,521) (1,773,962) (7,690,175) (683,521) (4,704,686) (1,090,441) (2,985,489) Net revenue 12,696,438 10,781,125 10,600,672 12,060,871 11,337,997 11,044,773 12,785,758 13,480,982 14,039,929 14,552,224 13,682,859 13,944,726 14,044,986 152,356,903 16,496,812 161,109,514 (2,451,826) (8,752,611) Cost of revenue 5,573,967 4,927,134 4,909,560 5,589,165 5,429,430 5,196,452 6,017,047 6,179,068 6,195,544 6,434,401 6,219,484 6,022,442 7,578,165 70,697,891 7,292,954 71,894,618 285,211 $(1,196,727) Gross profit 7,122,470 5,853,991 5,691,112 6,471,706 5,908,567 5,848,321 6,768,712 7,301,914 7,844,385 8,117,823 7,463,375 7,922,284 6,466,821 81,659,012 9,203,858 89,214,896 (2,737,037) (7,555,884) Gross profit margin 56.1% 54.3% 53.7% 53.7% 52.1% 53.0% 52.9% 54.2% 55.9% 55.8% 54.5% 56.8% 46.0% 53.6% 55.8% 55.4% (9.7%) (1.8%) Operating expense 1,851,387 1,642,807 1,642,316 1,749,962 1,743,088 1,677,639 1,744,839 1,985,495 2,183,612 2,194,252 2,256,792 2,231,661 2,454,971 23,507,434 2,638,627 25,228,121 (183,655) (1,720,687) Selling expense 1,153,728 1,228,880 926,388 1,072,055 1,041,616 997,636 1,055,287 1,016,752 1,095,781 1,024,077 1,010,500 1,077,459 1,066,424 12,612,855 1,228,989 14,368,500 (162,565) (1,755,645) General and administrative expense 1,098,141 1,213,856 1,089,497 1,103,895 980,645 1,067,179 1,136,796 1,212,553 1,255,330 1,273,122 1,273,129 1,351,432 2,086,773 15,044,207 1,475,721 15,067,549 611,052 (23,342) Bad debt expense 623,543 495,329 478,097 558,427 500,811 479,987 571,163 505,920 526,941 538,256 496,992 535,473 1,469,996 7,157,392 596,184 6,442,326 873,812 715,066 EBITDA $2,395,671 $1,273,119 $1,554,815 $1,987,367 $1,642,406 $1,625,880 $2,260,627 $2,581,194 $2,782,722 $3,088,116 $2,425,963 $2,726,259 $(611,343) $23,337,124 $3,264,338 $28,108,400 $(3,875,681) $(4,771,275) EBITDA margin 18.9% 11.8% 14.7% 16.5% 14.5% 14.7% 17.7% 19.1% 19.8% 21.2% 17.7% 19.6% (4.4%) 15.3% 19.8% 17.4% -24.1% (2.1%) Active customers Respiratory 25,267 25,872 26,355 26,597 26,871 27,069 27,104 26,954 26,993 26,605 26,847 27,058 26,711 26,711 28,610 28,610 (1,899) (1,899) Diabetes 90,052 89,865 89,478 88,218 87,907 88,010 88,071 88,147 88,137 88,256 88,769 89,346 88,844 88,844 97,332 97,332 (8,488) (8,488) Ostomy 1,145 1,132 1,154 1,175 1,169 1,198 1,256 727 754 781 799 836 871 871 1,474 1,474 (603) (603) Urological 9,049 8,960 9,038 9,077 9,159 9,148 9,127 9,131 9,116 9,118 9,203 9,231 9,362 9,362 10,191 10,191 (829) (829) Total 125,513 125,829 126,025 125,067 125,106 125,425 125,558 124,959 125,000 124,760 125,618 126,471 125,788 125,788 137,607 137,607 (11,819) (11,819) Orders shipped Respiratory 13,703 13,206 12,056 13,942 13,034 12,081 13,413 12,180 13,070 12,643 11,741 13,156 13,858 154,380 15,304 170,768 (1,446) (16,388) Diabetes 29,144 22,515 22,885 27,366 23,908 22,722 27,489 24,851 25,999 27,140 24,923 26,173 28,699 304,670 29,794 316,948 (1,095) (12,278) Ostomy 674 656 700 722 710 725 805 402 351 424 426 479 462 6,862 845 9,361 (383) (2,499) Urological 6,873 6,614 6,484 6,837 6,718 6,555 6,837 6,776 6,708 6,876 6,813 6,731 6,921 80,870 7,886 86,535 (965) (5,665) Wound Care - - - - - - - 3,102 4,570 4,440 4,133 4,032 4,028 24,305 3,741 22,620 287 1,685 Total 50,394 42,991 42,125 48,867 44,370 42,083 48,544 47,311 50,698 51,523 48,036 50,571 53,968 571,087 57,570 606,232 (3,602) (35,145) Employees 709 703 699 700 713 710 710 835 844 835 840 833 830 830 941 941 (111) (111) Cash balance 2,771,041 2,339,583 1,553,284 5,295,108 2,557,527 2,265,591 2,822,083 3,320,631 4,043,856 7,107,893 2,994,967 5,411,098 6,611,315 6,611,315 $3,308,089 $3,308,089 $3,303,226 $3,303,226 Accounts receivable balance (net) 18,565,042 18,798,026 19,576,822 20,145,610 19,522,741 20,039,574 20,565,482 26,541,631 25,596,400 26,432,051 26,551,194 25,321,787 22,803,015 22,803,015 $27,380,846 $27,380,846 $(4,577,831) $(4,577,831) Inventory balance 4,336,833 5,055,352 3,776,308 4,443,163 5,461,987 6,129,318 5,861,238 6,838,168 7,125,708 6,778,131 6,026,746 5,620,106 5,528,263 5,528,263 $6,395,373 $6,395,373 $(867,110) $(867,110) Cash collections 11,026,079 10,029,875 9,423,330 11,098,812 11,012,879 10,047,353 11,633,553 12,623,307 14,443,062 13,151,658 13,280,465 14,630,925 14,202,587 145,577,806 Collection percentage 91.3% 97.5% 93.1% 96.5% 101.6% 95.1% 95.2% 97.3% 106.9% 93.8% 100.7% 109.1% 112.9% 100.3% Net days sales outstanding 47 49 52 54 52 52 53 57 54 56 57 54 49 49 48 48 1 1 Inventory days on hand 23 30 22 26 31 34 32 33 34 32 29 27 25 25 25 25 0 0 Capital expenditures $238,123 $169,457 $248,834 $153,383 $386,179 $94,195 $364,859 $257,090 $144,247 $108,078 $331,354 $339,046 $168,293 $2,765,015 $117,170 $2,500,750 51,123 264,265 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 $41,672,571 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 19,820,090 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 21,852,481 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 6,943,424 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 3,154,383 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 4,711,334 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 2,502,461 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 4,540,879 Depreciation expense 74,963 118,280 334,626 206,826 281,781 269,942 264,473 313,142 316,213 308,934 364,335 337,566 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 2,773,470 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 1,429,843 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 2,090,050 Interest income (31,852) (35,766) (19,733) (14,907) (12,255) (2,085) (2,816) (5,769) (2,789) (3,055) (6,287) (11,946) Other (income) expense - - - - - 2,013 8,896 872,178 - - 6,074,363 2,466,999 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) (3,115,260) 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) (955,215) 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) $(2,160,045)
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 ]}