Changelog

• Adding prebuilt anti-dilution protection to the default Cap Table sheet.
• This is a beta release of the feature, and will change based on feedback, but aims to add in full ratchet and weighted average (broad-based and narrow-based) if selected and if applicable based on new share prices.
• The feature is not fully automatic, as you will need to select the type of anti-dilution protection and input the purchase price from the previous equity round.
• This calculates the same protection for all preferred shareholders, although if shareholders have different original purchase prices their anti-dilution protection will be different.
• I do expect to change the approach to make it more flexible and automatic based on user feedback and use.

More at Modeling Anti-Dilution

• Fixed estimated taxes payable to use Taxes instead of Salaries lines, row 420 and 421 in the current Forecast default (thank you to user for finding this).

This was a webinar with Tactyc on how to use the forecast you created for fundraising your venture fund to actively manage your investing activity.

Tactyc is a platform for forecasting and scenario planning platform for venture capitalists. The software enables funds to construct, manage and forecast venture portfolios and empowers GPs to be more data-driven in capital and reserve allocations. Learn more at Tactyc.

• Fixed COGS calculation in the inventory section (row 449 in the current default) on Forecast to add to the SUMIFS to also look for Cost of Sales, so that it didn't accidentally pick up advertising and marketing costs used for CAC analysis.

• Extended the Revenues build (with additional assumptions on Get Started) to allow for a % of new revenue units to select two different churn / repeat cycles with separate revenue assumptions. This allows you to segment new customers/users/subscribers/clients into two separate bases, allowing you to assume annual/monthly billing, for example.
• Edited Accounts Payable and Accrued Liabilites on Balance Sheet on Statements sheet to include previous period, so that the formulas are change per period + previous period (Thank you to user for finding this; while the Starter Model shares the same build for the Statements, this was only in the Standard Model).

• Edited Get Started, E26 to calculate the number of follow-on checks differently for the Venture Investor Model. No change to returns or cash flows, no other impact to the model other than reporting the number of follow-on checks differently.

• Edited Forecast sheet to include a new input line for "Changes in Accounts Receivable", and edited the accounts receivable calc to use that amount if used in the model. What this does is make it easier to use the actual changes in accounts receivable in the model; previously you had to compute cash collected to back into the change in accounts receivable, now it will do it directly using the change in AR you calculate from your actual balance sheet

New post about the tools, processes, and expectations around Special Purpose Vehicles (SPVs) for investments.

• Edited line 89 (Taxes, forecast) and line 195 (Taxes, actuals + forecast) on Forecast sheet to correct an error introduced in previous version. Simple to change by adjusting those two lines.

• Added a new Key Metrics Sheet (focused on SaaS businesses) and a few new SaaS-specific metrics on the Forecast sheet.
• Added new Hiring Plan sheet to aid in detailing a hiring plan by putting it on a separate sheet.