Quarter Ending | Qtr Sales | Qtr Profit | Range | UCL | LCL | 4 Qtr Avg | Prior 4Q avg | Rolling Profit | 12M Rolling P | Prior 12M P | Rolling 12M Diff |
2 yr Avg | 12M Rolling S | % Profit | % Profit Æ | % Sales Æ | Total Assets | Equity | |||
Mar-88 | 1,088,506 | 135,991 | 4 Qtr | Prior 4 Qtr | 12M Rolling | 12M Rolling | 12M Rolling | Trigger | |||||||||||||
Jun-88 | 1,186,679 | 35,583 | 100,408 | 503,413 | (225,061) | 1 | |||||||||||||||
Sep-88 | 1,918,309 | 590,776 | 555,193 | 503,413 | (225,061) | 2 | |||||||||||||||
Dec-88 | 1,653,967 | (124,548) | 715,324 | 503,413 | (225,061) | 159,451 | 3 | ||||||||||||||
Mar-89 | 1,225,162 | (126,130) | 1,582 | 503,413 | (225,061) | 93,920 | 375,681 | 4 | |||||||||||||
Jun-89 | 1,868,561 | 216,140 | 342,270 | 503,413 | (225,061) | 139,060 | 556,238 | 5 | |||||||||||||
Sep-89 | 2,365,931 | 356,445 | 140,305 | 503,413 | (225,061) | 80,477 | 321,907 | 6 | |||||||||||||
Dec-89 | 2,433,592 | 255,522 | 100,923 | 503,413 | (225,061) | 175,494 | 701,977 | 701,977 | 0 | 701,977 | 701,977 | 167,472 | 7,893,246 | 8.9% | 7 | ||||||
Mar-90 | 2,223,731 | 215,858 | 39,664 | 503,413 | (225,061) | 260,991 | 1,043,965 | 1,043,965 | 375,681 | 1,043,965 | 1,043,965 | 177,456 | 8,891,815 | 11.7% | 8 | ||||||
Jun-90 | 2,765,531 | 189,857 | 26,001 | 503,413 | (225,061) | 254,421 | 1,017,682 | 1,017,682 | 556,238 | 1,017,682 | 1,017,682 | 196,740 | 9,788,785 | 10.4% | 9 | ||||||
Sep-90 | 3,123,531 | 495,065 | 305,208 | 503,413 | (225,061) | 289,076 | 1,156,302 | 1,156,302 | 321,907 | 1,156,302 | 1,156,302 | 184,776 | 10,546,385 | 11.0% | 10 | ||||||
Dec-90 | 2,654,649 | (193,521) | 688,586 | 503,413 | (225,061) | 176,815 | 707,259 | 707,259 | 701,977 | 707,259 | 701,977 | 5,282 | 176,155 | 10,767,442 | 6.6% | 11 | |||||
Mar-91 | 2,651,840 | (443,065) | 249,544 | 503,413 | (225,061) | 12,084 | 48,336 | 48,336 | 1,043,965 | 48,336 | 1,043,965 | (995,629) | 136,538 | 11,195,551 | 0.4% | 12 | |||||
Jun-91 | 3,259,833 | 359,347 | 802,412 | 503,413 | (225,061) | 54,457 | 217,826 | 217,826 | 1,017,682 | 217,826 | 1,017,682 | (799,856) | 154,439 | 11,689,853 | 1.9% | 13 | |||||
Sep-91 | 3,315,364 | 379,693 | 20,346 | 503,413 | (225,061) | 25,614 | 0 | 102,454 | 1,156,302 | 102,454 | 1,156,302 | (1,053,848) | 157,345 | 11,881,686 | 0.9% | 14 | |||||
Dec-91 | 4,871,204 | 760,158 | 380,465 | 503,413 | (225,061) | 264,033 | 8,186,568 | 1,056,133 | 707,259 | 1,056,133 | 707,259 | 348,874 | 220,424 | 14,098,241 | 7.5% | 15 | |||||
Mar-92 | 3,334,861 | 33,229 | 726,929 | 503,413 | (225,061) | 383,107 | 11,521,429 | 1,532,427 | 48,336 | 1,532,427 | 48,336 | 1,484,091 | 197,595 | 14,781,262 | 10.4% | ||||||
Jun-92 | 4,309,523 | 299,216 | 265,987 | 503,413 | (225,061) | 368,074 | 15,830,952 | 1,472,296 | 217,826 | 1,472,296 | 217,826 | 1,254,470 | 211,265 | 15,830,952 | 9.3% | ||||||
Sep-92 | 4,444,792 | 429,465 | 130,249 | 503,413 | (225,061) | 380,517 | 1,522,068 | 1,522,068 | 102,454 | 1,522,068 | 102,454 | 1,419,614 | 203,065 | 16,960,380 | 9.0% | ||||||
Dec-92 | 3,938,491 | (739,910) | 1,169,375 | 503,413 | (225,061) | 5,500 | 22,000 | 22,000 | 1,056,133 | 22,000 | 1,056,133 | (1,034,133) | 134,767 | 16,027,667 | 0.1% | ||||||
Mar-93 | 3,788,469 | (59,606) | 680,304 | 503,413 | (225,061) | (17,709) | (70,835) | (70,835) | 1,532,427 | (70,835) | 1,532,427 | (1,603,262) | 182,699 | 16,481,275 | -0.4% | ||||||
Jun-93 | 4,321,709 | 395,990 | 455,596 | 503,413 | (225,061) | 6,485 | 25,939 | 25,939 | 1,472,296 | 25,939 | 1,472,296 | (1,446,357) | 187,279 | 16,493,461 | 0.2% | ||||||
Sep-93 | 3,784,818 | 13,451 | 382,539 | 503,413 | (225,061) | (97,519) | (390,074) | (390,074) | 1,522,068 | (390,074) | 1,522,068 | (1,912,142) | 141,499 | 15,833,487 | -2.5% | % sales Æ | |||||
Dec-93 | 3,816,774 | 280,478 | 267,027 | 503,413 | (225,061) | 157,579 | 630,314 | 630,314 | 22,000 | 630,314 | 22,000 | 608,314 | 81,539 | 15,711,771 | 4.0% | -2.0% | |||||
Mar-94 | 3,531,294 | (330,557) | 611,036 | 503,413 | (225,061) | 89,841 | 359,363 | 359,363 | (70,835) | 359,363 | (70,835) | 430,198 | 36,066 | 15,454,596 | 2.3% | -6.2% | |||||
Jun-94 | 4,665,266 | 130,843 | 461,401 | 503,413 | (225,061) | 23,554 | 94,216 | 94,216 | 25,939 | 94,216 | 25,939 | 68,276 | 15,019 | 15,798,153 | 0.6% | -4.2% | |||||
Sep-94 | 4,912,299 | 240,638 | 109,795 | 503,413 | (225,061) | 80,351 | 321,402 | 321,402 | (390,074) | 321,402 | (390,074) | 711,477 | (8,584) | 16,925,633 | 1.9% | 6.9% | |||||
Dec-94 | 5,448,567 | 411,019 | 170,381 | 503,413 | (225,061) | 112,986 | 451,943 | 451,943 | 630,314 | 451,943 | 630,314 | (178,371) | 135,282 | 18,557,426 | 2.4% | 18.1% | |||||
Mar-95 | 4,064,131 | (374,971) | 785,990 | 503,413 | (225,061) | 101,882 | 407,529 | 407,529 | 359,363 | 407,529 | 359,363 | 48,166 | 95,862 | 19,090,262 | 2.1% | 23.5% | |||||
Jun-95 | 4,196,856 | (437,288) | 62,317 | 503,413 | (225,061) | (40,150) | (160,602) | (160,602) | 94,216 | (160,602) | 94,216 | (254,818) | (8,298) | 18,621,852 | -0.9% | 17.9% | |||||
Sep-95 | 4,261,431 | 256,564 | 693,852 | 503,413 | (225,061) | (36,169) | (144,676) | (144,676) | 321,402 | (144,676) | 321,402 | (466,078) | 22,091 | 17,970,985 | -0.8% | 6.2% | |||||
Dec-95 | 3,978,441 | 6,596 | 249,968 | 503,413 | (225,061) | (137,275) | (549,099) | (549,099) | 451,943 | (549,099) | 451,943 | (1,001,042) | (12,145) | 16,500,858 | -3.3% | -11.1% | |||||
Mar-96 | 3,450,955 | (266,201) | 272,797 | 503,413 | (225,061) | (110,082) | (440,330) | (440,330) | 407,529 | (440,330) | 407,529 | (847,859) | (4,100) | 15,887,682 | -2.8% | -16.8% | |||||
Jun-96 | 4,197,027 | 120,127 | 386,329 | 503,413 | (225,061) | 29,271 | 117,086 | 117,086 | (160,602) | 117,086 | (160,602) | 277,687 | (5,440) | 15,887,853 | 0.7% | -14.7% | |||||
Sep-96 | 3,744,623 | (220,761) | 340,888 | 503,413 | (225,061) | (90,060) | (360,239) | (360,239) | (144,676) | (360,239) | (144,676) | (215,563) | (63,114) | 15,371,045 | -2.3% | -14.5% | |||||
Dec-96 | 3,556,260 | 46,971 | 267,732 | 503,413 | (225,061) | (79,966) | (319,864) | (319,864) | (549,099) | (319,864) | (549,099) | 229,236 | (108,620) | 14,948,864 | -2.1% | -9.4% | |||||
Mar-97 | 3,148,665 | 84,273 | 37,302 | 503,413 | (225,061) | 7,653 | 30,611 | 30,611 | (440,330) | 30,611 | (440,330) | 470,941 | (51,215) | 14,646,575 | 0.2% | -7.8% | |||||
Jun-97 | 2,888,091 | (329,441) | 413,714 | 503,413 | (225,061) | (104,739) | (418,957) | (418,957) | 117,086 | (418,957) | 117,086 | (536,043) | (37,734) | 13,337,639 | -3.1% | -16.1% | |||||
Sep-97 | 3,442,202 | 3,963 | 333,405 | 503,413 | (225,061) | (48,558) | (194,233) | (194,233) | (360,239) | (194,233) | (360,239) | 166,006 | (69,309) | 13,035,218 | -1.5% | -15.2% | |||||
Dec-97 | 3,626,255 | 277,447 | 273,483 | 503,413 | (225,061) | 9,061 | 36,242 | 36,242 | (319,864) | 36,242 | (319,864) | 356,106 | (35,453) | 13,105,213 | 0.3% | -12.3% | |||||
Mar-98 | 2,924,883 | (265,951) | 543,398 | 503,413 | (225,061) | (78,495) | (313,982) | (313,982) | 30,611 | (313,982) | 30,611 | (344,593) | (35,421) | 12,881,430 | -2.4% | -12.1% | |||||
Jun-98 | 2,877,578 | (280,733) | 14,782 | 503,413 | (225,061) | (66,318) | (265,274) | (265,274) | (418,957) | (265,274) | (418,957) | 153,684 | (85,529) | 12,870,917 | -2.1% | -3.5% | 1901940 | ||||
Sep-98 | 2,753,828 | (563,637) | 282,904 | 503,413 | (225,061) | (208,219) | (832,874) | (832,874) | (194,233) | (832,874) | (194,233) | (638,641) | (128,388) | 12,182,544 | -6.8% | -6.5% | |||||
Dec-98 | 3,069,151 | 265,361 | 828,998 | 725,092 | (225,061) | (211,240) | (844,960) | (844,960) | 36,242 | (844,960) | 36,242 | (881,202) | (101,090) | 11,625,440 | -7.3% | -11.3% | 8,349,207 | 1,595,144 | |||
Mar-99 | 2,939,415 | 406,512 | 141,151 | 725,092 | (225,061) | (43,124) | (172,497) | (172,497) | (313,982) | (172,497) | (313,982) | 141,485 | (60,810) | 11,639,972 | -1.5% | -9.6% | |||||
Jun-99 | 2,905,334 | 243,471 | 163,041 | 725,092 | (225,061) | 87,927 | 351,707 | 351,707 | (265,274) | 351,707 | (265,274) | 616,981 | 10,804 | 11,667,728 | 3.0% | -9.3% | 8,856,700 | 2,241,000 | |||
Sep-99 | 2,999,247 | 434,295 | 190,824 | 725,092 | (225,061) | 337,410 | 1,349,639 | 1,349,639 | (832,874) | 1,349,639 | (832,874) | 2,182,513 | 64,596 | 11,913,147 | 11.3% | -2.2% | |||||
Dec-99 | 3,095,458 | 37,627 | 396,668 | 725,092 | (225,061) | 280,476 | 1,121,905 | 1,121,905 | (844,960) | 1,121,905 | (844,960) | 1,966,865 | 34,618 | 11,939,454 | 9.4% | 2.7% | |||||
Mar-00 | 3,025,293 | 475,302 | 437,675 | 725,092 | (225,061) | 297,674 | 1,190,695 | 1,190,695 | (172,497) | 1,190,695 | (172,497) | 1,363,192 | 127,275 | 12,025,332 | 9.9% | 3.3% | |||||
Jun-00 | 3,561,467 | 680,932 | 205,630 | 725,092 | (225,061) | 407,039 | 1,628,156 | 1,628,156 | 351,707 | 1,628,156 | 351,707 | 1,276,449 | 247,483 | 12,681,465 | 12.8% | 363% | 8.7% | 9,250,000 | 3,695,000 | ||
Sep-00 | 3,558,997 | 550,458 | 130,474 | 725,092 | (225,061) | 436,080 | 1,744,319 | 1,744,319 | 1,349,639 | 1,744,319 | 1,349,639 | 394,680 | 386,745 | 13,241,215 | 13.2% | 29% | 11.1% | ||||
Dec-00 | 3,343,837 | 154,006 | 396,452 | 725,092 | (225,061) | 461,799 | 1,860,698 | 1,860,698 | 1,121,905 | 1,860,698 | 1,121,905 | 738,793 | 372,825 | 13,489,594 | 13.8% | 66% | 13.0% | ||||
Mar-01 | 3,457,649 | 594,709 | 440,703 | 725,092 | (225,061) | 433,058 | 1,980,105 | 1,980,105 | 1,190,695 | 1,980,105 | 1,190,695 | 789,410 | 396,350 | 13,921,950 | 14.2% | 66% | 15.8% | ||||
Jun-01 | 4,668,978 | 1,224,237 | 629,528 | 725,092 | (225,061) | 657,651 | 2,539,883 | 2,523,410 | 1,628,156 | 2,523,410 | 1,628,156 | 895,254 | 518,946 | 15,029,461 | 16.8% | 55% | 18.5% | 11,090,582 | 5,118,654 | ||
Sep-01 | 3,799,573 | 335,333 | 888,904 | 725,092 | 43,443 | (225,061) | 581,190 | 2,324,758 | 2,308,285 | 1,744,319 | ######### | 15% | |||||||||
Dec-01 | 4,243,822 | 468,965 | 133,632 | 725,092 | 43,443 | (225,061) | 2,623,244 | 1,860,698 | ######### | 16% | |||||||||||
Mar-02 | 4,000,000 | 700,000 | 2,728,535 | 1,980,105 | ######### | 16% | |||||||||||||||
Jun-02 | 5,000,000 | 1,000,000 | 2,504,298 | 2,523,410 | ######### | 15% | |||||||||||||||
Sep-02 | 5,000,000 | 800,000 | 2,968,965 | 2,308,285 | ######### | 16% | |||||||||||||||
Dec-02 | 5,000,000 | 400,000 | 2,900,000 | 2,623,244 | ######### | 15% | |||||||||||||||
-35374 | |||||||||||||||||||||
139,176 | 356,048 | 808,546 | (554,684) | -110384 | |||||||||||||||||
384,267 | 333,162 | -417879 | |||||||||||||||||||
109414 | |||||||||||||||||||||
147427 | |||||||||||||||||||||
Actual | Actual | Projected | Projected | 8520 | |||||||||||||||||
Based on 30% Income Tax | 30-Jun-01 | 30-Jun-01 | 31-Dec-01 | 31-Dec-02 | -306796 | ||||||||||||||||
Latest Q Total Return | 18.4% | 18.4% | -9.3% | 1349639 | |||||||||||||||||
Latest 12-month Total Return | 11.8% | 11.8% | 12% | 12% | -2.2% | 1121905 | |||||||||||||||
2.7% | 1190695 | ||||||||||||||||||||
1-yr Income Growth | 55% | 55% | 3.3% | 1628156 | |||||||||||||||||
2-yr Income Average Growth | 359% | 359% | 8.7% | 1744319 | |||||||||||||||||
3-yr Income Average Growth | NA | NA | 11.1% | 1860698 | |||||||||||||||||
Latest Annual Revenue(mil) | 15.0 | 15.0 | 13.0% | 1980105 | |||||||||||||||||
1-yr Revenue Growth | 18.5% | 18.5% | 15.8% | 2523410 | |||||||||||||||||
2-yr Avg Revenue Growth | 14.4% | 14.4% | 18.5% | 2672952 | |||||||||||||||||
3-yr Avg Revenue Growth | 5.6% | 5.6% | LINEST | 2.7% | 2818946 | ||||||||||||||||
1-yr Return on Assets | 19.1% | 19.1% | TREND | 2% | 2924237 | ||||||||||||||||
2-yr Avg Return on Assets | 16.4% | 16.4% | 2700000 | ||||||||||||||||||
1-yr Return on Equity | 47.8% | 47.8% | 2800000 | ||||||||||||||||||
2-yr Avg Return on Equity | 64.8% | 64.8% | 2900000 | ||||||||||||||||||
3-yr Avg Return on Equity | 55.2% | 55.2% | -0.0014778 | ||||||||||||||||||
Annual Oper. Cash Flow (mil) | 1163600.83 | ||||||||||||||||||||
1-yr Cash Flow Growth | |||||||||||||||||||||
FSB 2-yr Avg | 146% | 146% | |||||||||||||||||||
1 | Save both as web page abd as Workbook | ||||||||||||||||||||
2 | Copy workbook.htm to FTP without lock | ||||||||||||||||||||
3 | Modify all Charts | remove if (window.name!="frSheet") window.location.replace("::Current FINANCIAL WORKBK.htm"); else |
Use find and replace | ||||||||||||||||||
4 | find and replace .png with .gif | ||||||||||||||||||||
4 | Copy files in folder excluding sheets | ||||||||||||||||||||