New Venture Lab: Equipping Christian Entrepreneurs

A New Version of the Startup Financial Model is Now Available

We are pleased to announce a new easier-to-use and more powerful Startup Financial Model

The new enhancements in the model include the following:
  • All assumptions and model inputs are now on one Assumptions worksheet with a simple step-by-step process that walks you through how to input your assumptions.  In most cases you can finish the process in less than an hour.  The Assumptions worksheet includes the following features of note:
    • Ability to input multiple products or services and multiple business model assumptions by product with various toggles such as Recurring Revenue vs. One-Time Revenue, Revenue Share, Lead Generation Fees, COGS, Shipping, and many other offering-related inputs
    • Many helpful tips embedded in the Excel comment fields to guide the user and offer suggestions during the assumptions input process
    • Automation of the names you prefer to use for customers and employee roles that appear in other parts of the model such as the Key Metrics worksheet, the Staff worksheet, and the Sales worksheet
    • Several different Direct Labor assumptions that automatically add Direct Labor staffing on a Revenue, Customer, and/or # of Direct Employees basis; Direct Labor costs will now automatically scale with your business based upon your sales assumptions
    • Sales and Account Management assumptions that scale with the size of your business in terms of either # of Customers or Revenue
    • An up-to-date U.S. Federal tax table that scales properly with the business earnings and made it easy to insert the assumptions for other country tax jurisdictions
    • Intangible Asset CapEx assumptions that are properly Amortized
    • Greatly simplified Debt and Equity inputs that are automatically inserted into their respective worksheets
    • A conditionally formatted Cash level indicator that changes from Green to Yellow to Red as your cash level in the plan changes as a helpful tip to show you when Debt or Equity may need to be added
  • All other worksheets are automatically updated without the need to enter any additional assumptions
  • The Scenario Analysis now includes a Macro to simplify the process of “freezing” the Base Case prior to making changes for an Alternative Scenario
More information about the new version is available at our companion site: Startup Financial Model

Please login to post a comment.

Register Now

Register now to gain access to all of the resources available on our site. Basic membership is free!