Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Legal icon Educational Research Business Plan

Start your plan

University Patents, Inc.

Executive Summary

University Patents seeks to transfer technology from research universities to preexisting companies via the licensing of patents.

Most universities have an office of technology transfer that is responsible for bringing the research/patents generated by the university to market. Some universities are very effective in this area (i.e., Stanford, U of Wisconsin, MIT), but most lack the work force and network to place most patents. Universities traditionally focus on the patents that will bring in substantial amounts of money, yet only 0.6% of licenses generate in excess of $1,000,000 in annual royalties. University Patents has the ability to not only assist the universities in placing technology but, due to the singular focus of the company, also increase the revenue to the university by increasing the number of licenses written. University Patents will generate income by taking a commission off each successful placement.

Most patents generated by university research are not, by themselves, able to sustain a business. They are most valuable to existing companies already in a market that can use new technology to increase a product line or slightly diversify their business into a market in which they have an expertise. The small size of these patents mean that most Venture Capital (VC) firms are not interested in these patents and the universities are reluctant to spend time trying to place them. University Patents will be able to focus on these smaller patents and the business will depend on bringing several of these patents to market per year.

University Patents’ business will be founded on working with several universities to place their technology patents with corporations. University Patents will research the market, develop a value model and identify potentials licensees for the patent. University Patents will bring these parties to negotiation and will receive a commission based on the licensing agreement and any future royalties generated by the patent.

Educational research business plan, executive summary chart image

1.1 Objectives

First year objectives:

  1. Create firm relationships with four university programs in the first year.
  2. Move four patents to commercialization in the first year.
  3. Develop a contact process for approaching public and private business in the first six months.

Company Summary

“University Patents matches intellectual property owners with those that can use the technology to create profits that both parties can enjoy.”

University Patents will serve as a technology transfer conduit between universities and the business sector specializing in licensing. University Patents will primarily act as an agent of the university and actively research the possible applications of a patented technology. Using this analysis, it will identify and approach companies in those sectors that may have a use for the technology.

University Patents’ advantage is in the focus of the company. First, by targeting patents that independently could not support a business, University Patents will not compete directly with the venture capital groups. Secondly, University Patent will look for universities where the office of technology has a small or non-existent staff dedicated to licensing. The expertise and network University Patents will develop through the research, promotion, and writing of many licenses a year, will be an asset to these universities who only write an average of six licenses per year.

University Patents will position itself as a partner of the university in the effort to move protected technologies to the private sector. As a partner and intermediary in the negotiation, University Patents will receive a percentage of the annual cash flows provided by the licensing agreement.

2.1 Start-up Summary

All of the start-up expenses will be financed by the founders either out-of-pocket or through personal debt.

Educational research business plan, company summary chart image

Start-up Funding
Start-up Expenses to Fund $13,750
Start-up Assets to Fund $56,250
Total Funding Required $70,000
Assets
Non-cash Assets from Start-up $0
Cash Requirements from Start-up $56,250
Additional Cash Raised $0
Cash Balance on Starting Date $56,250
Total Assets $56,250
Liabilities and Capital
Liabilities
Current Borrowing $0
Long-term Liabilities $0
Accounts Payable (Outstanding Bills) $0
Other Current Liabilities (interest-free) $0
Total Liabilities $0
Capital
Planned Investment
Founders $70,000
Other $0
Additional Investment Requirement $0
Total Planned Investment $70,000
Loss at Start-up (Start-up Expenses) ($13,750)
Total Capital $56,250
Total Capital and Liabilities $56,250
Total Funding $70,000
Start-up
Requirements
Start-up Expenses
Computers (3) $3,600
Office Furniture (Home Offices – 3) $5,000
Business Supplies $1,200
Legal $2,500
ISP Installation Fees $450
Information Sources (Access Fee) $500
Professional Logo Design $500
Total Start-up Expenses $13,750
Start-up Assets
Cash Required $56,250
Other Current Assets $0
Long-term Assets $0
Total Assets $56,250
Total Requirements $70,000

2.2 Company Ownership

University Patents will be started as a Limited Liability Corporation (LLC) that is fully owned by the three founders: Anderson, Bradbeer, and Sorge. Due to the different geographical locations of customers and to reduce overall costs, we feel that the optimal structure of the company would be an organization with the owners working part-time for University Patents during the first three years in separate locations until the revenue can sustain a full time staff. In this manner, University Patents will be a bootstrap operation funded completely by the founders.

The founders will consider moving to full-time employment earlier than the projected timetable states through venture capital or other means, but will be hesitant to give up much more than 20% of the company ownership.

Services

University Patents offers one main service: brokering patented technologies to the commercial sector. University Patents will focus on technologies that are licensable to multiple businesses but that cannot independently sustain a business. University Patents will use two different approaches to sell technology – brokering patents developed by our client universities and specific technology searches for our commercial customers.

The first approach is a licensee-search service that begins with an analysis of possible applications of the newly developed technology across various business sectors. From this analysis, University Patents develops a list of prospective companies and initiates contact with these companies. Once an interested company is found, University Patents works with the university technology office and the potential licensee to value the technology and price the final agreement. University Patents will receive a percentage of the revenue each new license generates.

The second approach is a specific technology search. This service is available to any business sector clients that are in search of a specific up and coming technology. University Patents will search through the known projects various universities are currently working on to find if a match exists. If an exact match can not be found, University Patents will attempt to match the business with a university having expertise in that specific field for possibly funding a research project. University Patents will be paid a flat finders fee for these services.

3.1 Competitive Comparison

Direct

University offices of technology – Most universities already have an office of technology who to perform this function. However, because most university offices do not have the time and/or resources, nor the contacts in the business sector to effectively move new technology out to commercialization, we believe that University Patents can perform the sales and marketing for them more effectively and cost efficiently than their current system. It appears that 90% of the market uses in-house methods of distribution for licensing.

Competitive Technologies, Inc. – Competitive Technologies (CT) is our direct competitor as a private company that provides this licensing service. CT appears to be sub-licensing the IP and patents from the owners and writing licensing agreements with the end-user. However, in recent years this business model’s weakness has shown itself as they have incurred high legal expenses due to patent protection. CT has a very small percentage of the market and, after one profitable year, had losses exceeding $1 million last year due to the litigation. University Patents will focus strictly on facilitating the creation of a licensing agreement between the university and the licensee and thereby have no responsibility in the enforcement of patent protections.

Indirect

Venture capital groups – Due to venture capitalists’ focused interest in only technologies that will lead to a start-up venture, they are an indirect competitor for University Patents. University Patents focuses on technologies that will not support a business, but rather those that are improvements or supplements to existing technologies, which are not of interest to the VCs. There is a creditable threat though, of a VC group using its well-established network to begin a similar service.

3.2 Emerging

All the emerging Web based sites are passive in nature without active sales, marketing and networking staffs. We believe this will give University Patents the advantage in competition for a client base.

Various Internet marketplaces and exchanges include:

2XFR – 2XFRTM (short for “to transfer”) is the technology transfer/licensing exchange Web property of the PatentCafe® Intellectual Property Network. 2XFR is the only supplements transfer website where licensable technology is listed by manufacturing process, engineering risk and targeted market segment. Unlike commissioned or transaction fee-based exchanges, 2XFR does not involve itself in the business affairs; there’s no broker’s commission, no intervention, no software license fees.

Pl-x.com – PLX Systems Incorporated is an enterprise-wide, intellectual property valuation and lifecycle management software. The company’s offerings include software for financial management of intellectual assets, IP valuation solutions, IP content management and market data services.

Yet2.com – Headquartered in Cambridge, Massachusetts, with offices in Nevada, The United Kingdom and Japan, yet2.com has created the first global marketplace for the exchange of intellectual assets. At yet2.com, inventions are listed, licensed, sold and ultimately applied. Clients include corporations like Boeing, DuPont, Procter & Gamble, and others, which collectively represent 10 percent of all commercial R&D spending.

TechEx.com – TechEx is a network of research and licensing professionals in the biomedical industry. TechEx offers an online technology Exchange® where members can identify and introduce technology and intellectual property that is available for partnering. TechEx is a members-only system and is restricted to approved users. There are three types of participants:

  • Licensing professionals from research institutions.
  • Corporate licensing professionals capable of bringing early stage inventions to market, or otherwise providing significant value-added development.
  • Venture capitalists capable of providing financial assistance to commercialization efforts.

PatentAuction.com – PatentAuction.com is an intellectual properties auction on the Web. Auctions include licensing or selling of patents, trademarks, copyrights, businesses, means and methods of doing business, books, music, and games.

Market Analysis Summary

Market size
The Association of University Technology Managers (AUTM) surveys all universities yearly pertaining to IP related issues. One hundred and ninety (190) U.S. universities (the majority of which are in our target segment) responded to the 2000 survey revealing the following data:

Patents

  • 13,032 invention disclosures
  • 6,375 New U.S. patent applications (15% increase over 1999)
  • 3,764 U.S. patents issued (3% increase over 1999)
  • 2.4% of all new patents issued are to academic institutions

The above patents generated the following data on licenses:

  • 4,362 new licenses in Year 2000 (11% increase over 1999)
  • 50% of new licenses were exclusive, 50% were non-exclusive

License income for FY2000:

  • 9,059 of the 20,968 active licenses yielded income (43%)
  • These active licenses generated $1.26 billion of users in 2000
  • 125 (.6%) licenses generated in excess of $1,000,000
  • 57% of income is from running royalties
  • 13% of income is from cashed in equity
  • 30% of income is from other types of income (i.e., one time fees)

Data from the survey, indicates that the 190 reporting institutions spent $29.5 billion on research this year. Total research expenditures for each institution increased by approximately $474 million for the year. The total number of new patent applications submitted in 2000 increase 15% from the previous year with a 3% growth to 3,764 in total patents granted.

This continuing growth in funding and the trend of increased numbers of new patents and licenses each year, the need for a licensing service should only grow.

4.1 Market Segmentation

There are approximately 2,920 institutions of higher learning within the U.S. of that number, 1,106 are two-year city/community colleges, 1,590 are smaller four-year colleges and universities and 224 are major four-year universities. It is in the four-year universities that the majority of research is done.

52% of universities responding to the Association of University Technology Managers’ (AUTM) Licensing Survey: FY2000, report research expenses of less than $100 million. Additionally, 142 (mostly large universities) of the U.S. universities surveyed also reported only 479 full-time employees dedicated to licensing efforts.

Providing the respondents are a representative set of the university system as a whole, there are ~940 U.S. institutions spending less than $100 million on research, the majority of which have less than two individuals dedicated to creating licensing opportunities. These are also the most likely to have smaller staffs available to create licensing opportunities and therefore prime targets for University Patents.

The universities with research budgets under $100 million make up 61% of the institutions generating license revenues up to $5 million per year. Therefore, though these universities have less chance of generating a high value license, they are still generating a great deal of revenue.

Educational research business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Major 4 year univ. 3% 224 231 238 245 252 2.99%
2 year Colleges 3% 1,106 1,139 1,173 1,208 1,244 2.98%
Other 4 year Univ. 3% 1,590 1,638 1,687 1,738 1,790 3.01%
Total 3.00% 2,920 3,008 3,098 3,191 3,286 3.00%

4.2 Target Market Segment Strategy

With University Patents’ primary customers being universities, we will be encroaching on the responsibilities of their own offices of technology/research. However, through contacting the University of Notre Dame, Indiana University, Purdue University, the University of Idaho and researching the offices of technology at the University of Michigan and Michigan State University, we found that most university offices do not have the time and/or resources, nor the contacts in the business sector to effectively move new technology out to commercialization.

Strategy and Implementation Summary

University Patents has identified four-year universities with research budgets under $100 million and smaller office of technology staffs as the primary target market. They are located throughout the geographic U.S. and these universities are the major source of research and patents awarded to higher-learning institutions in the U.S. There are approximately 940 institutions in this classification. University Patents will position itself not as a competitor to these universities’ offices of technology, but rather as a service provider and partner. As their partner, University Patents will use its network of business contacts to search out various uses of the new technology and customers in these fields willing to become licensees. Once a potential licensee is found, University Patents will take a mediator position and using our license calculation methods, provide a base starting range for negotiations.

5.1 Competitive Edge

University Patents’ initial competitive advantage will be its reduced cost structure. University Patents will be able to service multiple colleges and universities at a cost comparable to what each school would have to pay to effectively provide these services to only themselves. By spreading operating expenses over multiple clients, University Patents will create a competitive advantage over university technology offices.

Once University Patents has established itself, an additional competitive advantage will be its reputation for service to both the research institutions and commercial businesses. Universities will be able to contact University Patents and know that within weeks they will have a list of prospective licensees and contacts at each business. Businesses will be able to contact University Patents and know that our database will contain information about our client universities’ research projects available for licensing. University Patents will be the company to call by parties on both sides of the transaction. This is extremely important because these will be the only barriers to entry into the market.

University Patents will not bring the actual license writing in-house, as that would both entail further hiring of legal resources, which is not a core competency of this company, and possibly require University Patents to litigate in cases of patent infringement and/or license enforcement. University Patents will remain a patent broker.

5.2 Marketing Strategy

University Patents will initially target colleges and universities that have a current supply of marketable patents but a small office of technology (~five staff members of less). During the first year, University Patents would like to have at least four institutions from which to license patents. The benefits that University Patents will focus on providing these institutions are: income from previously dormant patents, status and recognition for their research, and a cost effective way to transfer new technologies to the marketplace.

Initial contact to universities will be made through references from the University of Notre Dame Office of Research or other similar departments. This will provide the credibility that University Patents will need in the start-up phase of business. Contacts with commercial business will be made through any means necessary, as University Patents will begin compiling a database of contacts within multiple industries. It is at this point where we believe the technology and the developer will help with the eventual sale of the license. Assuming University Patents has a desirable technology to sell, the licensing income will soon follow.

Once University Patents has established itself as a legitimate player in the marketplace, University Patents expects to fund a full-time staff. University Patents will expand the number of universities that it will target and will be able to promote the network it has recently established. To these new customers, University Patents will provide value on two different levels. First, the network of private industry contacts will decrease the time-to-license and the number of licenses possible. Secondly, by using University Patents as an outsourcing resource, the universities can avoid the costs of a full-time staff.

The future vision for University Patents includes regional offices, each with their own expertise, such as pharmaceutical/chemistry, electronics, computer sciences, and etc. This allows each office to provide a local point of contact to University Patents but also to avoid the duplication of services that would arise if it tried to service all industries in each office.

5.3 Sales Strategy

University Patents will use the detailed information provided by the technology analysis to create a list of possible licensees. Using any personal contacts in the industry, we will make initial contact to set up a more formal meeting. Even for those contacts that do not become licensees, we will use the contact time for both contact mining for further possible license outlets and attempt to set up an informal relationship for future information gathering opportunities and licensee searches.

5.3.1 Sales Forecast

University Patents is planning on an initial sales of four licenses written during Year 1. During Year 2, eight new licenses will be written and in Year 3, 16 new licenses. Years 4 and 5 expect growth of 13 and 11 additional new licenses per year respectively. This is possible as management begins concentrating on this business in a full-time respect.

  • Income per license = $12,750
  • First year sales = 4 licenses
Educational research business plan, strategy and implementation summary chart image

Educational research business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3 Year 4 Year 5
Sales
License Sales $51,000 $102,000 $204,000 $369,750 $510,000
Other $0 $0 $0 $0 $0
Total Sales $51,000 $102,000 $204,000 $369,750 $510,000
Direct Cost of Sales Year 1 Year 2 Year 3 Year 4 Year 5
Travel Cost Per License $8,400 $16,800 $25,200 $37,800 $50,400
Demo Model $4,000 $8,000 $12,000 $18,000 $24,000
Legal $4,000 $8,000 $12,000 $18,000 $24,000
Subtotal Direct Cost of Sales $16,400 $32,800 $49,200 $73,800 $98,400

5.4 Milestones

  • Four patents written in first year.
  • Twelve active patents by end of Year 2 (this will provide University Patents with a positive cash flow for the fiscal year).
  • Twenty nine active patents by end of Year 4 (provides enough future to sustain full-time employment for founders).

Management Summary

Advisory Board

Mr. Michael Edwards, ND Office of Technology. Mr. Edwards had experience with technology transfer between the university and the private sector. He also has experience with licensing patents and negotiations. There is a potential conflict of interest with being a future customer.

Mr. James O’Brien, lawyer and ND professor. Mr. O’Brien has expertise with intellectual property rights.

Mr. Jeffrey Bernel, ND Professor and Gigot Center Advisor. Mr. Bernel has experience as a start-up business advisor and general management expertise. He also brings a valuable perspective from the manufacturer sector, a group that we hope to include in future customers.

Advisory Board Gaps

Technology Application: An individual with commercial network contacts from prior work in this field.

Business-to-Business Marketing Advisor: Unidentified Sales/Marketing Representative.

6.1 Management Team

Tom Bradbeer, president, Southwest region director and founding partner. Tom brings nine years of high-tech experience with Intel Corp including time in project management, database management, Web application development and customer support roles in both the 3-Business Group and Logistics Division. Due to his high-tech background, he will also be performing IT functions as University Patents grows in the first years. Tom has also coached Junior Olympic Volleyball teams over the past eight years including two years as head coach and fulfilled the role of mentor to other coaches in the organization. Tom is completing his MBA at the University of Notre Dame and earned his BS in finance at Arizona State University.

Jason Sorge, VP of market/sales, Northwest/Midwest region director and founding partner. Jason brings two years experience in finance from Agilent Technologies where he was instrumental in creating financial models to forecast expenses, training of corporate personnel in asset accounting procedures and research and analysis of financial data supporting forecasting for both the site facility and the multi-national marketing groups. Jason was also influential in the development of a centralized customer service center at the University of Idaho. Beyond his VP responsibilities, Jason will also maintain University Patents’ relationship with the retained law firms. He is currently completing his MBA at the University of Notre Dame and holds a BS in finance from the University of Idaho.

Matt Anderson, VP of finance/accounting, Southeast region director and founding partner. Matt brings three years of management in financial services, during which he was responsible for maintaining the service relationships for 401(k) plans in excess of $2 billion at Merrill Lynch. Matt managed the Merrill Lynch stock options trading center for two years during which it received the FCall Center Magazine’s “2001 Call Center of the Year” award and was the winner of the Merrill Lynch Quality Cup. He holds both NASD Series 7 and 63 licenses and in his off time volunteers as a Certified Youth Minister for local parishes, which has included planning and facilitating retreats.  Matt is currently completing his MBA at the University of Notre Dame and holds a BS in business administration from the University of Central Florida.

6.2 Management Team Gaps

The gaps in the management team are currently being addressed through the Advisory Board as shown below, and will continue to be until the cash flow allows the hiring of employees to fill those capacities. The identifiable gaps are in specialized technical knowledge, legal expertise, and B2B marketing.

Technical Knowledge: The current management team does not include an individual with a engineering/scientific background which would help with understanding the patented currently and effectively market it.

Legal Expertise: The current management team does not include an individual with a legal background. This could impact the companies ability to recognize possible forms of patent infringement.

Marketing Experience: The current management team does not include an individual with extensive B2B marketing experience.

6.3 Personnel Plan

It is expected that for the first four years, only the founding members will be employed by University Patents. Starting in Year 4, the number of patents to research will increase to the point that part-time or full-time help is needed to allow management face time with the universities and prospective licensees.

Personnel Plan
Year 1 Year 2 Year 3 Year 4 Year 5
Total Payroll $60,000 $63,000 $66,150 $210,000 $255,500
Other $0 $0 $0 $0 $0
Total People 4 4 4 4 5
Total Payroll $60,000 $63,000 $66,150 $210,000 $255,500

Financial Plan

The following is the Financial Plan for University Patents.

7.1 Important Assumptions

  • University Patents will operate with regional offices out of the founders’ homes, without a formal brick and mortar location, into Year 4.
  • The founders will be the only employees and work on a part-time basis during Years 1-3.
  • The average license value to University Patents will be $12,750 (15% of the predicted $85,000 average revenue to the university).
  • There will be a 10% loss of revenue from year to year due to un-renewed licenses.
General Assumptions
Year 1 Year 2 Year 3 Year 4 Year 5
Plan Month 1 2 3 4 5
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0

7.2 Break-even Analysis

The break-even point for University Patents is shown below.

Educational research business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $9,232
Assumptions:
Average Percent Variable Cost 32%
Estimated Monthly Fixed Cost $6,263

7.3 Projected Profit and Loss

The following is the Projected Profit and Loss for University Patents.

Educational research business plan, financial plan chart image

Educational research business plan, financial plan chart image

Educational research business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3 Year 4 Year 5
Sales $51,000 $102,000 $204,000 $369,750 $510,000
Direct Cost of Sales $16,400 $32,800 $49,200 $73,800 $98,400
Other $0 $0 $0 $0 $0
Total Cost of Sales $16,400 $32,800 $49,200 $73,800 $98,400
Gross Margin $34,600 $69,200 $154,800 $295,950 $411,600
Gross Margin % 67.84% 67.84% 75.88% 80.04% 80.71%
Expenses
Payroll $60,000 $63,000 $66,150 $210,000 $255,500
Sales and Marketing and Other Expenses $1,500 $1,500 $1,500 $1,500 $1,500
Depreciation $0 $0 $0 $0 $0
Computer Equipment $0 $0 $0 $0 $600
Utilities $1,000 $1,050 $1,103 $1,158 $1,216
Insurance $1,000 $1,050 $1,103 $1,158 $1,216
Payroll Taxes $9,000 $9,450 $9,923 $31,500 $38,325
ISP Access $2,160 $2,268 $2,381 $2,500 $2,625
Information Services $500 $525 $551 $579 $608
Total Operating Expenses $75,160 $78,843 $82,711 $248,395 $301,590
Profit Before Interest and Taxes ($40,560) ($9,643) $72,089 $47,555 $110,010
EBITDA ($40,560) ($9,643) $72,089 $47,555 $110,010
Interest Expense $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $21,627 $14,267 $33,003
Net Profit ($40,560) ($9,643) $50,462 $33,289 $77,007
Net Profit/Sales -79.53% -9.45% 24.74% 9.00% 15.10%

7.4 Projected Cash Flow

The following is the Projected Cash Flow for University Patents.

Educational research business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3 Year 4 Year 5
Cash Received
Cash from Operations
Cash Sales $12,750 $25,500 $51,000 $92,438 $127,500
Cash from Receivables $19,444 $57,694 $115,388 $216,192 $330,783
Subtotal Cash from Operations $32,194 $83,194 $166,388 $308,630 $458,283
Additional Cash Received
Sales Tax, VAT, HST/GST Received $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0
New Investment Received $30,000 $30,000 $0 $0 $0
Subtotal Cash Received $62,194 $113,194 $166,388 $308,630 $458,283
Expenditures Year 1 Year 2 Year 3 Year 4 Year 5
Expenditures from Operations
Cash Spending $60,000 $63,000 $66,150 $210,000 $255,500
Bill Payments $27,360 $48,845 $84,203 $123,250 $173,299
Subtotal Spent on Operations $87,360 $111,845 $150,353 $333,250 $428,799
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0
Subtotal Cash Spent $87,360 $111,845 $150,353 $333,250 $428,799
Net Cash Flow ($25,166) $1,349 $16,034 ($24,620) $29,484
Cash Balance $31,084 $32,433 $48,467 $23,847 $53,331

7.5 Projected Balance Sheet

The following is the Projected Balance Sheet for University Patents.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3 Year 4 Year 5
Assets
Current Assets
Cash $31,084 $32,433 $48,467 $23,847 $53,331
Accounts Receivable $18,806 $37,613 $75,225 $136,345 $188,063
Other Current Assets $0 $0 $0 $0 $0
Total Current Assets $49,890 $70,045 $123,692 $160,192 $241,393
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0
Total Assets $49,890 $70,045 $123,692 $160,192 $241,393
Liabilities and Capital Year 1 Year 2 Year 3 Year 4 Year 5
Current Liabilities
Accounts Payable $4,200 $3,998 $7,183 $10,394 $14,588
Current Borrowing $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0
Subtotal Current Liabilities $4,200 $3,998 $7,183 $10,394 $14,588
Long-term Liabilities $0 $0 $0 $0 $0
Total Liabilities $4,200 $3,998 $7,183 $10,394 $14,588
Paid-in Capital $100,000 $130,000 $130,000 $130,000 $130,000
Retained Earnings ($13,750) ($54,310) ($63,953) ($13,491) $19,798
Earnings ($40,560) ($9,643) $50,462 $33,289 $77,007
Total Capital $45,690 $66,047 $116,509 $149,798 $226,805
Total Liabilities and Capital $49,890 $70,045 $123,692 $160,192 $241,393
Net Worth $45,690 $66,047 $116,509 $149,798 $226,805

7.6 Business Ratios

Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 8748, [Business Consulting, nec], are shown for comparison.

Ratio Analysis
Year 1 Year 2 Year 3 Year 4 Year 5 Industry Profile
Sales Growth 0.00% 100.00% 100.00% 81.25% 37.93% 8.18%
Percent of Total Assets
Accounts Receivable 37.70% 53.70% 60.82% 85.11% 77.91% 29.59%
Other Current Assets 0.00% 0.00% 0.00% 0.00% 0.00% 41.37%
Total Current Assets 100.00% 100.00% 100.00% 100.00% 100.00% 75.36%
Long-term Assets 0.00% 0.00% 0.00% 0.00% 0.00% 24.64%
Total Assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Current Liabilities 8.42% 5.71% 5.81% 6.49% 6.04% 31.49%
Long-term Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 16.85%
Total Liabilities 8.42% 5.71% 5.81% 6.49% 6.04% 48.34%
Net Worth 91.58% 94.29% 94.19% 93.51% 93.96% 51.66%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Gross Margin 67.84% 67.84% 75.88% 80.04% 80.71% 100.00%
Selling, General & Administrative Expenses 147.37% 77.30% 51.15% 71.04% 65.61% 82.59%
Advertising Expenses #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 1.16%
Profit Before Interest and Taxes -79.53% -9.45% 35.34% 12.86% 21.57% 1.47%
Main Ratios
Current 11.88 17.52 17.22 15.41 16.55 1.93
Quick 11.88 17.52 17.22 15.41 16.55 1.50
Total Debt to Total Assets 8.42% 5.71% 5.81% 6.49% 6.04% 3.09%
Pre-tax Return on Net Worth -88.77% -14.60% 61.87% 31.75% 48.50% 59.56%
Pre-tax Return on Assets -81.30% -13.77% 58.28% 29.69% 45.57% 7.63%
Additional Ratios Year 1 Year 2 Year 3 Year 4 Year 5
Net Profit Margin -79.53% -9.45% 24.74% 9.00% 15.10% n.a
Return on Equity -88.77% -14.60% 43.31% 22.22% 33.95% n.a
Activity Ratios
Accounts Receivable Turnover 2.03 2.03 2.03 2.03 2.03 n.a
Collection Days 52 135 135 139 155 n.a
Accounts Payable Turnover 7.51 12.17 12.17 12.17 12.17 n.a
Payment Days 27 31 23 25 26 n.a
Total Asset Turnover 1.02 1.46 1.65 2.31 2.11 n.a
Debt Ratios
Debt to Net Worth 0.09 0.06 0.06 0.07 0.06 n.a
Current Liab. to Liab. 1.00 1.00 1.00 1.00 1.00 n.a
Liquidity Ratios
Net Working Capital $45,690 $66,047 $116,509 $149,798 $226,805 n.a
Interest Coverage 0.00 0.00 0.00 0.00 0.00 n.a
Additional Ratios
Assets to Sales 0.98 0.69 0.61 0.43 0.47 n.a
Current Debt/Total Assets 8% 6% 6% 6% 6% n.a
Acid Test 7.40 8.11 6.75 2.29 3.66 n.a
Sales/Net Worth 1.12 1.54 1.75 2.47 2.25 n.a
Dividend Payout 0.00 0.00 0.00 0.00 0.00 n.a

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
License Sales 0% $0 $0 $0 $12,750 $0 $0 $12,750 $0 $0 $0 $12,750 $12,750
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $0 $12,750 $0 $0 $12,750 $0 $0 $0 $12,750 $12,750
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Travel Cost Per License $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Demo Model $0 $0 $0 $1,000 $0 $0 $1,000 $0 $0 $0 $1,000 $1,000
Legal $0 $0 $0 $1,000 $0 $0 $1,000 $0 $0 $0 $1,000 $1,000
Subtotal Direct Cost of Sales $700 $700 $700 $2,700 $700 $700 $2,700 $700 $700 $700 $2,700 $2,700
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Total Payroll 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000

Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $0 $12,750 $0 $0 $12,750 $0 $0 $0 $12,750 $12,750
Direct Cost of Sales $700 $700 $700 $2,700 $700 $700 $2,700 $700 $700 $700 $2,700 $2,700
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $700 $700 $700 $2,700 $700 $700 $2,700 $700 $700 $700 $2,700 $2,700
Gross Margin ($700) ($700) ($700) $10,050 ($700) ($700) $10,050 ($700) ($700) ($700) $10,050 $10,050
Gross Margin % 0.00% 0.00% 0.00% 78.82% 0.00% 0.00% 78.82% 0.00% 0.00% 0.00% 78.82% 78.82%
Expenses
Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Sales and Marketing and Other Expenses $0 $0 $0 $500 $0 $0 $0 $500 $0 $0 $0 $500
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Computer Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $80 $80 $80 $80 $85 $85 $85 $85 $85 $85 $85 $85
Insurance $80 $80 $80 $80 $85 $85 $85 $85 $85 $85 $85 $85
Payroll Taxes 15% $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
ISP Access 15% $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180
Information Services $40 $40 $40 $40 $40 $40 $40 $40 $45 $45 $45 $45
Total Operating Expenses $6,130 $6,130 $6,130 $6,630 $6,140 $6,140 $6,140 $6,640 $6,145 $6,145 $6,145 $6,645
Profit Before Interest and Taxes ($6,830) ($6,830) ($6,830) $3,420 ($6,840) ($6,840) $3,910 ($7,340) ($6,845) ($6,845) $3,905 $3,405
EBITDA ($6,830) ($6,830) ($6,830) $3,420 ($6,840) ($6,840) $3,910 ($7,340) ($6,845) ($6,845) $3,905 $3,405
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,830) ($6,830) ($6,830) $3,420 ($6,840) ($6,840) $3,910 ($7,340) ($6,845) ($6,845) $3,905 $3,405
Net Profit/Sales 0.00% 0.00% 0.00% 26.82% 0.00% 0.00% 30.67% 0.00% 0.00% 0.00% 30.63% 26.71%

Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $3,188 $0 $0 $3,188 $0 $0 $0 $3,188 $3,188
Cash from Receivables $0 $0 $0 $0 $319 $9,244 $0 $319 $9,244 $0 $0 $319
Subtotal Cash from Operations $0 $0 $0 $3,188 $319 $9,244 $3,188 $319 $9,244 $0 $3,188 $3,506
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $30,000 $0 $0
Subtotal Cash Received $0 $0 $0 $3,188 $319 $9,244 $3,188 $319 $9,244 $30,000 $3,188 $3,506
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Bill Payments $61 $1,830 $1,830 $1,913 $4,247 $1,840 $1,907 $3,790 $2,324 $1,845 $1,912 $3,862
Subtotal Spent on Operations $5,061 $6,830 $6,830 $6,913 $9,247 $6,840 $6,907 $8,790 $7,324 $6,845 $6,912 $8,862
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $5,061 $6,830 $6,830 $6,913 $9,247 $6,840 $6,907 $8,790 $7,324 $6,845 $6,912 $8,862
Net Cash Flow ($5,061) ($6,830) ($6,830) ($3,726) ($8,928) $2,404 ($3,719) ($8,471) $1,920 $23,155 ($3,724) ($5,355)
Cash Balance $51,189 $44,359 $37,529 $33,803 $24,875 $27,279 $23,559 $15,088 $17,008 $40,164 $36,439 $31,084

Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $56,250 $51,189 $44,359 $37,529 $33,803 $24,875 $27,279 $23,559 $15,088 $17,008 $40,164 $36,439 $31,084
Accounts Receivable $0 $0 $0 $0 $9,563 $9,244 $0 $9,563 $9,244 $0 $0 $9,563 $18,806
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $56,250 $51,189 $44,359 $37,529 $43,366 $34,119 $27,279 $33,122 $24,332 $17,008 $40,164 $46,002 $49,890
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $56,250 $51,189 $44,359 $37,529 $43,366 $34,119 $27,279 $33,122 $24,332 $17,008 $40,164 $46,002 $49,890
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $1,769 $1,769 $1,769 $4,186 $1,779 $1,779 $3,712 $2,262 $1,784 $1,784 $3,717 $4,200
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $1,769 $1,769 $1,769 $4,186 $1,779 $1,779 $3,712 $2,262 $1,784 $1,784 $3,717 $4,200
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,769 $1,769 $1,769 $4,186 $1,779 $1,779 $3,712 $2,262 $1,784 $1,784 $3,717 $4,200
Paid-in Capital $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $100,000 $100,000 $100,000
Retained Earnings ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750) ($13,750)
Earnings $0 ($6,830) ($13,660) ($20,490) ($17,070) ($23,910) ($30,750) ($26,840) ($34,180) ($41,025) ($47,870) ($43,965) ($40,560)
Total Capital $56,250 $49,420 $42,590 $35,760 $39,180 $32,340 $25,500 $29,410 $22,070 $15,225 $38,380 $42,285 $45,690
Total Liabilities and Capital $56,250 $51,189 $44,359 $37,529 $43,366 $34,119 $27,279 $33,122 $24,332 $17,009 $40,164 $46,002 $49,890
Net Worth $56,250 $49,420 $42,590 $35,760 $39,180 $32,340 $25,500 $29,410 $22,070 $15,225 $38,380 $42,285 $45,690