BizPlanBuilder financial models use Excel templates for total flexibility enabling exact customization to your business model
These are the latest generation of Excel workbook technology with every page automatically linked together. Take them one page at-a-time, or dive-in wherever you want, see where your financial intuition takes you. Test, learn, see the effects unfold as you make even the slightest changes.
Best of all, you can modify the financial template 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.
“Our company is a computer security software start-up. 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
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. It’s everything you need for preparing a comprehensive budget as well as a detailed financial model for skeptical 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. See “Loan Wizard” below for more details.
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. See “Financial Worksheets included” below to see how we get you there from here.
Refine your established business model
Even if you have an established business, BizPlanBuilder makes this otherwise challenging job much, much easier, taking you step-by-step through the process of forecasting expansion costs, sales, operating expenses, financing, capital investments, cash-flow, profits, valuation, stock give-up and everything else.
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.
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
← Map of the model with pop-up notes simplifies and helps you understand the logic and flow of financial forecasting.
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 be curious.)
Print pages individually or the entire financial plan.
Click across the color-coded tabs at the bottom of your screen to go to any statement or assumptions page you want.
← Click to see sample P/L screen.
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:
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.
“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 BizPlanBuilder financial models.”
~ Geir Ilstad, Prudent Management, Los Altos, CA
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.
If you are at all uncomfortable with finance — the language, concepts, meaning, anything — we have included comments within the cells to make sure you are clear about what is being asked. It won’t insult your intelligence, but it will prepare you to think, plan, and speak financially.
Now you can do the math and understand your numbers and deal.
(Even a right-brain “Artist” or non-financial person can use these models!)
← For example, the “Cap Table” shown here lets you play what-if? with certain stock scenarios and valuations.
“I really appreciate the work that went into building your model. I have looked at a lot of software models and your model is the best I have seen. I use it for most of the projects I work on.
~ Dr. Paul M. Wendee, DBA, CFP®, CBI, Managing Director, Paul M. Wendee & Associates, LLC, Dana Point, CA
Investors and lenders are still accustomed to reviewing “spreadsheets” and often ask many questions before they’ll authorize their money transfer to you. We want you to be ready for them. Some want a summary now, but want detail later and some have 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:
(Even the Assumptions pages are designed to be part of your plan presentation.)
Easily segment your markets and estimate penetration rates — investors often look here first.
It’s important to demonstrate clearly the magnitude of your opportunity. Investors always want to know how big the “universe” of potential customers is.
Build your “case” from the bottom-up.
The idea here is to enter the universe of available customers in a segment, then tweak the penetration %s to project unit sales. Input the entire universe of potential customers, by segments, 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.
Project by Unit Sales
If you prefer projecting unit sales first, play what-if? with market share to arrive at projected unit sales—investors understand this and the combination helps build your case that they’ll believe!
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.
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.
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.
This helps dramatically to enable you to make adjustments where necessary and for investors and lenders to intuitively understand your plan.
“As an experienced financial consultant, I was amazed at the depth of the package and its ease of use.”
– Tom Devine, The Clayton Group, New York, NY
This enables you to prioritize your cash requirements to reach certain valuation milestones desired by most sophisticated investors. (When you understand this, you will realize why your deal will work and others won’t!)
Adjust what you want to do with what money you have for a 9 month, 12 month, 18 month, etc. interval.
If investors were to put more in, they would finance the further depth and breadth of development.
They should be set at stages of evolution (prototype, roll-out, expansion) — each level brings the company a higher valuation. The farther you go, the more value you’ll build — where is the optimum investment point for you and your investor(s)?
“Fund our operation for  months. This is what we can do…”
A similar question is, “What’s your pre-money valuation?”
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.
(For example, if you demonstrate that your business is worth $900,000 and the investor puts in $100,000, they’d get 10% of the company. ($900K pre-money + $100K investment = $1 million post-money.) Can you build a case that your business is worth more? Use BizPlanBuilder…)
Because valuation 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:
1st Chicago Method
Discounted Future Cash-flow
Common VC Formula
Weighted Average (all of the above)
Learn more about the Valuation template page here: Business plan valuation template
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 were acquired or 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…
Automatic Financial Statements
Select financial projections from the buttons across the bottom of your screen. Use just what you need. Everything adds up. You can see the math. Expert comments appear to explain every variable.
“Gives me all the formats and financial, but isn’t a “canned” plan — it allows flexibility. Thanks.”
~ Jon Loveless, Strategic Business Solution, Dousman, WI