Excel Financial Model for Classic and Online Business

Excel-Financial-Model (EFM) is the right choice when start-ups or established companies need to prepare a business plan, calculate funding requirements, raise cash, make cash flow projections, construct budgets and/or report to management or shareholders.

With EFM it's a breeze to generate a solid and well-structured financial plan, including all the required forecasting elements, such as integrated financial statements with full Profit and Loss (Income Statement), Cash Flow, and Balance Sheet reports as well as key operational and financial metrics.

Don't like reading? Watch this demo video to learn more!

The powerful and easy-to-use financial planning tool can be used by entrepreneurs, start-ups, investors and consultants, whether you are already running a business, or making plans to start a new one.

Setting up an integrated financial model can be a challenging task, especially for entrepreneurs with only minimal previous experience in this area and/or without a financial background. Excel-Financial-Model guides you step-by-step through all important assumptions and automatically recalculates your complete forecasts and metrics with each new input. This allows you and others to quickly test various scenarios and see the overall impact.

Advanced users who need even more planning and reporting flexibility can enhance and modify all sheets as desired, thanks to the transparent, flexible and open approach of EFM.

Tailored solutions for your business model

As every business is unique there cannot be a "one-size-fits-all" model template. It goes without saying that a manufacturing or distribution business model, for example, has different requirements and KPIs than an online subscription business model.

To accommodate the various types of business models, Excel-Financial-Model is available in two different versions, for classic economy (EFM-CE) and digital economy (EFM-DE) business models. All assumptions and calculations as well as key operational and financial metrics are tailored to the specific type of business. In addition, each version offers various generic inputs and provides numerous spare rows to handle your individual requirements.

Features (of the full versions)

1. Main features (both versions)

• 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 higher.
• Generate fully-integrated projections for up to 5 years (on monthly basis). Automatic aggregation as quarterly and annual summaries on output sheets.
• 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 (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).
• Define any currency code or symbol and preferred denomination (e.g. 000s).
• 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

2. Version-specific features of EFM Classic Economy

• 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).

3. Version-specific features of EFM Digital Economy

• Specific input options (assumptions) reflect revenue models and unique cost structures faced by digital software or online business models.
• Monthly forecasts and calculations for up to 4 different offerings (= products/services), which can be planned independent of each other.
• For each offering users can enter key software business focused assumptions including: Subscribers/users, churn rate, customer retention (renewal), upsells, sales model (recurring vs. one-time), payment processing fees, affiliate commissions, revenue share, set-up fees, customer acquisition cost, cost of sales and many more.
• Select between different contract lengths (monthly, quarterly, semi-annual, annual).
• Set different billing frequencies (monthly, quarterly etc.) and types (in advance or in arrears).
• Automatic calculation of important KPIs like e.g. monthly recurring revenue (MRR), total contract value (TCV), customer acquisition cost (CAC), customer lifetime value (CLTV), and many more.

Users Guide / Manual

You can view an online version of the full manual with most recent content as well as expandable illustrations, easy navigation, and search capability.

• EFM (Classic Economy) - complete user manual for Classic Economy Business version.
• EFM (Digital Economy) - complete user manual for Digital (online) Economy Business version.

Reasons to use Excel-Financial-Model

1. Integrated Model to convince investors
EFM includes and connects everything (assumptions, calculations, outputs) and presents it in an investor-friendly, deal-proven way.

2. Ease of use
Detailed and professional Excel solution, yet simple and fast to use, enabling quick results.

3. Save time and focus on core business
EFM allows you to spend less time on finance and more time on your products, customers and business development.

4. High Quality
Compliant with FAST modelling standard, EFM increases productivity, reduces errors and is easy to understand, review and adapt.

5. Great value for money
Use a robust and proven financial model based on years of experience at an affordable price.