CS Investment Database

Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:40 PM Total Q1 2000 Q2 2000 Q3 2000 Q4 2000 Q1 2001 FY 2000 Summary Pro-Forma Financials Q2 2001 Q3 2001 Q4 2001 Total FY 2001 Pct Rev Pct Rev Pct Cost Revenues Cost of Goods Sold Gross Margin Selling Expenses Marketing Research & Development General and Administrative 92,500 152,188 362,018 654,547 1,261,252 100% 128,004 160,506 215,509 231,760 735,779 58% 146,509 422,787 525,473 42% (35,504) (8,319) 15% Pct Cost 1,237,199 1,968,768 2,888,734 3,764,768 9,859,469 100% 378,516 416,018 413,516 432,267 1,640,317 17% 858,683 1,552,750 2,475,218 3,332,501 8,219,152 83% 213,500 315,500 491,000 611,042 1,631,042 129% 33% 798,951 958,334 1,090,529 1,222,607 4,070,422 41% 33% 130,000 300,000 480,000 480,000 1,390,000 110% 28% 737,500 737,500 937,500 962,500 3,375,000 34% 28% 115,000 135,000 155,000 155,000 560,000 44% 11% 385,000 410,000 587,500 587,500 1,970,000 20% 16% 147,500 147,500 167,500 167,500 630,000 50% 13% 245,000 265,000 337,500 337,500 1,185,000 12% 10% (641,504) (906,319) (818,085) (477,810) 222,393 (2,381,270) -24% 100% Net Income Before Taxes 13% (1,146,991) (990,755) (3,685,569) -292% 100% (1,307,768) Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:40 PM Total FY 2002 Total FY 2003 Summary Pro-Forma Financials Total FY 2004 Pct Rev Pct Rev Pct Cost Revenues Cost of Goods Sold Gross Margin Selling Expenses Marketing Research & Development General and Administrative 28,777,772 100% 4,106,598 14% 24,671,174 86% 5,801,081 20% 6,167,500 21% 3,360,000 2,752,500 100% 6,952,606 12% 50,495,144 88% 26% 7,202,626 13% 16% 7,709,248 8% 11% 28% 14,792,500 26% 34% 27,567,500 27% 38% 12% 15% 10,790,000 19% 25% 20,232,500 20% 28% 10% 12% 4,122,500 7% 9% 6,347,500 6% 19% 100% Net Income Before Taxes 6,590,093 Pct Cost 57,447,750 23% 16% 100,507,520 100% 11,460,104 11% 89,047,416 89% 100% 13,587,518 24% 16% 9% 100% 27,190,668 27% Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM < ------- KEY INPUTS, FOR INDICATED PERIODS ------ > 2002 Start 2000 Q 1&2 2000 Q 3&4 2001 Q 1&2 2001 Q 3&4 2003 2004 Notes Summary Pro-Forma Financials Revenues Cost of Goods Sold (<--see subsequent pages for detail) Gross Margin Selling Expenses Marketing Research & Development General and Administrative Net Income Before Taxes These pro-forma financial statements are for the use of Collaborative Structures, Inc. and potential investors. Please use in conjunction with Investment Summary These statements project the growth curve of the Company as a function of sales force size, success of the sales force, average selling price, cost of goods sold, and duration of projects. These are the key sensitivities. The presentation is organized as follows: Summary Financial Information Sales Build: The penetrations and assumptions leading to booking new work Cost of Goods Sold Selling Expenses (including input assumptions for success of sales staff) Marketing Expenses (success of sales relates to effectiveness of marketing effort - not quantified here) Research and Development Expenses General and Adminstrative Expenses These pro-formas indicate one possible strategy. They can serve as a baseline for discussion of other strategies. In projections: Box = input assumptions Box = key areas of sensitivity Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM < ------- KEY INPUTS, FOR INDICATED PERIODS ------ > Start 2000 Q 1&2 2000 Q 3&4 2001 Q 1&2 2001 Q 3&4 2002 2003 2004 Notes Sales Build ***** Sales Force Sales Staff - Headcount < --------------------------- Varies by Quarter 0.150 3 0.150 3 0.200 5 0.250 5 0.330 8 0.500 8 0.750 8 100.0% 0.0% 10.0% 110.0% 10% 100.0% 5.0% 15.0% 120.0% 10% 100.0% 10.0% 30.0% 140.0% 10% 100.0% 15.0% 35.0% 150.0% 10% 100.0% 50.0% 50.0% 200.0% 10% 100.0% 75.0% 75.0% 250.0% 10% 100.0% 100.0% 100.0% 300.0% 10% Value/Qtr 100,000 50,000 12,500 30,000 Value/Qtr 100,000 50,000 12,500 30,000 Value/Qtr 100,000 50,000 12,500 30,000 Value/Qtr 100,000 50,000 12,500 30,000 Value/Qtr 100,000 50,000 12,500 30,000 Value/Qtr 100,000 50,000 12,500 30,000 Value/Qtr 100,000 50,000 12,500 30,000 Recurring Revenue Sources Enterprise Sales to Repeat Owners New Sales: Via Direct Sales Via Insurance Company Via Construction Manager Subtotal New Lost Accounts: Enterprise Account Revenue Distribution Large (percent of accts; rev per qtr) 5% Medium 35% Small 60% Total 100% Revenues from One-Time Projects New Projects Sold Projects Concluded Net Single Projects Underway New Bookings - One time projects Backlog worked off Ending Backlog Total All new FirstLine bookings Assumption of sales success per sales staffer (new direct accts OR new "channel" accts) Assumption of direct sales success per sales staffer Assumes that percent of direct sales declines Assumes that sales via insurance companies increase Assumes that sales via construction managers increase Assumes that some % of enterprise accounts are lost per quarter (rounded up) Starting 0 Total Enterprise Accounts New Enterprise Bookings ASSUMPTIONS ------------------------------------------------------- > ******** 4 Assumes a mix in the size of enterprise accounts. Assumes stated value per account. ((This is an approximation of how enterprise account values might be distributed)) Formula takes an average of the account mix for projection purposes Enterprise bookings counted for "x" quarters End of 99 40 Quarters Qtrs 8 25,000 8 500,000 Avg Price 25,000 8 Avg Price 23,000 Avg Price 23,000 Avg Price 20,000 Avg Price 20,000 Avg Price 15,000 Assumed average selling price of FirstLine only for one-time projects Assumes that projects take 8 quarters on average to work off backlog (24 months) Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM < ------- KEY INPUTS, FOR INDICATED PERIODS ------ > Start 2000 Q 1&2 2000 Q 3&4 2001 Q 1&2 2001 Q 3&4 2002 Revenue Streams FirstLine Enterprise Single Project Product Line Extensions Portfolio Product (Info - Network) Enterprise Single Firm Insurance Product Enterprise People Consulting & Services Enterprise Single Project Rentable Applications Enterprise Sum of Product Extensions Gross Revenues Expenses Cost of Goods Sold Engineering Staff Base Comp (loaded) Support Staff Base Comp (loaded) Consulting Expenses Amortize Hardware, Software Internet Fees Hosting Fees Total Cost of Goods Sold 2003 2004 As Pct of FirstLine rev 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 0% 0% 5% 5% 20% 10% 25% 10% 30% 12% 35% 12% 40% 15% Portfolio products add assumed percentage to FirstLine sales 0% 5% 20% 25% 25% 33% 40% Insurance products purchased by some teams add assumed percentage to FL sales 0% 10% 10% 20% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% Consulting and collaboration coaching add assumed percentage to FL sales 0% 10% 0% 45% 5% 105% 10% 120% 15% 132% 20% 150% 40% 185% Varies by quarter Avg Annual 90,000 Projects per Staff 10 Avg Annual 65,000 Annual 30,000 Annual 100,000 Annual 24,000 Annual 48,000 90,000 10 65,000 30,000 100,000 24,000 48,000 100,000 12 75,000 30,000 100,000 24,000 60,000 100,000 15 75,000 30,000 100,000 24,000 200,000 110,000 18 85,000 100,000 500,000 24,000 1,250,000 110,000 20 85,000 1,000,000 1,000,000 50,000 2,500,000 110,000 25 85,000 2,000,000 2,000,000 100,000 5,000,000 Gross Margin Selling Expenses Prior Commissions Paid/Expensed Over "x" quarters New FirstLine Commissions BookedRate Commissions Backlog Staff (from Headcount, above) Base Comp (loaded) Expenses Total Selling Expenses Notes Avg Per pers per qtr 6 15% 90,000 8,000 6 15% 90,000 8,000 6 15% 90,000 8,000 6 15% 90,000 8,000 6 15% 90,000 8,000 6 15% 90,000 8,000 6 15% 90,000 8,000 FirstLine revenues are 100% of the sales build above Rentable Applications from FirstLine platform add assumed percentage to FL sales Function of new projects & ent accts per staffer - increases with efficiency Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Marketing Expenses Staff Base Comp (loaded) Promotion Public Relations Advertising Trade Shows Direct Mail Consulting Collateral Total Marketing Expenses < ------- KEY INPUTS, FOR INDICATED PERIODS ------ > 2002 Start 2000 Q 1&2 2000 Q 3&4 2001 Q 1&2 2001 Q 3&4 Annual Annual Varies by Quarter Avg 80,000 80,000 100,000 100,000 110,000 Annual Annual Annual Annual Annual Annual 2003 2004 110,000 110,000 120,000 200,000 200,000 200,000 60,000 100,000 120,000 500,000 200,000 400,000 100,000 200,000 400,000 750,000 400,000 500,000 100,000 300,000 400,000 1,000,000 400,000 500,000 100,000 750,000 400,000 1,500,000 500,000 1,000,000 500,000 1,250,000 500,000 5,000,000 1,000,000 1,000,000 1,000,000 5,000,000 1,000,000 10,000,000 2,000,000 1,000,000 2,000,000 10,000,000 Staff Base Comp (loaded) Hardware Amortize Software Amortize Consulting & Contracting Expense Licensing & Other Total R & D Expenses Varies by quarter Avg 110,000 Annual 40,000 Annual 40,000 Annual 100,000 Annual 40,000 110,000 40,000 40,000 100,000 40,000 120,000 200,000 40,000 200,000 500,000 120,000 200,000 100,000 500,000 750,000 120,000 250,000 150,000 500,000 1,250,000 120,000 500,000 250,000 3,500,000 5,000,000 120,000 1,000,000 500,000 7,000,000 10,000,000 Staff Base Comp (loaded) Legal & Audit Occupancy & Utilities (all depts) Consulting Expense Other Total G & A Expenses Varies by quarter Avg 100,000 Annual 60,000 Annual 120,000 Annual 60,000 Annual 30,000 100,000 60,000 120,000 60,000 30,000 125,000 200,000 200,000 150,000 30,000 125,000 200,000 200,000 150,000 100,000 150,000 1,000,000 250,000 150,000 500,000 150,000 1,500,000 300,000 250,000 1,000,000 150,000 2,000,000 500,000 500,000 2,000,000 125 30 175 35 200 40 225 45 250 50 300 55 350 60 Notes R&D G&A Net Income Headcount Enterprise Members Single Project Members Total Project Members Estimate for analysis - avg members per enterprise account Estimate for analysis - avg members per single project Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Total Q1 2000 Q2 2000 Q3 2000 Q4 2000 Q1 2001 FY 2000 Summary Pro-Forma Financials Q2 2001 Q3 2001 Q4 2001 Total FY 2001 Pct Rev Pct Rev Pct Cost Revenues Cost of Goods Sold Gross Margin Selling Expenses Marketing Research & Development General and Administrative 92,500 152,188 362,018 654,547 1,261,252 100% 128,004 160,506 215,509 231,760 735,779 58% 146,509 422,787 525,473 42% (35,504) (8,319) 15% Pct Cost 1,237,199 1,968,768 2,888,734 3,764,768 9,859,469 100% 378,516 416,018 413,516 432,267 1,640,317 17% 858,683 1,552,750 2,475,218 3,332,501 8,219,152 83% 213,500 315,500 491,000 611,042 1,631,042 129% 33% 798,951 958,334 1,090,529 1,222,607 4,070,422 41% 33% 130,000 300,000 480,000 480,000 1,390,000 110% 28% 737,500 737,500 937,500 962,500 3,375,000 34% 28% 115,000 135,000 155,000 155,000 560,000 44% 11% 385,000 410,000 587,500 587,500 1,970,000 20% 16% 147,500 147,500 167,500 167,500 630,000 50% 13% 245,000 265,000 337,500 337,500 1,185,000 12% 10% (641,504) (906,319) (818,085) (477,810) 222,393 (2,381,270) -24% 100% Net Income Before Taxes 13% (1,146,991) (990,755) (3,685,569) -292% 100% (1,307,768) Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Total Q1 2000 Q2 2000 Q3 2000 Q4 2000 FY 2000 Q1 2001 Q2 2001 Q3 2001 Q4 2001 Total FY 2001 Sales Build *** < --- PROJECTIONS ---- > *** Sales Force Sales Staff - Headcount 7 10 Assumption of sales success per sales staffer (new direct accts OR new "channel" accts) Recurring Revenue Sources Enterprise Sales to Repeat Owners New Sales: Via Direct Sales Via Insurance Company Via Construction Manager Subtotal New Lost Accounts: Total Enterprise Accounts Enterprise Account Revenue Distribution Large (percent of accts; rev per qtr) Medium Small Total New Enterprise Bookings Revenues from One-Time Projects New Projects Sold Projects Concluded Net Single Projects Underway New Bookings - One time projects Backlog worked off Ending Backlog Total All new FirstLine bookings 15 18 23 26 28 30 5 0 1 6 1 5 1 2 8 1 7 1 2 10 2 8 1 3 12 3 1 0 0 1 0 2 0 0 2 0 2 0 0 2 0 3 0 1 4 0 1 2 4 8 8 13 20 28 37 37 5,000 17,500 7,500 30,000 10,000 35,000 15,000 60,000 20,000 70,000 30,000 120,000 40,000 140,000 60,000 240,000 75,000 262,500 112,500 450,000 65,000 227,500 97,500 390,000 100,000 350,000 150,000 600,000 140,000 490,000 210,000 840,000 185,000 647,500 277,500 1,110,000 490,000 1,715,000 735,000 2,940,000 120,000 240,000 240,000 480,000 1,080,000 720,000 960,000 1,200,000 1,440,000 4,320,000 12 2 50 300,000 62,500 737,500 30 4 76 750,000 92,188 1,395,313 45 10 111 1,125,000 174,414 2,345,898 54 14 151 1,350,000 293,237 3,402,661 141 115 19 247 2,645,000 425,333 5,622,328 130 31 346 2,990,000 702,791 7,909,537 140 43 443 3,220,000 988,692 10,140,845 150 55 538 3,450,000 1,267,606 12,323,240 535 420,000 990,000 1,365,000 1,830,000 3,365,000 3,950,000 4,420,000 4,890,000 3,525,000 622,339 4,605,000 12,305,000 3,384,422 16,625,000 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Total Q1 2000 Revenue Streams FirstLine Enterprise Single Project Product Line Extensions Portfolio Product (Info - Network) Enterprise Single Firm Insurance Product Enterprise People Consulting & Services Enterprise Single Project Rentable Applications Enterprise Sum of Product Extensions Gross Revenues Expenses Cost of Goods Sold Engineering Staff Base Comp (loaded) Support Staff Base Comp (loaded) Consulting Expenses Amortize Hardware, Software Internet Fees Hosting Fees Total Cost of Goods Sold Gross Margin Q2 2000 Q3 2000 Q4 2000 Q1 2001 FY 2000 Q2 2001 Q3 2001 Q4 2001 Total FY 2001 30,000 62,500 60,000 92,188 120,000 174,414 240,000 293,237 450,000 622,339 36% 49% 390,000 425,333 600,000 702,791 840,000 988,692 1,110,000 1,267,606 2,940,000 3,384,422 30% 34% 0 0 0 0 6,000 8,721 12,000 14,662 18,000 23,383 1% 2% 78,000 42,533 120,000 70,279 210,000 98,869 277,500 126,761 685,500 338,442 7% 3% 0 0 6,000 12,000 18,000 1% 78,000 120,000 210,000 277,500 685,500 7% 0 0 0 0 12,000 34,883 24,000 58,647 36,000 93,530 3% 7% 97,500 106,333 150,000 175,698 210,000 247,173 277,500 316,901 735,000 846,105 7% 9% 0 0 0 0 0 0% 19,500 30,000 84,000 111,000 244,500 2% 92,500 152,188 362,018 654,547 1,261,252 100% 1,237,199 1,968,768 2,888,734 3,764,768 9,859,469 100% 2 45,000 2 32,500 7,500 25,000 6,000 12,000 128,004 2 45,000 4 65,000 7,500 25,000 6,000 12,000 160,506 3 67,500 6 97,500 7,500 25,000 6,000 12,000 215,509 3 67,500 7 113,750 7,500 25,000 6,000 12,000 231,760 308,750 30,000 100,000 24,000 48,000 735,779 4 100,000 12 225,000 7,500 25,000 6,000 15,000 378,516 4 100,000 14 262,500 7,500 25,000 6,000 15,000 416,018 4 100,000 12 225,000 7,500 25,000 6,000 50,000 413,516 4 100,000 13 243,750 7,500 25,000 6,000 50,000 432,267 956,250 30,000 100,000 24,000 130,000 1,640,317 146,509 422,787 525,473 858,683 1,552,750 2,475,218 3,332,501 8,219,152 690,750 97,451 504,750 992,007 165,334 592,500 1,419,172 236,529 663,000 1,845,644 307,607 733,500 2,271,536 2,493,750 23 517,500 184,000 798,951 26 585,000 208,000 958,334 28 630,000 224,000 1,090,529 30 675,000 240,000 1,222,607 (35,504) (8,319) 225,000 400,000 Selling Expenses Prior Commissions Paid/Expensed New FirstLine Commissions Booked Commissions Backlog Staff (from Headcount, above) Base Comp (loaded) Expenses Total Selling Expenses 0 63,000 63,000 10,500 148,500 201,000 33,500 204,750 372,250 62,042 274,500 584,708 7 157,500 56,000 213,500 10 225,000 80,000 315,500 15 337,500 120,000 491,000 18 405,000 144,000 611,042 1,125,000 400,000 1,631,042 2,407,500 856,000 4,070,422 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Total Q1 2000 Marketing Expenses Staff Base Comp (loaded) Promotion Public Relations Advertising Trade Shows Direct Mail Consulting Collateral Total Marketing Expenses Q2 2000 Q3 2000 Q4 2000 FY 2000 Q1 2001 Q2 2001 Q3 2001 Q4 2001 Total FY 2001 3 60,000 4 80,000 5 100,000 5 100,000 340,000 5 125,000 5 125,000 6 150,000 7 175,000 575,000 15,000 10,000 5,000 20,000 10,000 10,000 130,000 30,000 50,000 50,000 50,000 15,000 25,000 300,000 30,000 125,000 50,000 100,000 25,000 50,000 480,000 30,000 125,000 50,000 100,000 25,000 50,000 480,000 105,000 310,000 155,000 270,000 75,000 135,000 1,390,000 100,000 187,500 100,000 125,000 25,000 75,000 737,500 100,000 187,500 100,000 125,000 25,000 75,000 737,500 100,000 250,000 100,000 125,000 25,000 187,500 937,500 100,000 250,000 100,000 125,000 25,000 187,500 962,500 400,000 875,000 400,000 500,000 100,000 525,000 3,375,000 Staff Base Comp (loaded) Hardware Amortize Software Amortize Consulting & Contracting Expense Licensing & Other Total R & D Expenses 3 60,000 10,000 10,000 25,000 10,000 115,000 4 80,000 10,000 10,000 25,000 10,000 135,000 5 100,000 10,000 10,000 25,000 10,000 155,000 5 100,000 10,000 10,000 25,000 10,000 155,000 340,000 40,000 40,000 100,000 40,000 560,000 6 150,000 50,000 10,000 50,000 125,000 385,000 7 175,000 50,000 10,000 50,000 125,000 410,000 8 200,000 50,000 25,000 125,000 187,500 587,500 8 200,000 50,000 25,000 125,000 187,500 587,500 725,000 200,000 70,000 350,000 625,000 1,970,000 Staff Base Comp (loaded) Legal & Audit Occupancy & Utilities (all depts) Consulting Expense Other Total G & A Expenses 4 80,000 15,000 30,000 15,000 7,500 147,500 4 80,000 15,000 30,000 15,000 7,500 147,500 5 100,000 15,000 30,000 15,000 7,500 167,500 5 100,000 15,000 30,000 15,000 7,500 167,500 360,000 60,000 120,000 60,000 30,000 630,000 5 100,000 50,000 50,000 37,500 7,500 245,000 6 120,000 50,000 50,000 37,500 7,500 265,000 7 175,000 50,000 50,000 37,500 25,000 337,500 7 175,000 50,000 50,000 37,500 25,000 337,500 570,000 200,000 200,000 150,000 65,000 1,185,000 (641,504) (906,319) (818,085) (477,810) 222,393 (2,381,270) R&D G&A Net Income Headcount Enterprise Members Single Project Members Total Project Members (1,146,991) (990,755) (3,685,569) (1,307,768) 21 28 39 43 55 62 65 69 125 1,500 1,625 250 2,280 2,530 700 3,885 4,585 1,400 5,285 6,685 2,600 9,880 12,480 4,000 13,840 17,840 6,300 19,935 26,235 8,325 24,210 32,535 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2002 Q2 2002 Q3 2002 Q4 2002 Total FY 2002 Q1 2003 Q2 2003 Q3 2003 Q4 2003 Total FY 2003 Summary Pro-Forma Financials Pct Rev Pct Cost Revenues Cost of Goods Sold Gross Margin Selling Expenses Marketing Research & Development General and Administrative 5,210,855 6,646,560 7,895,490 9,024,867 28,777,772 100% 11,690,221 13,614,931 15,307,039 16,835,559 57,447,750 100% 994,773 1,016,024 1,037,275 1,058,526 4,106,598 14% 1,706,275 1,727,526 1,748,777 1,770,028 6,952,606 12% 4,216,082 5,630,536 6,858,215 7,966,341 24,671,174 86% 9,983,946 11,887,405 13,558,262 15,065,531 50,495,144 88% 1,293,589 1,410,491 1,507,909 1,589,091 5,801,081 20% 1,507,500 1,535,000 1,562,500 1,562,500 6,167,500 21% 26% 1,656,743 1,764,119 1,853,599 1,928,166 7,202,626 13% 16% 28% 3,677,500 3,705,000 3,705,000 3,705,000 14,792,500 26% 34% 785,000 812,500 867,500 895,000 3,360,000 667,500 667,500 695,000 722,500 2,752,500 12% 15% 2,670,000 2,670,000 2,725,000 2,725,000 10,790,000 19% 25% 10% 12% 1,010,000 1,010,000 1,037,500 1,065,000 4,122,500 7% 19% 100% Net Income Before Taxes (37,508) 1,205,045 2,225,306 3,197,249 6,590,093 23% 16% 9% 100% 969,703 2,738,286 4,237,163 5,642,366 13,587,518 24% Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2002 Q2 2002 Q3 2002 Q4 2002 Sales Force Sales Staff - Headcount 30 30 30 Recurring Revenue Sources Enterprise Sales to Repeat Owners New Sales: Via Direct Sales Via Insurance Company Via Construction Manager Subtotal New Lost Accounts: 10 5 5 20 4 10 5 5 20 5 53 Total FY 2002 Q1 2003 Q2 2003 Q3 2003 Q4 2003 Total FY 2003 30 30 30 30 30 10 5 5 20 7 10 5 5 20 8 15 11 11 37 9 15 11 11 37 12 15 11 11 37 15 15 11 11 37 17 68 81 93 93 121 146 168 188 188 265,000 927,500 397,500 1,590,000 340,000 1,190,000 510,000 2,040,000 405,000 1,417,500 607,500 2,430,000 465,000 1,627,500 697,500 2,790,000 1,475,000 5,162,500 2,212,500 8,850,000 605,000 2,117,500 907,500 3,630,000 730,000 2,555,000 1,095,000 4,380,000 840,000 2,940,000 1,260,000 5,040,000 940,000 3,290,000 1,410,000 5,640,000 3,115,000 10,902,500 4,672,500 18,690,000 2,400,000 2,400,000 2,400,000 2,400,000 9,600,000 4,440,000 4,440,000 4,440,000 4,440,000 17,760,000 240 67 711 4,800,000 1,540,405 15,582,835 240 89 862 4,800,000 1,947,854 18,434,980 240 108 994 4,800,000 2,304,373 20,930,608 240 124 1,110 4,800,000 2,616,326 23,114,282 960 240 139 1,211 4,800,000 2,889,285 25,024,997 240 151 1,300 4,800,000 3,128,125 26,696,872 240 163 1,377 4,800,000 3,337,109 28,159,763 240 172 1,445 4,800,000 3,519,970 29,439,793 960 7,200,000 7,200,000 7,200,000 7,200,000 9,240,000 9,240,000 9,240,000 9,240,000 Sales Build Total Enterprise Accounts Enterprise Account Revenue Distribution Large (percent of accts; rev per qtr) Medium Small Total New Enterprise Bookings Revenues from One-Time Projects New Projects Sold Projects Concluded Net Single Projects Underway New Bookings - One time projects Backlog worked off Ending Backlog Total All new FirstLine bookings 19,200,000 8,408,958 28,800,000 19,200,000 12,874,489 36,960,000 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2002 Revenue Streams FirstLine Enterprise Single Project Product Line Extensions Portfolio Product (Info - Network) Enterprise Single Firm Insurance Product Enterprise People Consulting & Services Enterprise Single Project Rentable Applications Enterprise Sum of Product Extensions Gross Revenues Q2 2002 Q3 2002 Q4 2002 Total FY 2002 Q1 2003 Q2 2003 Q3 2003 Q4 2003 Total FY 2003 1,590,000 1,540,405 2,040,000 1,947,854 2,430,000 2,304,373 2,790,000 2,616,326 8,850,000 8,408,958 31% 29% 3,630,000 2,889,285 4,380,000 3,128,125 5,040,000 3,337,109 5,640,000 3,519,970 18,690,000 12,874,489 33% 22% 477,000 184,849 612,000 233,743 729,000 276,525 837,000 313,959 2,655,000 1,009,075 9% 4% 1,270,500 346,714 1,533,000 375,375 1,764,000 400,453 1,974,000 422,396 6,541,500 1,544,939 11% 3% 397,500 510,000 607,500 697,500 2,212,500 8% 1,197,900 1,445,400 1,663,200 1,861,200 6,167,700 11% 397,500 385,101 510,000 486,964 607,500 576,093 697,500 654,081 2,212,500 2,102,239 8% 7% 907,500 722,321 1,095,000 782,031 1,260,000 834,277 1,410,000 879,993 4,672,500 3,218,622 8% 6% 238,500 306,000 364,500 418,500 1,327,500 5% 726,000 876,000 1,008,000 1,128,000 3,738,000 7% 5,210,855 6,646,560 7,895,490 9,024,867 28,777,772 100% 11,690,221 13,614,931 15,307,039 16,835,559 57,447,750 100% 6 165,000 17 361,250 25,000 125,000 6,000 312,500 994,773 6 165,000 18 382,500 25,000 125,000 6,000 312,500 1,016,024 6 165,000 19 403,750 25,000 125,000 6,000 312,500 1,037,275 6 165,000 20 425,000 25,000 125,000 6,000 312,500 1,058,526 1,572,500 100,000 500,000 24,000 1,250,000 4,106,598 6 165,000 19 403,750 250,000 250,000 12,500 625,000 1,706,275 6 165,000 20 425,000 250,000 250,000 12,500 625,000 1,727,526 6 165,000 21 446,250 250,000 250,000 12,500 625,000 1,748,777 6 165,000 22 467,500 250,000 250,000 12,500 625,000 1,770,028 1,742,500 1,000,000 1,000,000 50,000 2,500,000 6,952,606 4,216,082 5,630,536 6,858,215 7,966,341 24,671,174 9,983,946 11,887,405 13,558,262 15,065,531 50,495,144 Prior Commissions Paid/Expensed New FirstLine Commissions Booked Commissions Backlog 378,589 1,080,000 2,972,947 495,491 1,080,000 3,557,456 592,909 1,080,000 4,044,547 674,091 1,080,000 4,450,455 4,320,000 741,743 1,386,000 5,094,713 849,119 1,386,000 5,631,594 938,599 1,386,000 6,078,995 1,013,166 1,386,000 6,451,829 5,544,000 Staff (from Headcount, above) Base Comp (loaded) Expenses Total Selling Expenses 30 675,000 240,000 1,293,589 30 675,000 240,000 1,410,491 30 675,000 240,000 1,507,909 30 675,000 240,000 1,589,091 30 675,000 240,000 1,656,743 30 675,000 240,000 1,764,119 30 675,000 240,000 1,853,599 30 675,000 240,000 1,928,166 Expenses Cost of Goods Sold Engineering Staff Base Comp (loaded) Support Staff Base Comp (loaded) Consulting Expenses Amortize Hardware, Software Internet Fees Hosting Fees Total Cost of Goods Sold Gross Margin 660,000 660,000 Selling Expenses 2,700,000 960,000 5,801,081 2,700,000 960,000 7,202,626 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2002 Marketing Expenses Staff Base Comp (loaded) Promotion Public Relations Advertising Trade Shows Direct Mail Consulting Collateral Total Marketing Expenses Q2 2002 Q3 2002 Q4 2002 Total FY 2002 Q1 2003 Q2 2003 Q3 2003 Q4 2003 Total FY 2003 8 220,000 9 247,500 10 275,000 10 275,000 1,017,500 11 302,500 12 330,000 12 330,000 12 330,000 1,292,500 100,000 375,000 125,000 250,000 125,000 312,500 1,507,500 100,000 375,000 125,000 250,000 125,000 312,500 1,535,000 100,000 375,000 125,000 250,000 125,000 312,500 1,562,500 100,000 375,000 125,000 250,000 125,000 312,500 1,562,500 400,000 1,500,000 500,000 1,000,000 500,000 1,250,000 6,167,500 125,000 1,250,000 250,000 250,000 250,000 1,250,000 3,677,500 125,000 1,250,000 250,000 250,000 250,000 1,250,000 3,705,000 125,000 1,250,000 250,000 250,000 250,000 1,250,000 3,705,000 125,000 1,250,000 250,000 250,000 250,000 1,250,000 3,705,000 500,000 5,000,000 1,000,000 1,000,000 1,000,000 5,000,000 14,792,500 Staff Base Comp (loaded) Hardware Amortize Software Amortize Consulting & Contracting Expense Licensing & Other Total R & D Expenses 9 247,500 62,500 37,500 125,000 312,500 785,000 10 275,000 62,500 37,500 125,000 312,500 812,500 12 330,000 62,500 37,500 125,000 312,500 867,500 13 357,500 62,500 37,500 125,000 312,500 895,000 1,210,000 250,000 150,000 500,000 1,250,000 3,360,000 13 357,500 125,000 62,500 875,000 1,250,000 2,670,000 13 357,500 125,000 62,500 875,000 1,250,000 2,670,000 15 412,500 125,000 62,500 875,000 1,250,000 2,725,000 15 412,500 125,000 62,500 875,000 1,250,000 2,725,000 1,540,000 500,000 250,000 3,500,000 5,000,000 10,790,000 Staff Base Comp (loaded) Legal & Audit Occupancy & Utilities (all depts) Consulting Expense Other Total G & A Expenses 7 192,500 250,000 62,500 37,500 125,000 667,500 7 192,500 250,000 62,500 37,500 125,000 667,500 8 220,000 250,000 62,500 37,500 125,000 695,000 9 247,500 250,000 62,500 37,500 125,000 722,500 852,500 1,000,000 250,000 150,000 500,000 2,752,500 9 247,500 375,000 75,000 62,500 250,000 1,010,000 9 247,500 375,000 75,000 62,500 250,000 1,010,000 10 275,000 375,000 75,000 62,500 250,000 1,037,500 11 302,500 375,000 75,000 62,500 250,000 1,065,000 1,072,500 1,500,000 300,000 250,000 1,000,000 4,122,500 1,205,045 2,225,306 3,197,249 6,590,093 969,703 2,738,286 4,237,163 5,642,366 13,587,518 77 80 85 88 88 90 94 96 13,250 35,550 48,800 17,000 43,100 60,100 20,250 49,700 69,950 23,250 55,500 78,750 36,300 66,605 102,905 43,800 71,500 115,300 50,400 75,735 126,135 56,400 79,475 135,875 R&D G&A Net Income Headcount Enterprise Members Single Project Members Total Project Members (37,508) Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2004 Q2 2004 Q3 2004 Q4 2004 Total FY 2004 Summary Pro-Forma Financials Pct Rev Pct Cost Revenues Cost of Goods Sold Gross Margin Selling Expenses Marketing Research & Development General and Administrative 21,762,964 24,142,968 26,317,347 28,284,241 100,507,520 100% 2,822,524 2,843,775 2,886,277 2,907,528 11,460,104 11% 18,940,440 21,299,193 23,431,070 25,376,713 89,047,416 89% 16% 1,837,805 1,904,587 1,960,239 2,006,616 7,709,248 8% 11% 6,857,500 6,885,000 6,912,500 6,912,500 27,567,500 27% 38% 5,037,500 5,037,500 5,065,000 5,092,500 20,232,500 20% 28% 1,552,500 1,580,000 1,607,500 1,607,500 6,347,500 6% 9% 100% Net Income Before Taxes 3,655,135 5,892,106 7,885,831 9,757,597 27,190,668 27% Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2004 Q2 2004 Q3 2004 Q4 2004 Total FY 2004 Sales Force Sales Staff - Headcount 25 25 25 25 Recurring Revenue Sources Enterprise Sales to Repeat Owners New Sales: Via Direct Sales Via Insurance Company Via Construction Manager Subtotal New Lost Accounts: 19 19 19 57 19 19 19 19 57 23 19 19 19 57 26 19 19 19 57 29 226 260 291 319 319 1,130,000 3,955,000 1,695,000 6,780,000 1,300,000 4,550,000 1,950,000 7,800,000 1,455,000 5,092,500 2,182,500 8,730,000 1,595,000 5,582,500 2,392,500 9,570,000 5,480,000 19,180,000 8,220,000 32,880,000 6,840,000 6,840,000 6,840,000 6,840,000 27,360,000 200 181 1,464 3,000,000 3,679,974 28,759,819 200 183 1,481 3,000,000 3,594,977 28,164,841 200 185 1,496 3,000,000 3,520,605 27,644,236 200 187 1,509 3,000,000 3,455,530 27,188,707 800 9,840,000 9,840,000 9,840,000 9,840,000 Sales Build Total Enterprise Accounts Enterprise Account Revenue Distribution Large (percent of accts; rev per qtr) Medium Small Total New Enterprise Bookings Revenues from One-Time Projects New Projects Sold Projects Concluded Net Single Projects Underway New Bookings - One time projects Backlog worked off Ending Backlog Total All new FirstLine bookings 12,000,000 14,251,086 39,360,000 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2004 Revenue Streams FirstLine Enterprise Single Project Product Line Extensions Portfolio Product (Info - Network) Enterprise Single Firm Insurance Product Enterprise People Consulting & Services Enterprise Single Project Rentable Applications Enterprise Sum of Product Extensions Gross Revenues Q2 2004 Q3 2004 Q4 2004 Total FY 2004 6,780,000 3,679,974 7,800,000 3,594,977 8,730,000 3,520,605 9,570,000 3,455,530 32,880,000 14,251,086 33% 14% 2,712,000 551,996 3,120,000 539,247 3,492,000 528,091 3,828,000 518,329 13,152,000 2,137,663 13% 2% 2,712,000 3,120,000 3,492,000 3,828,000 13,152,000 13% 1,695,000 919,994 1,950,000 898,744 2,182,500 880,151 2,392,500 863,882 8,220,000 3,562,772 8% 4% 2,712,000 3,120,000 3,492,000 3,828,000 13,152,000 13% 21,762,964 24,142,968 26,317,347 28,284,241 100,507,520 100% 6 165,000 18 382,500 500,000 500,000 25,000 1,250,000 2,822,524 6 165,000 19 403,750 500,000 500,000 25,000 1,250,000 2,843,775 6 165,000 21 446,250 500,000 500,000 25,000 1,250,000 2,886,277 6 165,000 22 467,500 500,000 500,000 25,000 1,250,000 2,907,528 1,700,000 2,000,000 2,000,000 100,000 5,000,000 11,460,104 18,940,440 21,299,193 23,431,070 25,376,713 89,047,416 Prior Commissions Paid/Expensed New FirstLine Commissions Booked Commissions Backlog 1,075,305 1,476,000 6,852,524 1,142,087 1,476,000 7,186,437 1,197,739 1,476,000 7,464,697 1,244,116 1,476,000 7,696,581 5,904,000 Staff (from Headcount, above) Base Comp (loaded) Expenses Total Selling Expenses 25 562,500 200,000 1,837,805 25 562,500 200,000 1,904,587 25 562,500 200,000 1,960,239 25 562,500 200,000 2,006,616 Expenses Cost of Goods Sold Engineering Staff Base Comp (loaded) Support Staff Base Comp (loaded) Consulting Expenses Amortize Hardware, Software Internet Fees Hosting Fees Total Cost of Goods Sold Gross Margin 660,000 Selling Expenses 2,250,000 800,000 7,709,248 Collaborative Structures, Inc. Sales Build and Pro Forma Financial Summary Model Rev Jan 22, 2000 Run time 1/25/00 5:21 PM Q1 2004 Marketing Expenses Staff Base Comp (loaded) Promotion Public Relations Advertising Trade Shows Direct Mail Consulting Collateral Total Marketing Expenses Q2 2004 Q3 2004 Q4 2004 Total FY 2004 13 357,500 14 385,000 15 412,500 15 412,500 1,567,500 250,000 2,500,000 500,000 250,000 500,000 2,500,000 6,857,500 250,000 2,500,000 500,000 250,000 500,000 2,500,000 6,885,000 250,000 2,500,000 500,000 250,000 500,000 2,500,000 6,912,500 250,000 2,500,000 500,000 250,000 500,000 2,500,000 6,912,500 1,000,000 10,000,000 2,000,000 1,000,000 2,000,000 10,000,000 27,567,500 Staff Base Comp (loaded) Hardware Amortize Software Amortize Consulting & Contracting Expense Licensing & Other Total R & D Expenses 15 412,500 250,000 125,000 1,750,000 2,500,000 5,037,500 15 412,500 250,000 125,000 1,750,000 2,500,000 5,037,500 16 440,000 250,000 125,000 1,750,000 2,500,000 5,065,000 17 467,500 250,000 125,000 1,750,000 2,500,000 5,092,500 1,732,500 1,000,000 500,000 7,000,000 10,000,000 20,232,500 Staff Base Comp (loaded) Legal & Audit Occupancy & Utilities (all depts) Consulting Expense Other Total G & A Expenses 11 302,500 500,000 125,000 125,000 500,000 1,552,500 12 330,000 500,000 125,000 125,000 500,000 1,580,000 13 357,500 500,000 125,000 125,000 500,000 1,607,500 13 357,500 500,000 125,000 125,000 500,000 1,607,500 1,347,500 2,000,000 500,000 500,000 2,000,000 6,347,500 3,655,135 5,892,106 7,885,831 9,757,597 27,190,668 88 91 96 98 79,100 87,840 166,940 91,000 88,860 179,860 101,850 89,760 191,610 111,650 90,540 202,190 R&D G&A Net Income Headcount Enterprise Members Single Project Members Total Project Members