BizPlanBuilder financial models use Excel for maximum flexibility
Easily customize them in Excel for a unique model that exactly fits your business...
Questions? Call us at 1-800-346-5426
20+
years of development make these beautifully formatted financial forecasting
models the best on the market
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.
If you're a business planning pro, you will appreciate the flexibility of the BizPlanBuilder system as well as the quality of the content that you would expect — for you, this is a real working toolset.
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
Quantify your start-up 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.
Refine your established business model
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.
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
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, they've been proven with more than several billion dollars in business financing.
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. It's everything you need for preparing a comprehensive budget as well as a detailed financial model for angel investors and venture capitalists.
Bank Loans / SBA Financing: Linked statements for product or service businesses — great for presentation to SBA and lenders. Assumptions page auto-fills the entire model. Five integrated financial calculators help plan future loan financing and automatically calculate all interest expense, loan repayment cash-flow, and balance sheet entries. Scroll down for more details.
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.
Excel workbooks have everything you need and make 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.
Map of the model with pop-up notes simplifies and helps you understand the logic and flow of financial forecasting.
Unlimited customization allows 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 people say 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!
- 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.
- 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.
We've been using your financial model for financial analysis, partnering, M&A, and VC analysis here in Silicon Valley and in Europe. I have used a few other
programs like MoneySoft that cost $1500+ and yours are better, more accurate
and more detailed. I can trust the integrity of the Biz Plan Builder financial
models.
~ Geir Ilstad, Prudent Management, Los Altos, CA
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. Now you can do the math and understand your numbers and deal. (Even an "Artist" / non-financial person can use these models!)
Roll your mouse over any red triangle and an explanation immediately appears.
The "Cap Table" lets you play what-if? with certain stock scenarios and valuations.
Show investors & lenders what they want to see — Manages the 'pitch' for you
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 interests few can imagine. Nevertheless, using BizPlanBuilder, you can easily select what you need to print to be fully prepared with multiple 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.)
All 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:
• Market Segments
• Units Sold
• Revenue Projections / Profit Center / Product
• Revenue / COGS / Profit
• Seasonal Sales
• Headcount Growth & Personnel / Department
• Use of Funds
Charts & graphs can be easily customized in Excel to your needs.
Loan Wizard automatically manages up to 5 different loans
Modeling 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.
One of several Assumptions pages makes forecasting easy.
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.
Easily segment your markets and estimate penetration rates — investors often look here first.
"How much is your deal worth?"
This is an important question. Investors will inevitably ask it... 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:
Quickly analyze & compare various financing scenarios — for yourself as well as your investors
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, what might that look like? Perfect for busy CFOs as well as start-up entrepreneurs — the logical presentation especially saves time explaining to non-financial stake-holders. We also include a separate spreadsheet that helps you calculate your net return/profit if you were to sell your business.
Now you can easily develop a comprehensive financial plan for your business...
(Even an "Artist" / non-financial person can do the financial math and understand their numbers and deal!)