Consolidated Pro Forma Financials Internet Multicasting Service Internet Software Consortium June 17, 2002 Consolidated Pro Forma Financials Table of Contents 1. Currency and Number Formats . . . . . . . . . . . . . . . . . 2 2. Analysis of Revenue Model and Registry Growth . . . . . . . . 3 2.1 Methodology . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.2 Revenue Model Assumptions . . . . . . . . . . . . . . . . . . 3 2.3 Projected Registry Size . . . . . . . . . . . . . . . . . . . 4 2.4 Projected Revenue Stream . . . . . . . . . . . . . . . . . . . 4 3. Consolidated 5-Year Pro Forma Analysis of Cash Flow and Debt . 5 3.1 Methodology . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.2 Pro Forma Net Income After Operations Costs at $6 Name . . . . 5 3.3 Debt, Capital Expense, and Public Works at $6 and Debt Financing . . . . . . . . . . . . . . . . . . . . . . . . . . 6 3.4 Debt, Capital Expense, and Public Works at $5.50 . . . . . . . 7 3.5 Analysis of Working Capital and Additional Expenses . . . . . 7 3.6 Working Capital and Reserves at $6 and Debt Financing . . . . 8 3.7 Working Capital and Reserves at $5.50 . . . . . . . . . . . . 8 4. Certification and Purpose . . . . . . . . . . . . . . . . . . 10 Authors' Addresses . . . . . . . . . . . . . . . . . . . . . . 11 A. Document Formats . . . . . . . . . . . . . . . . . . . . . . . 12 Internet Multicasting Service & Internet Software Consortium [Page 1] Consolidated Financials June 2002 1. Currency and Number Formats This document has all budget items and registry sizes in the format of thousands of units. For example, 1,100,000 is listed as 1,100 in the tables. This document uses US$ (US Dollars) as the unit of currency. This document is also available in the following currency formats: o € (European Euro) [1] o ¥ (Japanese Yen) [2] Internet Multicasting Service & Internet Software Consortium [Page 2] Consolidated Financials June 2002 2. Analysis of Revenue Model and Registry Growth 2.1 Methodology We present here a highly conservative pro forma analysis of registry growth, revenue, expense, debt, and reserves. Our conservative assumptions are reflected in low renewal rates, a declining price forced by market conditions, and a decreasing rate of new registrants. The underlying revenue model contains data obtained from VeriSign via ICANN under NDA, so we are not publishing the full model, only aggregate information that can be derived from public sources. However, the full model is available to ICANN staff upon request. [3] Our financial analysis is based on two financing scenarios, one in which debt financing is used to cover initial startup costs, and a second scenario in which the debt financing is supplemented by a portion of the VeriSign endowment: o If we qualify for the VeriSign Endowment, our analysis is based on an initial price of $5.50 for add, transfer, and renew operations. In this scenario, initial expenses are covered through our $2.5 million line of credit, of which we anticipate using $1.5 million at peak. The outstanding debt is paid in early 2003, reducing interest costs and freeing capital for financing of core operations and Internet Public Works Programs as described in the proposal. o If we do not qualify for the VeriSign Endowment, our initial price is set at $6.00 to cover the increased costs of debt financing. In either case, we believe that we will only use 60% of our available credit, leaving a substantial cushion in case revenue or expenses differ from projections. 2.2 Revenue Model Assumptions Parameter Assumption ========= ========== Assumption for Percentage Renewals 24.00% New Registrations As % of Installed Base 1.92% Average Renewal Period in Years 1.5 Internet Multicasting Service & Internet Software Consortium [Page 3] Consolidated Financials June 2002 2.3 Projected Registry Size 2003 2004 2005 2006 2007 ======= ======= ====== ======= ======= New Registrants 443 427 470 690 793 Renewals 307 290 135 139 150 Total Registrations 750 717 606 829 944 Size at EOY 1,787 2,004 2,473 3,132 3,911 % Change in Registry -20.85% 12.14% 23.41% 26.63% 24.88% Size of Registry at Beginning of Period 2,258 Size of Registry at End of Period 3,911 Change in Registry in 5-year Period +1,653,289 2.4 Projected Revenue Stream Beginning Registry Price $5.50 Annual Decline in Price -10.00% Cumulative Revenue $25,229 2003 2004 2005 2006 2007 ======= ======= ====== ======= ======= Price at EOY $5.23 $4.72 $4.26 $3.84 $3.47 Gross Revenue $6,072 $5,218 $4,344 $4,559 $5,035 Based on an initial price point of $6 per name, gross revenue changes as follows: Beginning Registry Price $6.00 Annual Decline in Price -10.00% Cumulative Revenue $27,523 2003 2004 2005 2006 2007 ======= ======= ====== ======= ======= Price at EOY $5.70 $5.14 $4.64 $4.19 $3.78 Gross Revenue $6,624 $5,692 $4,739 $4,974 $5,492 Internet Multicasting Service & Internet Software Consortium [Page 4] Consolidated Financials June 2002 3. Consolidated 5-Year Pro Forma Analysis of Cash Flow and Debt 3.1 Methodology Our assessment of expenses is based on the deliverables detailed in the .org Proposal, analysis of past sending, and firm price quotes on key items such as capital expenditures. Our funding priorities are to first cover the operation of the core registry function. The pro forma net income after cost of operations presented in the next section is based on a staff of 19.75 FTE. Pro forma net income after cost of operations is modeled under two scenarios, one with the VeriSign endowment, the other without use of the endowment. Note that costs are identical in both scenarios. 3.2 Pro Forma Net Income After Operations Costs at $6 Name 2002 2003 2004 2005 2006 2007 ======= ========= ========= ========= ========= ========= Gross Revenue $6,624 $5,692 $4,739 $4,974 $5,492 COGS[1] -$66 -$56 -$47 -$49 -$54 Net Revenue $6,557 $5,635 $4,691 $4,924 $5,437 ---------------------------------------------------------------------------- Bid Prep.[2] $84 Payroll[3] $923 $1,949 $2,046 $2,218 $2,329 $2,561 Contract[4] $112 $198 $198 $270 $291 $303 Prof Srvs[5] $42 $102 $104 $106 $108 $111 Operations[6] $125 $493 $569 $595 $624 $655 Total $1,287 $2,742 $2,918 $3,190 $3,353 $3,631 ---------------------------------------------------------------------------- Net Income After Operations -$1,287 $3,815 $2,717 $1,501 $1,571 $1,806 Average Net Income as a Percent of Gross Revenue: 37% Notes "[1]" Cost of Goods Sold (COGS) is a 1% average cost for merchant processing fees, bank charges, and other costs directly related to revenue. "[2]" Bid Preparation includes the ICANN examination fee, travel, and outside legal fees. This category also includes negotiation of the registry agreement. "[3]" Payroll is based on 19.75 Full Time Equivalents (FTE). "[4]" Contractors includes fees for security, database throughput, Internet Multicasting Service & Internet Software Consortium [Page 5] Consolidated Financials June 2002 routing, and other outside leading experts to provide quarterly reviews. "[5]" Professional Services includes legal, insurance, accounting, and other professional services and includes provisions for yearly audits of financial statements and operations. "[6]" Cost of Operations includes co-location fees, transit costs, hardware and software support fees, travel, and rent, and other costs needed to provide the core registry function, the software deliverables listed in the proposal, the advanced development function, and front- and back-office functions. 3.3 Debt, Capital Expense, and Public Works at $6 and Debt Financing 2002 2003 2004 2005 2006 2007 ======= ========= ========= ========= ========= ========= Net Income After Operations -$1,287 $3,815 $2,717 $1,501 $1,571 $1,806 ---------------------------------------------------------------------------- Capital Expense[7] $692 $320 $165 $50 $200 $0 Interest $48 $123 $0 $0 $0 $0 Debt Repayment $0 $1,500 $0 $0 $0 $0 Total Debt and Capital Expense $741 $1,943 $165 $50 $200 $0 ---------------------------------------------------------------------------- Net Cash Flow After Capital and Debt -$2,028 $1,871 $2,552 $1,451 $1,371 $1,806 Notes "[7] Capital Expense" includes 3 large towers during pre-launch and launch periods. Additional line items are provided for development machines, and supplemental towers in additional exchange points in years 2-5 of the contract. Internet Multicasting Service & Internet Software Consortium [Page 6] Consolidated Financials June 2002 3.4 Debt, Capital Expense, and Public Works at $5.50 2002 2003 2004 2005 2006 2007 ======= ========= ========= ========= ========= ========= Net Income After Operations -$1,287 $3,268 $2,247 $1,110 $1,160 $1,353 ---------------------------------------------------------------------------- Capital Expense[7] $692 $320 $165 $50 $200 $0 Interest $48 $45 $0 $0 $0 $0 Debt Repayment $0 $1,500 $0 $0 $0 $0 Total Debt and Capital Expense $741 $1,865 $165 $50 $200 $0 ---------------------------------------------------------------------------- Net Cash Flow After Capital and Debt -$2,028 $1,403 $2,082 $1,060 $960 $1,353 3.5 Analysis of Working Capital and Additional Expenses Once capital costs, debt, and the core operation of the registry are covered, we staff recommendations to the board of directors are considered for programs that meet our mission of running the .org TLD as a public trust and meets our core goals: 1. Providing service and differentiation to the .org registrants. 2. Providing public infrastructure that will promote the stable functioning of .org registry and other registries and will promote better service and more competition. Our goal for management of financial resources is to insure that a minimum of $500 in working capital is available in addition to our $2.5 million line of credit. This insures that we are able to meet any unforeseen contingencies and still maintain the stable operation of the .org registry. Once these requirements are met, we attempt to use the remainder of the funds to meet those core goals. Three initial program proposals have been prepared by staff and the board has agreed that these are examples of the kinds of programs it would like to see developed and pursued. Final decisions on funding will occur once funds are available. The three initial programs are: 1. Provision of 8% of gross revenues to fund the IETF and IAB. Internet Multicasting Service & Internet Software Consortium [Page 7] Consolidated Financials June 2002 2. Funding of the development of BIND 9 with special emphasis on secure DNS with an aim of providing a secure DNS function for the .org TLD. 3. Funding of the development of the ANANA protocols for automated namespace management and the development of identity management techniques for .org registrants. 3.6 Working Capital and Reserves at $6 and Debt Financing 2002 2003 2004 2005 2006 2007 ======= ========= ========= ========= ========= ========= Net Cash Flow After Capital and Debt w/out Endowment -$2,028 $1,871 $2,552 $1,451 $1,371 $1,806 ---------------------------------------------------------------------------- Internet Public Works Programs $0 $883 $894 $375 $393 $435 ---------------------------------------------------------------------------- Net Cash Flow After Public Works -$2,028 $987 $1,657 $1,076 $977 $1,371 ---------------------------------------------------------------------------- Debt at End of Year $1,500 $0 $0 $0 $0 $0 ---------------------------------------------------------------------------- Working Capital at End of Year $36 $1,024 $881 $658 $635 $356 Unallocated Reserves $0 $500 $2,250 $3,100 $4,100 $5,750 Cumulative Funding for IETF/IAB: $2,179 Cumulative Funding for BIND 9: $708 Cumulative Funding for ANANA: $95 3.7 Working Capital and Reserves at $5.50 This analysis assumes that startup debt of $1,500,000 is back in February, 2003 and that the wholesale price is reduced to $5.50 per name." Internet Multicasting Service & Internet Software Consortium [Page 8] Consolidated Financials June 2002 2002 2003 2004 2005 2006 2007 ======= ========= ========= ========= ========= ========= Net Cash Flow After Capital and Debt -$2,028 $1,403 $2,082 $1,060 $960 $1,353 ---------------------------------------------------------------------------- Internet Public Works Programs $0 $839 $857 $344 $361 $398 ---------------------------------------------------------------------------- Net Cash Flow After Public Works -$2,028 $563 $1,225 $716 $599 $954 ---------------------------------------------------------------------------- Debt at End of Year $1,500 $0 $0 $0 $0 $0 ---------------------------------------------------------------------------- Working Capital at End of Year $36 $800 $975 $592 $592 $396 Unallocated Reserves $0 $2,600 $3,850 $4,450 $5,050 $6,200 Cumulative Funding for IETF/IAB: $1,998 Cumulative Funding for BIND 9: $708 Cumulative Funding for ANANA: $95 Internet Multicasting Service & Internet Software Consortium [Page 9] Consolidated Financials June 2002 4. Certification and Purpose These pro forma financials contain forward-looking projections of market conditions, expenses, and revenues. They are provided as a planning tool. Actual budgets will be developed by the program staff and approved by the IMS board of directors based on actual market conditions, expenses, and revenues. /Carl Malamud/ Signed Carl Malamud Chairman Internet Multicasting Service June 16, 2002 Internet Multicasting Service & Internet Software Consortium [Page 10] Consolidated Financials June 2002 URIs [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] Authors' Addresses Internet Multicasting Service P.O. Box 217 Stewarts Point, CA 95450 US Phone: +1.707.847.3720 Fax: +1.415.680.1556 URI: http://not.invisible.net/ Internet Software Consortium 950 Charter Street Redwood City, CA 94063 US Phone: +1.650.779.7000 Fax: +1.650.779.7055 URI: http://www.isc.org/ Internet Multicasting Service & Internet Software Consortium [Page 11] Consolidated Financials June 2002 Appendix A. Document Formats This document is available in the following formats: o [html [4]] HTML o [htm [5]] ICANN original form. o [xml [6]] XML o [txt [7]] This document. o [nroff [8]] NROFF o [word [9]] Word o [pdf [10]] PDF Internet Multicasting Service & Internet Software Consortium [Page 12]