Welcome to the new site. If you have any issues accessing models, use store.hemrock.com.
Hemrock
Sign in

Standard Blank

December 1, 2023

  • Extended the Drivers, adding new functionality to the drivers to add max value, ending period, and additional flags. This required adding columns to Forecast, Statements, Hiring Plan, and Revenues sheets
  • Adjusting the formatting of the Statements, Summary, Snapshot sheets to switch signs for cash inflows and cash outflows. Done to increase the separation between the Forecast sheet (calculations) and Statements and other presentation sheets. Did not switch signs on Budget or Breakdown sheets at this time.
  • Added prebuilt calc for interest income to Forecast sheet (higher interest rates FTW)
  • Added a prebuilt line for the Sales (Optional) section on Revenues sheet to be added into the growth channel, and added a yes/no toggle on get started to enable that section. No change in functionality, just making the fact it exists as an option a bit easier to find by putting it on Get Started, and separating it out of the Manual Input line in the Growth calculations on Revenues makes it clearer how it works in the model.
  • Added a category for Interest Income and Dividends to Forecast and Statements sheet, to improve reporting capabilities for businesses.
  • Added timing and placeholder flags to the timescale used on Forecast, Revenues, and Statements, and replacing the previous formulas that used blanks to "end" or "blank out" the forecast after the custom end of the timescale. This replaces the way the model handled timescales that were < 72 periods in the Get Started assumption for number of periods. Now the model will no longer blank out calculations after the assumed period, but will calculate zeros, using the sheet more as a calculation page than a presentation page, a better structural approach. This will have little impact to how most people use the model, but will help those that want to model < 72 periods using the model.
  • Bug fixes in amortization calcs (to properly account for value of fully amortized assets), VAT (switching signs on the accrual and disbursement, from switching the signs on the income statement), retained earnings (properly add in the previous y), Breakdown sheet (unallocated other expense, other income, depreciation, amortization, interest income, interest expense, taxes)

The biggest changes here were extending the drivers, switching the signs, and implementing the timeline flag, while also eliminating the use of the timeline test to output blank cells past the input number of months to model on Get Started. This involved changing > 95% of the formulas on Forecast, Revenues, and Statements, so it was a massive edit. That said, moving to the new base is not required, although if you stay with your base fixing the retained earnings bug is recommended.