New updates and improvements to Foresight
Subscribe to Updates · @foresighthq on Twitter
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.
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.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.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).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.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 sheetForecast
sheet to correct an error introduced in previous version. Simple to change by adjusting those two lines.Key Metrics
Sheet (focused on SaaS businesses) and a few new SaaS-specific metrics on the Forecast sheet.Hiring Plan
sheet to aid in detailing a hiring plan by putting it on a separate sheet.Showing 51 to 59 of 59 results