Financial Modeling Specialists

Anything and Everything Excel

 

Budgeting
Business Planning
Data Cross-Tab Analysis
Data Mining
Engineering Models
Financial Model of the Firm
Financial Statement Projection
Sales Forecasting
Profitability Analysis
Product Cost Characteristics and Analysis
Risk Analysis

FMS Home Page

Off-the-Shelf Models
Recent Engagements
What Clients Say
Industry Expertise

Contact FMS

Tutoring

 

Modeling Objectives

We can build financial or engineering models for all business needs. Your model will have the degree of automation appropriate to its intended use, including user-interactive point-and-click features. Typical modeling objectives are:

     Financial Model of the Firm

A financial model of your business will present management information and key financial performance indicators in a concise, understandable, decision-oriented format. The model will be live, in other words, you will be able to change various parameters and see the effect on the outcomes.  Typically profitability by product, major customer, and geographic region are modeled and presented along with projections for future periods.

 

Return to Top of Page

     Financial Statement Projection

Project financial statements, typically Income Statement, Balance Sheet, and Cash Flow Statement based on planned strategic and operational decisions and forecast investment, revenue and expense streams.

 

Return to Top of Page

     Sales Forecasting

Forecast sales by important criteria, for example,  major customer, product and month. Forecasting models can be driven by manual input, or a wide variety of conventional or customized forecasting algorithms

 

Return to Top of Page

     Product Cost Characteristics and Analysis

Analyze and evaluate the direct and indirect costs of a product and evaluate strategies for controlling and/or reducing costs.

 

Return to Top of Page

     Risk Analysis

Analyze the financial risks inherent in a business strategy. This can be done by use of manually varied scenarios or with more sophisticated probabilistic modeling.

Return to Top of Page

     Data Cross-Tabulation Analysis

Perform cross-tabulation analysis of data.

 

Return to Top of Page

     Data Mining

Extract, combine and otherwise manipulate data and files for analysis and reporting.

Return to Top of Page

     Profitability Analysis

Analyze the profitability of a business, subsidiary, product line or individual product, or other business element to evaluate its contribution to the strategic success of the firm.

 

Return to Top of Page

     Business Planning

General planning and modeling of business activities, for example revenue projections.

 

Return to Top of Page

     Budgeting – Operating and Capital

Model the firm's operations and/or capital spending activities for budgetary control of expenditures.

 

Return to Top of Page

     Engineering Models

Specialized models for engineering projects. Examples are bill-of-materials analysis for cost and/or structure evaluation, and job shop cost estimating.

 

Return to Top of Page

 

Copyright © 2000 - 2020   William E. Crisick. All Rights Reserved
Last modified: 03/23/20

FMS Home Page   Recent Engagements   What Clients Say   Industry Expertise   Model Development Process   Feedback   About FMS   Contact FMS  Tutoring