Questions? Call us at 1-800-346-5426

20 years of Financial Model development

This set of beautifully formatted financial planning and forecasting models is an extraordinary bargain
These are the latest generation of Excel workbook technology with every page automatically linked together. Take them one page at-a-time, dive-in where you want, see where your financial intuition takes you. Whether you're good at this or not, the BizPlanBuilder system will work for you. Test, learn, see the effects unfold as you make even the slightest changes. Best of all, you can modify it as much as you want to tune it perfectly for your unique business model.

The BizPlanBuilder was a life saver in dealing with SBA loans and investors.
You have to be so perfect and BizPlanBuilder allowed me to do so. Thanks.
- Shirley Duncan, Duncan Enterprises, Wheeling, IL

You must fully understand the workings of your business model. Creating useful financial projections for your business can be tough, especially if yours is a brand new company with no financial history as any kind of backdrop.

Even if you have a running start, BizPlanBuilder makes this challenging job much, much easier, taking you step-by-step through the process of forecasting start-up / expansion costs, sales, operating expenses, financing, capital investments, cash-flow, profits, valuation, stock give-up and everything else.

Updated business forecasting system

This latest version of the BizPlanBuilder Financial Models have been thoroughly revised to assure that you cover everything you (and investors) need. All models show the math, include expert comments, and are easy to understand, use and present. And, like we've said before, they've been proven with more than a billion dollars in business financing.

Want a forecast but don't need outside money?
Use the BizPlanBuilder models as a cash forecasting / management system for a growing business not looking for outside capital. These will save you hours and hours of sweating over paper financials or trying to create your own spreadsheets from scratch. Get a full financial picture and have handy model to project "what-if..." happens next.

BizPlanBuilder is the best financial projections software I've used... Our company is a computer security software startup. We were asked by an important first customer and a venture fund to submit a project and venture funding proposal and business plan. I have done this with a few different companies over the past few years, and I like BizPlanBuilder better than the financial projection software packages I have tried, because of the unhindered flexibility to export it to an Excel workbook. Once I export it, I attach my own Excel worksheets to the workbook, to build up our own assumptions, then write formulas into the cells of the exported JIAN exported 'Assumptions' worksheet to suck values in from my various assumptions worksheets. Surprisingly, I don't know why, I couldn't get that unrestricted flexibility with your competitors. In fact, I opened the new "Comprehensive" model you sent me, and I am surprised to find that you at JIAN have now built in a bunch of assumptions worksheets just the way I have always done in the past.
That's great.
- Michael Culver, CFO, Aesec, Palo Alto, CA

Excel workbook has everything you need and makes it easy

Since we use Excel workbooks and link every worksheet together, you can click across the color-coded tabs at the bottom of your screen to go to any statement or assumptions page you want. Jump in and make changes. See what happens... more money or not? (CTRL+Z undoes it!) Simply fill-in / update the assumptions pages and the everything else is automatic. Lines that don't apply may simply be hidden or renamed for your purposes. (Assumptions pages are designed to be part of your plan presentation should an investor question your logic.) Print pages individually or the entire financial plan.

Unlimited customization for an exact fit to your unique business

Here is where most other systems crash and burn — they're rigid and inflexible. They're not written using Excel, they must import and that's where the trouble begins. Instead, BizPlanBuilder is based in Excel. It's easy to use and many people around can support you. From there you can easily customize these financials to fit your exact requirements:

• Add worksheets
• Link to or from outside spreadsheets
• Add or subtract lines or sections
• Change formulas
• Format to have them appear exactly the way you want them.

We've also made sure to keep the formulas simple so you can easily trace the logic if you need to. Now you can show how believable numbers can add up — unlike other financial models (input-> [black-box] -> output). Here you will see the math, and be able to explain "how you got there" in a clear and logical manner.

Why these models are so good:

• True "Flow-Through Financials" — enter your financial figures just once, and they'll automatically flow-through to all the other relevant statements, performing necessary calculations along the way!
• Exclusive "One-Page Sensitivity Analysis" — No need to create special "best-case" and "worst-case" scenarios, just enter up/down percentages next to each budget category to show what happens with higher sales or lower marketing costs.
• Create projections for up to five years out — year 1 by months, years 2-3 by quarters, years 1-5 by entire years
• Roll-over "Help Balloons" pop-up to provide convenient tips and advice as you build your financial plan
• Charts and graphs are automatically generated for you
• Beautifully formatted—your financials will look great to potential investors, lenders, etc.
• Built using Microsoft Excel®, the industry standard for generating compelling financial forecasts.
• To finish, you can check the boxes for just the pages your want to print or add to your plan.

Built-in expert advice on every page keeps you going

At the top of each page, you'll find an explanation of how to work with each worksheet. The cells requiring input also have bubble help — Roll your mouse over these cells for comments and suggestions for filling in each section of the model.

Every worksheet is linked together. Just click the tabs at the bottom to go to any assumptions page or statement you want.

Just enter your sales, expense, growth and other assumptions and variables and let the program run the calculations... It automatically calculates totals, percentages and ratios to show at a glance how much money you'll need, when you'll need it, and how soon you'll make a profit.

See "what-if" when you change scenarios. It's easy to update — If you change a number, the spreadsheets automatically recalculate for you.

What investors & lenders want to see — explains itself.

Investors and lenders have different ideas and often want to see something unexpected. We want you to be ready for them. Some want detail, some want a summary, others have some business fetish few can imagine. Nevertheless, using BizPlanBuilder, you can easily select what you need to be prepared with statement options:

• Year 1 by Months
• Years 2-3 by Quarters
• Years 1-5 by Year
• (All of the above)

Financial Worksheets included:
(Assumptions pages are designed to be part of your plan presentation.)
Macros enable you to print individual pages or the entire financial plan.

• Set-up by products, product lines, or profit centers
• Incorporate up to 3-years of historical financial data to show past, present & future continuum
• Start-up Costs / Summary Use of Proceeds
• Headcount & Space Planning (out to 5 years)
• Demand/Revenue Model (list potential customers x share x prices)
• Assumptions - Sales (easily adjust mix & seasonality from tables)
• Assumptions - Marketing (use % of sales or actual)
• Assumptions - COGS (use % of sales or actual)
• Assumptions - R&D (use % of sales or actual)
• Assumptions - G&A (use % of sales or actual)
• Assumptions - Cash-flow (enter debt, equity, etc. — shows cash balance from cash-flow statement to make it easy to see the effects of changes)
• Assumptions - Balance Sheet (use historical numbers if available)
• Assumptions - Financing. Five integrated financial calculators help plan future loan financing and automatically calculate all interest expense, loan repayment cash-flow, and balance sheet entries.
• Capitalization Table
• Personal Financial Statement (perfect for attaching to loan applications, etc.)

Financial Statements Included

• Financial Summary - consolidation of financial projections, plus headcount and capital requirements - automatically generated, including graphs and charts
• Gross Profit Analysis (by product/service)
• Income Statement (+ NOL carry-forward)
• Balance Sheet (with out-of-balance flag)
• Cash-flow Projection
• Sensitivity Analysis (What-if... all on ONE page!)
• Comprehensive Ratio Analysis (Shows 31 success indicators & trends—with ideas for corrections! Also includes direct links to BizStats.com enabling you to quickly compare with your industry. Free.)
• Valuation (see below)
• Investor Deal Development & Analysis (enables planning for several rounds of financing + IPO)
• Equity/Ownership Give-Up (see section below)

Charts Included

• Revenue / COGS / Profit
• Use of Funds
• Head-count

Loan Wizard automatically manages up to 5 different loans

Entering debt financing is easy.

Enter the loan start date, amount, and interest rate.

Interest expenses, cash flow and balance sheet line items are all automatically calculated — showing on separate line listings for each one on each statement for added clarity.

The blue text is variable so you can also label each loan with the title of your choice. These headings will also automatically copy to the Income Statement, Balance Sheet and Cash Flow statements where needed to identify their respective line-item calculations.

This helps dramatically to enable you to make adjustments where necessary and for investors and lenders to intuitively understand your plan.

Use this section to...

- Restructure debt to vendors.

- Purchase vehicles

- Borrow working capital

- Build up inventory

All loans are independently calculated so you can start them on any date from the beginning of your plan to any time in the future.

Financing Assumptions Statement below this "Loan Wizard" automatically summarizes all of your financing calculations here.

If / when you want to make a change, just update this page and everything else will recalculate and all changes will automatically appear in their proper places.

 

 

 

 

Updated: Revenue/Demand model demonstrates growth potential

It's important to demonstrate clearly the magnitude of your opportunity. Investors always want to know how big the "universe" of potential customers is. Input the entire universe of potential customers, then project your market share. Building upon that, estimate the % of customers who will buy at a given price... See how believable numbers add-up—by using BizPlanBuilder you'll be able to easily explain and justify your projections.

How much is your deal worth?

Important question. Investors will inevitably ask... and you need to have a good answer—especially one that has some good analysis behind it. This is a big part of any financial model and we use several methods to triangulate a respectable valuation for your business as well as to provide a credible explanation that you can use:

Harvard Model
1st Chicago Method
Discounted Future Cash-flow
Common VC Formula
Weighted Average (all of the above)

Return on Investment... Stock Give-up?

Given a certain amount of investment, how many shares would your investor(s) get? What % of the company would they own? (We included a calculation to help you see that you will still become wildly wealthy even when your investor(s) get rich too!) What might rounds two and three look like? If you went public (IPO), what might that look like? You must understand your deal! We also include a separate spreadsheet that helps you calculate your net return/profit if you were to sell your business.

Comprehensive Budget / Feasibility Plan: Bottom-up/Top-down system helps you build a complete financial picture—particularly valuable for start-up or growing businesses. This model also includes our exclusive one-page "Best/Worst" case (Sensitivity) Analysis, as well as business valuation and investor deal analysis.

Bank Loans: Linked statements for product or service businesses — great for presentation to SBA and lenders. Now includes updated Assumptions page — auto-fills entire model. Plus, 5 integrated financial calculators help plan future loan financing and automatically calculate all interest expense, loan repayment cash-flow, and balance sheet entries.

Basic Financial Statements: Stand-alone Income, Cash-flow & Balance Sheet put together a quick look at your financial picture — for businesses not necessarily seeking funding.