Changelog

Changelog

New updates and improvements to Foresight

Subscribe to Updates · @foresighthq on Twitter

  • 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 Capital 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

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