Consolidated Financial Templates December 2004 Values only

Consolidated Financial Templates December 2004 Values only...

Info iconThis preview shows pages 1–2. 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 $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...
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 Values only...

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

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