DIYBizPlan Logo
Return User Login
DIYBizPlan.com - Where Startups Get Started!
Home Free
Planning Software
Business Plan
Software Reviews
Startup Articles About Us Contact Us
Overall:
User Friendly:
Robustness:
Customizable:
End Product:
Value:
Overall:
User Friendly:
Robustness:
Customizable:
End Product:
Value:
     Essentially BizPlan Financial is a toolkit of Microsoft Excel spreadsheets pulled from the business planning program. Unlike BizPlan Builder this tool kit does not use the MIDAS system and therefore do not have the file sharing ability. The tool kit includes basic individual templates (income, cash flow, balance sheet, etc) that are not interconnected for the basic projections, the same intermediate model that we tested in the BizPlan Builder Review and a comprehensive model.
     This time we took a look at the Comprehensive financial model and this thing is wicked. It has some of the most advanced features we have ever seen in a projection program. The models are based on complex excel formulas, GAAP accounting rules and advanced finance formulas. This program is for spread sheet / accounting pros that have considerable time on their hands to figure out all the components. 
     The comprehensive model has some pretty cool features, like a summary page with key figures, charts and graphs that auto calculate. The valuation table is awesome and it has other features are more advanced than the average start-up user would ever need.
     The downside, obviously, is that it is difficult to tell where the numbers you input will end up.  And, once you get there the results are either hard coded (not changeable) or changes have to be made using percentages across the entire year. There are roughly 15 pages that require user input and each takes considerable time to view and understand what numbers are appropriate. At times it feels like you are doing the same thing two or three times. Knowing that financial projections are only as good as the inputs they are based on made us concerned about the quality of our own test projections.
     It suffices to say that the comprehensive model is not ideal for the most basic of start-ups.  The intermediate model would work but are a little cumbersome, it takes considerable time to complete correctly and is probably beyond the average PC user. The basic models are about the same as what you can find by searching for free financial templates. All in all, if you are a numbers and formulas freak this might work just fine for you but for the rest of us there are better options.
 
Highs: Knock Your Socks Off Analysis, Comprehensive & Customizable
Lows: A little cumbersome, lengthy instructions for projections and excel know-how requirement
Bottom Line: Highly advanced projections & analysis but definitely not for everyone.

BizPlan Financials
Editor pick
Order Now

 

     Biz Plan Financial v10 - $89.95
 View the Whole Line Of Jian Products at the DIYBizPlan - Jian Storefront

Excel workbook has everything you need

It's an Excel workbook with everything linked together. Just click across the tabs at the bottom of your screen to go to any statement or assumptions page you want. Lines that don't apply may simply be hidden or renamed for your purposes. Simply fill-in / update the assumptions pages and the everything else is automatic. (Assumptions pages are designed to be part of your plan presentation.) Macros enable you to print individually or the entire financial plan.

Straight-Forward + Flexible Financial Tools

All BizPlanBuilder financial models are now developed in linked Excel workbooks enabling you complete flexibility to customize them to your requirements. You don't have to be a spreadsheet or financial expert. (If you are, you can customize everything in Excel.) Just enter your sales, expense, growth and other assumptions and variables and let the program run the calculations.

Shows the math — makes explaining easy

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. See "what-if" when you change scenarios. 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. It's easy to update—If you change a number, the spreadsheets automatically recalculate for you.
Basic Financial Statements: Stand-alone Income, Cashflow & Balance Sheet put together a quick look at your financial picture — for businesses not necessarily seeking funding.
Bank Loans: Linked statements for product or service businesses - great for presentation to lenders.
Comprehensive Budget / Feasibilty 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.

Updated: Assumptions pages build entire model

Simply fill-in / update the assumptions pages and BizPlanBuilder automatically generates all of your statements. (We designed the "Assumptions" pages to be part of your plan presentation—making it easy for investors and lenders to understand your business and the logic behind your numbers.)
  •  Financial Summary - consolidation of financial projections, plus headcount and capital requirements - automatically generated, including graphs and charts
  • Set-up by products, product lines, or profit centers
  •  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)
  •  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 - Cashflow (enter debt, equity, etc. — shows cash balance from cashflow statement to make it easy to see the effects of changes)
  •  Assumptions - Balance Sheet (use historical numbers if available)
  •  Gross Profit Analysis (by product/service)
  •  Income Statement (+ NOL carry-forward)
  •  Balance Sheet (with out-of-balance flag)
  •  Cashflow 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)
  •  Capitalization Table
  •  Personal Financial Statement (perfect for attaching to loan apps, etc.)

Updated: Revenue model demonstrates growth potential

It's important to demonstrate clearly the magnitude of your opportunity. 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.

Business valuation calculations value your deal

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

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.
View the Whole Line Of Jian Products at the DIYBizPlan - Jian Storefront

Biz Plan Financial v10 (Download Only) - $89.95

Order Now
 
Home | Free Planning Software | Business Plan Software Reviews | Startup Articles | Terms of Use | About Us | Contact Us
Start-Up Software LLC    PO Box 10215 Fargo, ND 58106-0215    (888) 541-0687