Brilliant Points, Inc.

Start your own business plan »

Computer Laser Accessories Business Plan

Financial Plan

Details of Brilliant Points' financial plan are discussed in the following individual topics.

7.1 Important Assumptions

Some general assumptions about Brilliant Points' economic environment are shown in this table.

General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest Rate 8.00% 8.00% 8.00%
Long-term Interest Rate 10.00% 10.00% 10.00%
Tax Rate 25.42% 25.00% 25.42%
Other 0 0 0

7.2 Break-even Analysis

This break-even analysis is based on the projected fixed costs (office, utilities, staff, and maintenance) for a fully-staffed 2-year company.  Near-term sales and revenue are expected to be quite low for approximately six to twelve months, ramping up quickly after that as licensing deals close and "update" kit sales ramp up.

The analysis uses a target figure of $50 net revenue for each "presentation seat" filled with Brilliant Points technology.  A "presentation seat" consists of a computer, a projector, a camera (webcam or similar), a pointer, and software.  Over and above the cost-of-goods for the seat, assuming Brilliant Points provides everything for a seat, Brilliant Points would net a minimum of $50 revenue for the use of the Brilliant Points technology.  Because there are existing installations which have a computer and a projector, "update" kits will be created and sold which consist of a camera, a pointer, and software to enable the Brilliant Points technology.  During the initial two years, the majority of "presentation seats" filled would be through the "update" kit route.  As licenses are put into place, more and more of these seats would be filled through licensee equipment sales.  It is expected that "update" kit volume would peak around 4 to 5 years and begin to decline as greater penetration of the OEM/Reseller market for the devices in a presentation seat occurs.

Market research data shows that approximately 1,400,000 business projectors were sold in 2001, giving a good starting figure for existing installed presentation seats.  We target filling 30% (400,000 seats, cumulative) of these existing seats by the end of the 4th year in operations through a combination of upgrade kits and replacements with licensee equipment, either of which nets the $50 estimate.  Additional revenue will be generated by placement of licensee equipment in new presentation seats.  Because business projector sales are projected to grow from the 1,400,000 in 2001 to approximately 4,500,000 in 2007, we feel this target is both conservative and achievable.

The break-even analysis shows that approximately 3,000 presentation seats must be filled on a monthly basis to reach break-even for fixed costs (including salaries) and approximately 4,400 to cover projected variable costs, for an annual total of about 53,000 presentation seats per year.  We expect to exceed this rate between 13 and 15 months in business, becoming revenue-positive during the second year of operations, and profitable during our third year.

Break-even Analysis
Monthly Revenue Break-even $205,138
Average Percent Variable Cost 0%
Estimated Monthly Fixed Cost $205,138

7.3 Projected Profit and Loss

The following Profit & Loss table attempts to forecast expenses over the first three years in business.

Advertising/Promotion and Travel:  It is anticipated that marketing and travel will be significant expenses due to the need to present and demonstrate Brilliant Points technology to a wide audience.

Miscellaneous:  Attempts to account for unforseen petty-cash, office, travel, and repair expenses.

Depreciation:  Will need to be filled in as capital equipment and other depreciable items are purchased.

Leased Equipment:  TBD.  We anticipate some larger-cost items will be leased rather than purchased.

Insurance:  We are in the process of obtaining insurance quotes from several providers and will replace these figures with more accurate data when the quotes arrive.  These figures are based on simple scaling of existing liability and damage insurance to account for the increased personnel and office space.

Rent: Shows zero for the first year because the entire first year's lease is included in start-up costs.

Contract/Consultants:  Attempts to budget for attorney time for patent work, IP protection, etc., and additional consulting time that may be needed.

Interest Expense Short-term:  Shows interest which would be paid based on assumed short-term rates and immediate full draw-down of corporate line-of-credit.  There is, at present, no short-term debt.

Interest Expense Long-term:  We have no current long-term debt and have no present plans to incur any.

Taxes Incurred:  Automatically calculated based on computed profits and assumed corporate tax rate (see Sect.  7.1).

Extraordinary Items:  We do not anticipate any extraordinary expenses during the first three years of operations.

These figures will be pinned down with more accuracy by the VP of Operations and the Director of Finance during the first quarter once we have a better handle on office space, travel and marketing estimates from the VP of Marketing and VP of Sales, and insurance coverage.

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $645,500 $5,600,000 $8,800,000
Direct Cost of Sales $0 $0 $0
Other $0 $0 $0
Total Cost of Sales $0 $0 $0
Gross Margin $645,500 $5,600,000 $8,800,000
Gross Margin % 100.00% 100.00% 100.00%
Payroll $1,398,200 $1,657,000 $1,768,000
Sales and Marketing and Other Expenses $619,000 $876,000 $1,088,000
Depreciation $0 $0 $0
Leased Equipment $20,000 $30,000 $40,000
Utilities $0 $0 $0
Insurance $5,000 $6,000 $7,000
Rent (Full Services, 1st year covered in startup costs) $0 $85,000 $100,000
Payroll Taxes $419,460 $497,100 $530,400
Other $0 $0 $0
Total Operating Expenses $2,461,660 $3,151,100 $3,533,400
Profit Before Interest and Taxes ($1,816,160) $2,448,900 $5,266,600
EBITDA ($1,816,160) $2,448,900 $5,266,600
Interest Expense $20,000 $20,000 $20,000
Taxes Incurred $0 $607,225 $1,333,511
Net Profit ($1,836,160) $1,821,675 $3,913,089
Net Profit/Sales -284.46% 32.53% 44.47%

7.4 Projected Cash Flow

The following Projected Cash Flow table shows anticipated cash movement.  With respect to the corporate line-of-credit, it shows immediate full draw-down and associated interest expense when in fact the draw on this line will only occur as needed and no immediate interest will accrue.

According to the table, we are still cash flow-negative at the end of first year of operations, with a net loss (from the Profit and Loss table).  Assuming sales targets are hit, break-even is reached within the first quarter of second year of operations, and we show a net profit by the end of second year of operations, but have not recovered the first year's loss.  By the end of the third year of operations, we show significant profit, and have very nearly recovered the first year's loss.

Because Cash Balance never falls to the point that the corporate line-of-credit is required, the monthly interest payments shown in the Profit and Loss table do not exist, increasing Cash Balance for each year shown.

Cash Spent on Costs and Expenses:  This field is automatically computed based on expenses from Sect. 7.3 and the "Expenses in Cash %" assumption called out in Sect. 7.1.  "Expenses in Cash" shows how much of current expenses is paid out of cash, with the remainder carried over into Accounts Payable.

Payment of Accounts Payable:  This field is automatically computed based on the expenses rolled into Accounts Payable, and cover a portion of the current month's Accounts Payable plus the previous month's remaining Accounts Payable.

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $645,500 $5,600,000 $8,800,000
Subtotal Cash from Operations $645,500 $5,600,000 $8,800,000
Additional Cash Received
Sales Tax, VAT, HST/GST Received $0 $0 $0
New Current Borrowing $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0
New Long-term Liabilities $0 $0 $0
Sales of Other Current Assets $0 $0 $0
Sales of Long-term Assets $0 $0 $0
New Investment Received $0 $0 $0
Subtotal Cash Received $645,500 $5,600,000 $8,800,000
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $1,398,200 $1,657,000 $1,768,000
Bill Payments $963,925 $2,066,504 $3,036,917
Subtotal Spent on Operations $2,362,125 $3,723,504 $4,804,917
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $0 $0 $0
Dividends $0 $0 $0
Subtotal Cash Spent $2,362,125 $3,723,504 $4,804,917
Net Cash Flow ($1,716,625) $1,876,496 $3,995,083
Cash Balance $1,349,375 $3,225,870 $7,220,953

7.5 Projected Balance Sheet

The following Projected Balance Sheet table shows anticipated corporate balances.  As indicated in the Projected Cash Flow topic, with respect to the corporate line-of-credit, it shows immediate full draw-down and associated interest expense when in fact the draw on this line will only occur as needed and no immediate interest will accrue.

The table shows that by the end of second year of operations we have recovered the first year's loss, and very nearly covered start-up expenses as well.

Note that these assumptions are based on achieving only 2.5% penetration of the Business Presentation market by the end of third year of operations.  Should market acceptance/demand be wide (probable), net revenue-per-seat potential be greater than $50 (almost certainty), licensing penetration be significantly greater (50% by some estimates), there is potential for revenues to reach into the hundreds of millions.  Note also that these projections rely only on revenue from the Business Presentation market.  Growth into the home entertainment/gaming markets will only enhance these figures.  Furthermore, there is significant potential for revenue in the areas covered by the currently pending patent applications, within the military and the optical pointer industries, as secure/complex/stabilized pointers are developed.  While we have not attempted to show the impact of these markets on the business plan, we feel that they independently hold as much or more potential than the Business Presentation market.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Current Assets
Cash $1,349,375 $3,225,870 $7,220,953
Other Current Assets $0 $0 $0
Total Current Assets $1,349,375 $3,225,870 $7,220,953
Long-term Assets
Long-term Assets $0 $0 $0
Accumulated Depreciation $0 $0 $0
Total Long-term Assets $0 $0 $0
Total Assets $1,349,375 $3,225,870 $7,220,953
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $119,535 $174,355 $256,349
Current Borrowing $250,000 $250,000 $250,000
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $369,535 $424,355 $506,349
Long-term Liabilities $0 $0 $0
Total Liabilities $369,535 $424,355 $506,349
Paid-in Capital $3,750,000 $3,750,000 $3,750,000
Retained Earnings ($934,000) ($2,770,160) ($948,485)
Earnings ($1,836,160) $1,821,675 $3,913,089
Total Capital $979,840 $2,801,515 $6,714,604
Total Liabilities and Capital $1,349,375 $3,225,870 $7,220,953
Net Worth $979,840 $2,801,515 $6,714,604

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 5406, Computers, peripherals and software, are shown for comparison.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth 0.00% 767.54% 57.14% 5.80%
Percent of Total Assets
Other Current Assets 0.00% 0.00% 0.00% 21.50%
Total Current Assets 100.00% 100.00% 100.00% 86.80%
Long-term Assets 0.00% 0.00% 0.00% 13.20%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 27.39% 13.15% 7.01% 43.70%
Long-term Liabilities 0.00% 0.00% 0.00% 11.20%
Total Liabilities 27.39% 13.15% 7.01% 54.90%
Net Worth 72.61% 86.85% 92.99% 45.10%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 100.00% 100.00% 100.00% 24.80%
Selling, General & Administrative Expenses 384.46% 67.47% 55.28% 15.60%
Advertising Expenses 66.15% 10.71% 8.18% 0.50%
Profit Before Interest and Taxes -281.36% 43.73% 59.85% 2.70%
Main Ratios
Current 3.65 7.60 14.26 1.93
Quick 3.65 7.60 14.26 0.92
Total Debt to Total Assets 27.39% 13.15% 7.01% 54.90%
Pre-tax Return on Net Worth -187.39% 86.70% 78.14% 5.50%
Pre-tax Return on Assets -136.07% 75.29% 72.66% 12.20%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin -284.46% 32.53% 44.47% n.a
Return on Equity -187.39% 65.02% 58.28% n.a
Activity Ratios
Accounts Payable Turnover 9.06 12.17 12.17 n.a
Payment Days 27 25 25 n.a
Total Asset Turnover 0.48 1.74 1.22 n.a
Debt Ratios
Debt to Net Worth 0.38 0.15 0.08 n.a
Current Liab. to Liab. 1.00 1.00 1.00 n.a
Liquidity Ratios
Net Working Capital $979,840 $2,801,515 $6,714,604 n.a
Interest Coverage -90.81 122.45 263.33 n.a
Additional Ratios
Assets to Sales 2.09 0.58 0.82 n.a
Current Debt/Total Assets 27% 13% 7% n.a
Acid Test 3.65 7.60 14.26 n.a
Sales/Net Worth 0.66 2.00 1.31 n.a
Dividend Payout 0.00 0.00 0.00 n.a