Overview
Learn more about the different types of model templates in the Logica library:
Monthly Model Templates
Weekly Model Templates
Daily Model Templates
Custom Templates
3 Statement Model Template
This template contains the overall structure of a fully-linked 3 statement model, including an Income Statement, Balance Sheet and Cash Flow Statement model. Inside are also examples of revenue, expense and headcount models.
Multi-Entity Consolidation Model Template
This template contains the overall structure of multi-entity consolidation model, including headcount and non-headcount expenses by entity. Inside are also placeholders for historical financials by entity.
Burn Rate Template
This template includes a model for entering inflows (revenue) and outflows (headcount and non-headcount expenses) to determine cashflow and runway. Check out the video below for a quick overview or explore our full step-by-step tutorial for getting started with this template.
Headcount Template
This template includes a headcount model framework for entering headcount-related expenses by employee and rolls up headcount expenses by department. This template can be further customized with any of the Headcount component templates.
Headcount Allocation Template
This template includes a headcount model framework for entering headcount-related expenses by employee and allocations by employee and by project. This template can be further customized with any of the Headcount component templates.
Sales Tracking Template
This template includes a model for tracking sales data over time by customer. Analyze past performance by customer or roll up for tracking by customizable customer attributes such as industry, market, and type.
Business Case Template
This template includes a model for entering new revenue and expenses (COGS and OpEx) for a business case analysis. Check out the full step-by-step tutorial for getting started with this template.
Monthly Scorecard Template
This template includes a model for tracking metrics in a scorecard with inputs for metrics by area, metric owner, and metric data source. Two scenarios are set up: one for setting metric goals and the second for tracking actuals.
CapEx & Depreciation Template
This template includes a model for entering capital expenditures by asset category and calculates depreciation expense schedules. This model template showcases how to combine the CapEx and Depreciation components.
Fund Management Template
This template includes a model for tracking KPI's for portfolio companies in a fund.
Cohort Model Template
This template includes a monthly cohort model.
Weekly Scorecard Template
This template includes a model for tracking metrics on a weekly basis.
Daily Cash Flow Template
This template includes a model for tracking cash flow on a daily basis, with inputs for inflows and outflows.
Build your own templates
Interested in building your own library of templates and making it available to your organization? Let us know by sending us a message!