You are here:Home/Excel-Financial-Model CE: Key Features
Below is a brief overview of key Excel-Financial-Model features. Be sure to take a look at various screenshots and more details here.
Version specific features of EFM Classic Economy
Perfectly suited for any business operating within manufacturing, services or distribution.
Monthly sales forecasts for up to ten different product/service categories, which can be defined by the user.
For each product/service category, users can enter specific sales projections (2 methods), specific revenue shares, as well as cost of materials/goods (3 methods), input/output tax rates, inventory levels and specific receivable/payable (debtor/creditor) terms.
Planning of direct/variable costs: includes direct labor head count and three other user-definable direct cost categories (with 12 nameable sublines)
Overhead expenses (indirect costs): Five different categories with 30 user-definable sublines
Payment terms can be individually set for each single cost item/variable
Capital expenditure and fixed assets with provision for handling depreciation, additions/disposals, company produced additions (capitalized assets), and finance leases.
EFM can handle three categories of fixed assets (intangibles, tangibles and financial assets). Within each category multiple assets can be planned, with individual input tax rates (if applicable).
Working capital and cash conversion cycle: Automatic calculation of net working capital and corresponding KPIs like e.g. days sales outstanding, days payable outstanding, and days inventory held (incl. graph).
Main features
Compatible with Excel for Mac and PC. Minimum requirements: Excel 2007 (v12.0) and higher on Windows and Excel for Mac 2011 (v14.0) and later.
Use the full functionality and flexibility delivered by Excel.
Easy customization (add your own logo and formats, quickly change cell styles etc.)
Clear and transparent model structure (13 separate sheets, each focusing on a specific planning category, colour coded => input, calculation and output sheets).
Compliant with FAST financial modelling standard.
Create and save as many Excel files as you like (e.g. different versions or companies).
Multiple safeguards to protect formulae and data to prevent input errors or accidental changes (worksheet protection can be removed).
Checksum structure delivers error-free financial modelling (more than 30 different control cells).
Value-added or sales tax functionality included (optional).
Includes all required forecasting reports containing assumptions, profit and loss accounts (income statements), cash flow projections & statements, balance sheets, performance reviews and summaries for months, quarters and years (incl. numerous graphs and KPIs)
Extensive help: Quick start guide embedded, comprehensive manual and support
Automatic Calculations
Detailed capital expenditure (= capex) planning and automatic calculation of depreciation (straight-line or double-declining balance).
Automatic calculation of income taxes (incl. prepayments, loss carryforward etc.).
Automatic calculation of accounts receivable and payable based on assumed payment terms for debtors and creditors.
Overdraft facility (= working capital facility), with individual limit and automatic repayment if liquidity is available.
Automatic loan calculation (incl. fees, interest and principal payments).
Separate interest rates for cash balances, overdraft and long-term debt.
Automatic calculation of capital requirements and funding based on an implied cash flow waterfall (different equity and debt tranches with alternative funding priorities).
Key Input Options – Assumptions
Forecast horizon: Generate fully-integrated projections for up to 5 years (on monthly basis). Automatic aggregation as quarterly and annual summaries on output sheets.
Individually define model start date and choose fiscal year end month (can differ from calendar year).
Define any currency code or symbol and preferred denomination (e.g. 000s).
Change between UK/International or US/Canadian accounting formats and terminologies by just one click.