Changelog

Announced the next dates for How to Model Venture Funds and Cap Table and Exit Waterfall Masterclass, as well as the launch of cap table short courses.

Updates to the Standard Financial Model:

• Formula rationalization, reducing use of OFFSET and replacing with INDEX. Goal is to reduce use of volatile functions and improve performance (speed of recalculations). Forecast, Revenues, and Hiring Plan sheets first edit, will replace more OFFSET over time.
• Get Started and Revenues sheets, added new option for % billed upfront. Most cases it will be 100%, but in some cases (services, consulting, some enterprise contracts) there is a need for contracts to be paid at multiple times, on a non-every month or all billed upfront option. This implements a billing option where you can select to bill a % upfront in first month of contract, and the remainder at the end of the contract (on the last month of the contract)

Updates to the Standard Financial Model:

• Edits to Revenues sheet to create a new "bundling" feature. line 114 calculates the conversions after the conversion lag, line 115 is a bundling input, line 116 calculates conversions after bundling. some businesses may make sales over time, but when the sales start may not be the same period, but may bundle them together into groups. an example is in education, where you often sign up users but don't start charging them until school is in session, for example. this input is designed to say "yes" or "no" using a "1" or "0", respectively, to say whether the conversions should flow through (a "1") or be bundled and held until the next event ("0" until the period for them to flow through into the next "1"). Kind of specific for certain businesses; if you don't understand it, then it doesn't apply to you :)

Update to the Angel and Venture Fund Portfolio Tracking, updating the Actuals sheet for a calculation of GP catchup, to handle the situation where there is a preferred return and not GP catchup (no impact if not using the preferred return input).

Update to the Venture Capital Model, Annual Forecast, Detailed Investment Strategy, adding in prebuilt scenario analysis. Video with how to think about scenario analysis and how to use it is linked at the product page and inside the model, and below.

• Update to the Standard Financial Model and Runway Budgeting Tool, edited the timescale on Forecast sheet row 7, so that it corrects the fiscal year for the Summary sheet when the calendar year-end is not the same as the fiscal year-end. Previously, the Summary sheet would sum up the years still using calendar years rather than fiscal years, a simple change to the formula on row 7 updates this.
• Update to the Standard Financial Model, edited Hiring Plan so it uses the timescale from Forecast sheet, instead of recalculating the timescale. All sheets link to the timescale from Forecast so that they are all consistent, previously this one was independent but now it's tied to the Forecast sheet.
• Update to the Standard Financial Model, added a new assumption to Get Started for the revenue calculations on Revenues sheet so that the input for the starting number of revenue units is exposed on Get Started. No change in model functionality, just a slight addition to make it clearer where to make that input.

Added new page, Pricing, to make it easier to see all products, and updated homepage with a new product list and filter system,

Launched the Talent Collective to help users find professionals to assist with financial models for startups and funds, business plans, valuations, and more. Details here.

Adding Search to the header to make it easier to find content and documentation specific to your needs.

New addition to product pages, adding category groupings (all venture capital models and all startup models) to reviews and ratings. Previously the ratings and reviews reported the ratings and reviews for each product and all products, now I've added a third section (in the middle of the ratings options) that displays the category-specific ratings and reviews for that product's category.