| APPENDIX D | Hourly rate: | $4.00 | |||||||||||||||||||||||||||||
| THE SCRIM | THE SCRIM | ||||||||||||||||||||||||||||||
| Projected Statement of Earnings | Projected Statement of Earnings | ||||||||||||||||||||||||||||||
| Realistic | For the Year ended Dec 31, 2002 | Years 2-5 | Realistic | ||||||||||||||||||||||||||||
| 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | ||||||||||||||||||||
| Jan-00 | Feb-00 | Mar-00 | Apr-00 | May-00 | Jun-00 | Jul-00 | Aug-00 | Sep-00 | Oct-00 | Nov-00 | Dec-00 | Totals | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||
| Average Daily Machine Hours (MH) | 75 | 86 | 99 | 114 | 131 | 151 | 173 | 200 | 229 | 264 | 303 | 349 | 419 | 502 | 578 | 665 | Average Daily Machine Hours (MH) | ||||||||||||||
| Monthly MH | 2,325 [1] | 2,415 | 3,075 | 3,422 | 4,066 | 4,526 | 5,378 | 6,185 | 6,883 | 8,179 | 9,103 | 10,817 | 152,831.06 | 183,397.27 | 210,906.86 | 242,542.89 | Monthly MH | ||||||||||||||
| Total Client Base | 75 | 86 | 99 | 114 | 131 | 151 | 173 | 200 | 229 | 264 | 303 | 349 | 419 | 502 | 578 | 665 | Total Client Base | ||||||||||||||
| Revenues | Revenues | ||||||||||||||||||||||||||||||
| Computer Usage Revenue | $4,650.00 [2] | $9,660.00 | $12,299.25 | $13,687.88 | $16,265.76 | $18,102.21 | $21,511.47 | $24,738.18 | $27,531.21 | $32,716.25 | $36,410.02 | $43,267.24 | $260,839.46 | $611,324.23 | $733,589.08 | $843,627.44 | $970,171.55 | Computer Usage Revenue | |||||||||||||
| Club Advertising Revenue | 232.50 [3] | 241.50 | 307.48 | 342.20 | 406.64 | 452.56 | 537.79 | 618.45 | 688.28 | 817.91 | 910.25 | 1,081.68 | - | 15,283.11 | 18,339.73 | 21,090.69 | 24,254.29 | Club Advertising Revenue | |||||||||||||
| Website Advertising revenue | - [4] | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | Website Advertising revenue | |||||||||||||
| Vending Machines Revenue | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 3,000.00 [5] | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | Vending Machines Revenue | |||||||||||||
| Tournament revenue | 3,000.00 [6] | - | - | - | - | - | - | 3,000.00 | - | - | - | 6,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | 9,000.00 | Tournament revenue | ||||||||||||||
| Total Revenue | 8,132.50 | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | 276,476.70 | 638,607.34 | 830,189.54 | 1,079,246.40 | 1,403,020.32 | Total Revenue | |||||||||||||
| Cost of Sales | Cost of Sales | ||||||||||||||||||||||||||||||
| Domain registration / renual | 52.50 | - | - | - | - | - | - | - | - | - | - | - | 52.50 | 52.50 | 52.50 | 52.50 | 52.50 | Domain registration / renual | |||||||||||||
| Interior Design Expense | 35,000.00 [7] | - | - | - | - | - | - | - | - | - | - | 35,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | Interior Design Expense | ||||||||||||||
| Web development & Hosting expense | 1,000.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 1,550.00 | 1,000.00 | 1,150.00 | 1,322.50 | 1,520.88 | Web development & Hosting expense | |||||||||||||
| Computer equipment purchases & upgrades | 60,000.00 [8] | - | - | - | - | - | - | - | - | - | - | - | 60,000.00 | 30,000.00 | 15,000.00 | 15,000.00 | 15,000.00 | Computer equipment purchases & upgrades | |||||||||||||
| Computer software purchases / licenses | 8,000.00 [9] | - | - | - | - | - | - | - | - | - | - | - | 8,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | Computer software purchases / licenses | |||||||||||||
| Wages expense | 4,000.00 [10] | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 48,000.00 | 52,800.00 [11] | 77,280.00 [12] | 104,208.00 | 133,828.80 | Wages expense | |||||||||||||
| Promotion expense | 1,000.00 [13] | 300.00 | 300.00 | 300.00 | 300.00 | 500.00 | 300.00 | 300.00 | 1,000.00 | 300.00 | 300.00 | 300.00 | 5,200.00 | 7,280.00 [14] | 10,192.00 | 14,268.80 | 19,976.32 | Promotion expense | |||||||||||||
| Total Cost of Sales | ###### | 4,350.00 | 4,350.00 | 4,350.00 | 4,350.00 | 4,550.00 | 4,350.00 | 4,350.00 | 5,050.00 | 4,350.00 | 4,350.00 | 4,350.00 | 157,802.50 | 100,132.50 | 112,674.50 | 143,851.80 | 179,378.50 | Total Cost of Sales | |||||||||||||
| Gross Profit | ###### | 5,801.50 | 8,506.73 | 9,930.07 | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | 118,674.20 | 538,474.84 | 717,515.04 | 935,394.60 | 1,223,641.82 | Gross Profit | |||||||||||||
| Operating Expenses | Operating Expenses | ||||||||||||||||||||||||||||||
| Bank charges expense | 150.00 [15] | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 480.00 | 576.00 | 691.20 | 829.44 | 995.33 | Bank charges expense | |||||||||||||
| Interest expense | 1,500.00 [16] | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 1,500.00 | 18,000.00 | - | - | - | - | Interest expense | |||||||||||||
| Telephone expense | 200.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 30.00 | 530.00 | 583.00 [17] | 641.30 | 705.43 | 775.97 | Telephone expense | |||||||||||||
| Advertising expense | 1,000.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 6,500.00 | 9,100.00 [18] | 12,740.00 | 17,836.00 | 24,970.40 | Advertising expense | |||||||||||||
| Cable internet expense | 500.00 [19] | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 500.00 | 550.00 | 605.00 | 665.50 | 732.05 | Cable internet expense | |||||||||||||
| Office supplies expense | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 55.00 | 660.00 | 792.00 [20] | 950.40 | 1,092.96 | 1,256.90 | Office supplies expense | |||||||||||||
| Rent expense | 3,000.00 [21] | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 36,000.00 | 39,600.00 [22] | 43,560.00 | 47,916.00 | 52,707.60 | Rent expense | |||||||||||||
| Utilities expense | 2,600.00 [23] | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 2,600.00 | 31,200.00 | 34,320.00 | 37,752.00 | 41,527.20 | 45,679.92 | Utilities expense | |||||||||||||
| Insurance expense | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 12,000.00 | 15,000.00 [24] | 16,500.00 | 18,150.00 | 19,965.00 | Insurance expense | |||||||||||||
| Total Operating Expenses | ###### | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 9,215.00 | 111,370.00 | 100,521.00 | 113,439.90 | 128,722.53 | 147,083.18 | Total Operating Expenses | |||||||||||||
| Administrative Expenses | Administrative Expenses | ||||||||||||||||||||||||||||||
| Licenses and registration fees | 1,000.00 [25] | - | - | - | - | - | - | - | - | - | - | - | 1,000.00 | - | - | - | - | Licenses and registration fees | |||||||||||||
| Accounting and legal fees | 500.00 [26] | - | - | - | - | - | - | - | - | - | - | 500.00 | 1,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | Accounting and legal fees | |||||||||||||
| Management salary | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 57,600.00 | 69,120.00 [27] | 82,944.00 | 99,532.80 | 119,439.36 | Management salary | |||||||||||||
| Total Administrative Expenses | 6,300.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 4,800.00 | 5,300.00 | 59,600.00 | 72,120.00 | 85,944.00 | 102,532.80 | 122,439.36 | Total Administrative Expenses | |||||||||||||
| Net Income | ###### | (8,213.50) | (5,508.27) | (4,084.93) | (1,442.60) | 239.77 | 3,934.25 | 7,241.64 | ###### | ###### | ###### | ###### | (52,295.80) | 365,833.84 | 518,131.14 | 704,139.27 | 954,119.29 | Net Income | |||||||||||||
| THE SCRIM | THE SCRIM | ||||||||||||||||||||||||||||||
| Cash Flow Forecast | Cash Flow Forecast | ||||||||||||||||||||||||||||||
| For the Year ended Dec 31, 2002 | Years 2-5 | ||||||||||||||||||||||||||||||
| Jan-00 | Feb-00 | Mar-00 | Apr-00 | May-00 | Jun-00 | Jul-00 | Aug-00 | Sep-00 | Oct-00 | Nov-00 | Dec-00 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||
| Minimum Cash Balance Requirement | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | Minimum Cash Balance Requirement | ||||||||||||||
| Cash Provided from Operations | Cash Provided from Operations | ||||||||||||||||||||||||||||||
| Computer Usage Revenue | 4,650.00 | 9,660.00 | 12,299.25 | 13,687.88 | 16,265.76 | 18,102.21 | 21,511.47 | 24,738.18 | 27,531.21 | 32,716.25 | 36,410.02 | 43,267.24 | 611,324.23 | 733,589.08 | 843,627.44 | 970,171.55 | Computer Usage Revenue | ||||||||||||||
| Club Advertising Revenue | 232.50 | 241.50 | 307.48 | 342.20 | 406.64 | 452.56 | 537.79 | 618.45 | 688.28 | 817.91 | 910.25 | 1,081.68 | 15,283.11 | 18,339.73 | 21,090.69 | 24,254.29 | Club Advertising Revenue | ||||||||||||||
| Website Advertising revenue | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | Website Advertising revenue | ||||||||||||||
| Vending Machines Revenue | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 250.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | Vending Machines Revenue | ||||||||||||||
| Tournament revenue | 3,000.00 | - | - | - | - | - | - | - | 3,000.00 | - | - | - | Tournament revenue | ||||||||||||||||||
| A. Total Cash Onhand | 8,132.50 | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | ###### | 638,607.34 | 830,189.54 | 1,079,246.40 | 1,403,020.32 | A. Total Cash Onhand | ||||||||||||||
| Domain registration | 52.50 | - | - | - | - | - | - | - | - | - | - | - | 52.50 | 52.50 | 52.50 | 52.50 | Domain registration | ||||||||||||||
| Interior Design Expense | 35,000.00 | - | - | - | - | - | - | - | - | - | - | - | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | Interior Design Expense | ||||||||||||||
| Web Hosting and Development Expense | 1,000.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 50.00 | 1,000.00 | 1,150.00 | 1,322.50 | 1,520.88 | Web Hosting and Development Expense | ||||||||||||||
| Wages expense | 4,000.00 | 4,000.00 | |||||||||||||||||||||||||||||