Main Library: Core Models
Choose a Model and click Assemble button to begin modelling
Not sure which Model is for you? Ask our Model Wizard
Topline Model
Sibling of Base Model, Topline Model has more functionality on the top line. You can choose to model sales dynamics based on customer acquisitions and retention or via traditional sales volume and pricing per unit of sales. Online assembly allows variation in number of COGS and Overhead elements. As the Model is focused on topline evolution, balance sheet structure and drivers are presented in condensed format.
Topline Model allows you to -
|
-
Set parameters for your opening balance sheet and working capital requirements, book future CapEx program and the Model will automatically work out its depreciation schedule
-
Generate three forms of financial statements – balance sheet, P&L and cash flow – and calculate tax liability and loss carry forwards
-
Сalculate NPV and IRR for your business or project
-
Save time with an easy interface to rename key elements of your revenue and cost items to suit your business environment, again with the ability to make later changes in Excel
Many additional flexible parameters that can be set in the model-building stage or changed later in Excel as shown in example. Note that yellow fields represent data which can be easily changed or manipulated in the final custom dynamic Excel file, without you needing to know how to code in Excel.
СloseBase Model
Our first commercially available model called Base is suitable for long range planning needs of small and medium sized businesses or new projects. Driven by key operational assumptions Base Model provides a transparent and non-confusing way to forecast cash flows of a manufacturing and/or services business. You can assess suitability of Base Model for your needs by clicking on its Sample and Manual below.
Our Base Model, the first in our product range, allows you to -
|
-
Generate three forms of financial statements – balance sheet, P&L and cash flow – and calculate tax liability and loss carry forwards
-
Сalculate NPV and IRR for your business or project
-
Save time with an easy interface to rename key elements of your P&L and balance sheet to suit your business environment, again with the ability to make later changes in Excel
Many additional flexible parameters can be set in the model-building stage or changed later in Excel as shown in Model Preview. Note that yellow fields represent data which can be easily changed or manipulated in the final custom dynamic Excel file, without you needing to know how to code in Excel.
СloseCase Builder Model
Case Builder Model allows users to build, analyse and compare up to five forecast scenarios, or operating cases, for a business or a project. The Model allows toggling between cases to run an active case through full set of financial statements. New feature specific to Case Builder Model generates consolidated report for all cases at a push of a button. In comparison to Base Model, we reduced the number of steps required for on-line assembly.
Our Case Builder Model allows you to -
|
-
Populate or leave blank your own opening balance sheet data with the option to change it later in Excel, if desired
-
Choose up to five debt elements in the capital structure with individual rates and amortisation profiles
-
Populate data for up to five elements of your capex program, with individual depreciation schedules
-
Generate three forms of financial statements – balance sheet, P&L and cash flow – and calculate tax liability and loss carry forwards
- Calculate NPV and IRR for your business or project for each operating case with ability to generate consolidated report for all cases
Many additional flexible inputs can be set in the model-building stage or changed later in Excel as shown in Example. Note that yellow fields represent inputs easily changeable or manipulated in the purchased Excel file, without you needing to know how to code in Excel.
СloseManufacturing Model
Manufacturing Model is best suited for modelling production processes based on uptime, output rate and pricing assumptions. For each product group users can assign up to ten cost drivers. Depending on the profile of your business these can depend on production volume (per unit driver), uptime (per hour or per work shift driver) or remain fixed (adjustable for inflation). The Model can describe any production environment from continuous 24*7 operations to weekly single or multi- shift schedules. Any input and output category can be relabelled to make your Model appear fully tailored.
Manufacturing Model allows you to:
|
-
Set parameters for your opening balance sheet and working capital requirements, book future CapEx program and the Model will automatically work out its depreciation schedule;
-
Provide inputs and analyse impact from short term overdraft funding and/or long term debt financing;
-
Generate three forms of financial statements – balance sheet, P&L and cash flow – and calculate tax liability and loss carry forwards;
-
Сalculate NPV and IRR for your business or project;
-
Save time with an easy interface to repopulate input assumptions and/or to rename key elements of your revenue and cost items to suit your business environment with the ability to make later changes in Excel
Many additional flexible parameters that can be set in the model-building stage or changed later in Excel are shown in the Model's sceenshot. Note that yellow fields represent data which can be easily changed or manipulated in Excel, without you needing to know how to code in Excel.
СloseOther Options
* The Institute of Chartered Accountants in England and Wales (ICAEW) has recognised FinRobot’s Base Model, TopLine Model, Case Builder Model and Manufacturing Model (FinRobot’s Standard Models) as being compliant with ICAEW's Twenty Principles for Good Spreadsheet Practice. Users should be aware that the Standard Models do not cover all aspects of good spreadsheet practice and therefore should ensure that they follow the best practice appropriate to their specific circumstances when relying upon spreadsheets, as ICAEW will not be liable for any damages whatsoever incurred by any person, occasioned by reliance on the models or any related products or services, howsoever caused.