Mind Commerce - WiMAX Business Planning Tool

WiMAX Business Planning Tool

Published: June 2009
Spreadsheet (Excel)
Author: Frank Ohrtman

Two Ways to Order

(1) Order by FAX - CLICK HERE (PDF)
or
(2) Order On-line with Credit Card (see below)

Order via Secure E-commerce
Click "Order Now" below:

Single-user

$ 495 US

Company-wide

$ 995 US

		Overview The WiMAX Business Planning Tool is an in-depth working ExcelTM spreadsheet-based tool that provides a wide ranging set of variables to be programmed into the spreadsheet including details related to WiMAX parameters as well as VoIP and video delivery concerns. The tool allows the WiMAX entrepreneur to make financial projections many years into the future and will prove to be a valuable tool where investors may be asking the simple question "How much money are we going to make?"
		Key Benefits Compiles 10-year Profit and Loss Statements for inclusion in Financials section of the grant application template Enables the user to determine EBITDA positive time frames Offers modeling based on the WiMAX platform variables (power, frequency, channel sizes, FDD or TDD, etc) Incorporates VoIP parameters to determine cash flows Enables modeling through the input of endless variables related to subscriber uptake, oversubscription, spectrum use, VoIP compression algorithms, modulation, etc.
		Components EBITDA Net present Value Free Cash Flow Operational Expenses Capital Expenses Assumptions for subscription pricing, growth in subscribership, acquisition, churn, ARPU, provisioning, cost of CPE, installation, etc Number of base stations required Subscribers per base station UL channels Subscriber revenues based on prioritization/polling/modulation Services offered Demand Depreciation schedules
		Target Audience Cellular, wireless ISP's, cable TV MSO's, and fixed network service providers WiMAX vendors, start-ups, vendors, investors, and industry analysts 700 MHz auction bidders, spectrum holders, and investors IP backbone service providers and VoIP service providers Telecom regulators and government agencies Enterprise telecom and IT managers Municipal IT and telecom managers
		About this Tool and the Broadband Technology Opportunities Program (BTOP) This tool might make or break any grant application. All BTOP grant applications will require some very detailed financial statements explaining why a project is a good investment of the taxpayer's dollars. This tool should sell for $64,000 as it answers the $64,000 question: "Why would your project not be completed without federal funds within the time frame of the grant period?" The easy answer here is to run the tool for your project showing a conventional approach to financing such a project followed by running the tool to show the financials for the project with federal funds (CAPEX at 80% off thanks to federal funding). Compare the EBITDA positive data. Note that without federal funds the project may not be EBITDA positive until year 10 or 11 (if ever). With federal funding, the project might be EBITDA positive in year 3. In turn, this tool demonstrates the sustainability of the project, another important criteria for evaluating grant applications. This tool could save the applicant hundreds of man-hours when compared to writing a comparable tool in-house.

Frank Ohrtman has almost 20 years experience in VoIP and wireless applications. He is the president of WMX Systems, LLC, a Denver, Colorado-based consulting and systems integration firm. Mr. Ohrtman learned to perform in-depth research and write succinct analyses during his years as a Navy Intelligence Officer (1981-1991) during which he specialized in electronic intelligence and electronic warfare. He is a veteran of U.S. Navy actions in Lebanon (awarded Navy Expeditionary Medal), Grenada, Libya (awarded Joint Service Commendation Medal), and the Gulf War (awarded National Defense Service Medal).

His telecommunications career began with selling VoIP gateway switches for Netrix Corporation to long distance bypass carriers. He went on to promote softswitch solutions for Lucent Technologies (Qwest Account Manager) and Vsys (Western Region Sales Manager). His consulting clients include national governments and tier one telephone companies.

Mr. Ohrtman is a Gerson Lehrman Group Scholar (http://www.glgcouncils.com) and serves as Dean of WiMAX for Applied Learning Solutions (http://www.e-als.com). He is a regular blogger and contributor to WiMAX.com (http://www.wimax.com) and annual presenter at WiMAX World (http://www.wimaxworld.com) as well as local Cisco Users Groups. Mr. Ohrtman serves as an advisor to Bush Telecommunications Pty Ltd and the Rural Broadband Consortium of Australia.

Mr. Ohrtman holds a Master of Science degree in Telecommunications from Colorado University College of Engineering (master's thesis: "Softswitch As Class 4 Replacement-A Disruptive Technology"), a Master of Arts degree in International Relations from Boston University and a Bachelor of Arts, Political Science, from University of Iowa

Frank may be reached at Frank@MindCommerce.com

Do you need independent WiMAX consulting or training?

Mind Commerce also provides independent and
customized research, consulting, and training

Contact Mind Commerce: Click Here or email at:
Research@MindCommerce.com
Consulting@MindCommerce.com or
Training@MindCommerce.com

Click here for Mind Commerce Training

Mind Commerce also accepts Request for Proposal (RFP)
RFP@MindCommerce.com

Go to Publications Main Page