Modeled sheets are designed to take input from planners and contain logic for automatically modeling the results of that input. Some common uses of modeled sheets are:
- Personnel sheet: Planning headcount details and calculating resulting monthly salaries and related benefits expenses.
- Capital sheet: Planning capital purchases and calculating resulting monthly depreciation expense.
- Sales sheet: Planning projected sales and calculating resulting revenue, COGS, invoicing, and accounts receivable.
Modeled sheets are created and configured by administrators. Planners use the sheets to enter forecasted revenue and expense drivers, such as headcount, capital spending, and sales. These drivers can be tagged with dimensions such as job code, product line, benefits choice, revenue recognition method, or invoicing timing.
Behind the scenes, the sheet uses these inputs and the associated dimensions to automatically calculate revenue, expenses, and balance sheet activity, which can be spread
out over future time periods (for example, revenue recognition, depreciation, and invoicing). These values can be calculated based on lookups.
For example, you may tag headcount with benefits choices. Each benefits choice is associated with a percentage of salaries. Benefits expense is calculated based on the choices, the lookup of percentages, and salary values. The automatically calculated values are placed in modeled accounts. These calculated values are stored in the database, but are not yet included on the P&L or Balance Sheet. Administrators link these modeled accounts to the appropriate financial planning (GL) accounts, such as salaries, which roll up to the forecasted financial statements.
Sheet designers can create modeled sheets with any number and type of columns, but cannot specify rows. Users can add and delete entire rows from the sheet, and each row represents an item being modeled. Rows can also be imported. Modeled sheets can then use the lists of items users have entered to generate values using formulas created by sheet designers. Those values appear as "accounts" which can then be used in formulas, or placed in reports or on standard sheets.
Modeled sheets appear along with other sheets on Sheets > Overview or as a user-assigned sheet on Modeling > Accounts > Assumptions.