Logica Model Templates

Index of Logica's template library

Carissa Castro avatar
Written by Carissa Castro
Updated over a week ago

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!

Did this answer your question?