Geri Financial Template January 2005

Geri Financial Template January 2005 - Gericare Providers,...

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: Gericare Providers, Inc. Denver Management Summary Jan-05 Actual Budget Actual vs. budget Workdays 21 20 23 22 20 22 21 22 21 21 21 21 21 YTD YTD Current month YTD Month Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Jan-05 Jan-05 Jan-05 Jan-05 Jan-05 Jan-05 Gross revenue $- $- $- $- $- $- $1,946,476 $2,699,344 $2,855,092 $2,511,479 $2,483,078 $2,421,822 $2,581,711 $2,581,711 $2,739,235 $2,739,235 $(157,524) $(157,524) Adjustments- - - - - - (389,062) (546,375) (584,703) (513,043) (515,177) (479,784) (592,351) (592,351) (630,024) (630,024) 37,673 37,673 Net revenue- - - - - - 1,557,414 2,152,969 2,270,389 1,998,436 1,967,901 1,942,038 1,989,360 1,989,360 2,109,211 2,109,211 (119,851) (119,851) Cost of revenue- - - - - - 395,365 557,826 586,921 497,917 505,966 472,695 562,385 562,385 563,801 563,801 (1,416) (1,416) Gross profit- - - - - - 1,162,049 1,595,143 1,683,468 1,500,519 1,461,935 1,469,343 1,426,975 1,426,975 1,545,410 1,545,410 (118,435) (118,435) Gross profit margin 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 74.6% 74.1% 74.1% 75.1% 74.3% 75.7% 71.7% 71.7% 73.3% 73.3% (1.5%) (1.5%) Operating expense- - - - - - 211,486 396,081 397,080 408,178 379,045 418,576 393,693 393,693 469,341 469,341 (75,648) (75,648) Selling expense- - - - - - 30,831 53,367 49,376 64,405 51,996 46,455 49,860 49,860 76,032 76,032 (26,172) (26,172) General and administrative expense- - - - - - 173,278 240,685 248,091 219,940 257,390 273,371 254,604 254,604 276,719 276,719 (22,115) (22,115) Bad debt expense- - - - - - - - - - - 228,000 - - - - - - EBITDA $- $- $- $- $- $- $746,454 $905,010 $988,921 $807,996 $773,504 $502,941 $728,818 $728,818 $723,318 $723,318 $5,500 $5,500 EBITDA margin 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 47.9% 42.0% 43.6% 40.4% 39.3% 25.9% 36.6% 36.6% 34.3% 34.3% 2.3% 2.3% Respiratory- - - - - - - - - - - - - - - - - - Diabetes- - - - - - - - - - - - - - - - - - Ostomy- - - - - - - - - - - - - - - - - - Urological- - - - - - - - - - - - - - - - - - Total- - - - - - - - - - - - - - - - - - Orders shipped Respiratory- - - - - - - - - - - - - - - - - - Diabetes- - - - - - - - - - - - - - - - - - Ostomy- - - - - - - - - - - - - - - - - - Urological- - - - - - - - - - - - - - - - - - Wound Care- - - - - - 2,829 4,215 4,180 3,878 3,777 3,741 3,797 3,797 3,797 3,797 - - Total- - - - - - 2,829 4,215 4,180 3,878 3,777 3,741 3,797 3,797 3,797 3,797 - - Employees- - - - - - 129 135 139 138 137 135 134 134 139 139 (5) (5) Cash balance $- $- $- $- $- $- $1,664,217 $1,777,275 $1,429,756 $1,221,943 $1,315,988 $958,089 $804,252 $804,252 Accounts receivable balance (net) $- $- $- $- $- $- $6,187,846 $5,941,208 $5,936,679 $5,786,111 $5,654,377 $4,583,367 $4,516,898 $4,516,898 Inventory balance $- $- $- $- $- $- $1,038,706 $1,016,740 $1,211,500 $1,213,859 $1,027,331 $1,053,709 $1,030,548 $1,030,548 Cash collections $- $- $- $- $- $- $1,009,281 $2,407,084 $2,274,703 $2,190,881 $2,104,009 $1,995,328 $2,063,083 $2,063,083 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 64.8% 64....
View Full Document

Page1 / 23

Geri Financial Template January 2005 - Gericare Providers,...

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