Standard Model Default Setup

Changed the default chart of accounts categories to split out salaries by three "departments" - R&D, S&M, G&A - with an extra miscellaneous category. Altered Forecast, Budget, Breakdown, Summary, and Hiring Plan sheets to alter the category presentation and add new categories for tracking salaries. As always, a reminder that the Hiring Plan sheet is optional and employees can be done on the Hiring Plan or Forecast sheet, it's just a matter of personal preference.

Organized the Forecast sheet to break out the revenues, expenses, fundraising, hiring plan, and metrics into separate "sections". This is purely personal preference, but something I usually do when using a model, to make it easier to understand and see the various items. You can insert rows and change order of this however you want, any "section" or set of rows can be deleted if unneeded, and any sections may be added however a user wants to divide up the items.

Added a few extra rows and categories to sections on the Forecast sheet, to help provide more breakout for users.

Changed how Prepaid Expenses, Accounts Payable, Current Liabilities, and Other Current Assets are used in the Forecast sheet. Previously only the assumptions on get started (or the Actuals) would control how these accounts worked. Made a slight change to how they are calculated on the Forecast sheet so now they can be used to account for cash and recognition of these accounts. For example: for an expense that is paid once a year, but incurred and recognized every month, now the model allows you to set two lines: one for the recognition of the expense (select the appropriate expense category), and one for the change in prepaid expenses (when the cash is actually paid). The net/net of those will be reflected on the balance sheet and will flow through the changes in working capital on the statement of cash flows, reflecting the accounting for recognition of the expense in the period when it is incurred as well as the cash for when it is paid. That same structure works for the other accounts mentioned above. Note, this is different from other balance sheet accounts like Accounts Receivable, Taxes, and a few others that have dedicated subroutine calculations to deal with the complexity in those accounts.