If you need a great model for financial planning...

If you just need to update your current business plan financial model, or develop a comprehensive budget, we have un-bundled the Microsoft® Excel® financial model templates from BizPlanBuilder so you can purchase them separately. (These are included with the full BizPlanBuilder application.)

After 20 years of development, this set of beautifully formatted financial planning & forecasting models that make up half of BizPlanBuilder are an extraordinary bargain for a system that you can actually use.

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. For $100, these rival other programs costing 10 times as much!

As an expert financial consultant, I was amazed at the depth of the package and its ease of use.
- Tom Devine, The Clayton Group, New York

Updated business forecasting system

This latest version of the BizPlanBuilder Financial Models have been thoroughly revised to include a number of improvements as well as an enhanced section for working with investors. These are comprehensive Excel-based financial projection models that will ensure that you cover everything you need to include as you are developing your business plan. 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.

Since 'Interactive' / v7:

• Everything has been overhauled.
• System converted to an Excel workbook with separate assumptions pages

Since v8/8.1:

• Valuation & Investor Analysis sections improved

Since v9:

• New Start-Up & Capital Requirements sections
• Use of Funds Summary: Takes the detail from the Start-Up' & 'Capital Requirements’ pages and shows investors how their investment will be used — includes bar & pie charts.
• Expanded market and profit center categories: enable more flexibility & easier presentation of growth & profit expectations.
• Updated Cashflow Assumptions: Actual cash balance appears in cashflow model provides immediate feedback of cash planning decisions.
• Valuation Model: Uses several proven methods for valuation including weighted average — how much is your business worth? Calculates various scenarios: pre-money, post-money, stock give-up, etc.
• Investor Scratch Pad: Let investors play with your assumptions and theirs on the Sensitivity (What-if…) Analysis page to see their ROI on your deal. Capitalization Table: Shows the value of all shares as you bring in investors through several rounds of financing and ultimately 'exit' via merger or IPO. Numerous user-requested tweaks throughout.

Excel workbook has everything you need

Since 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.

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.

Built in Excel enables unlimited customization for exact tailoring 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

At the top of each page, you'll find an explanation of how to work with each worksheet. The cells requiring input 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 — makes explaining easy

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, 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.

BizPlan Builder 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

This is a 'Download-Only' product
(NO Shipping Charges or Sales Tax!)