Financial Modeling

The Financial Modeling Process

Step 1

Objectives 

Questions to Answer 
Key Outputs
 Proforma

Step 2

Conceptual Model

Plan
Key Drivers
Conceptual Understanding of the Business

Step 3

Gather Data

Financial Statements
Assumptions

Step 4

Spreadsheet Model

Modular Approach
Workbook Layout
Business Rules

Step 5

Analysis of the Results

Key Insights
Interpretation
Review
Quality Assurance
Control Sheet

Step 6

Use Results to Improve the Model

Insights to Improve Model
Cash Flow Forecast
Balance Sheet Forecast

Step 7

Communicate

Sensitivities
Scenarios
Charts
Presentation

Financial Models Glossary

Model Structure

Workbook Layout

Worksheet Layout

Cell Formatting Standards

Input Sheet

Calculation Sheet

Presentation Sheet

Control Sheet

Dashboard

Technical Terms and Concepts

Proforma

Sensitivities

Best Practices

Modular Approach

Calculation Blocks

Workbook

Financial Model

What is it?

A financial model is a custom tool developed using Excel, used to predict the performance of a company or investment.

It is useful and generally necessary, when raising funds (debt or equity), to evaluate the profitability of an investment for daily performance analysis and budgeting.

A financial model is more than just a calculation, it is a management and communication tool that reflects the complexities of a business through an intuitive and dynamic interface.

Cost

Our fees can vary greatly depending on the complexity and details required for the model. It typically ranges from $5,000 to $50,000.

A general needs assessment prior to the start of the mission will help reduce this range and a fees ceiling may be proposed.

Our fees include the development of a powerful, user-friendly tool adapted to your needs.

Once the tool is developed, it’s also possible to provide financial and strategic advice to support you in your project.

Content

Centralized inputs to easily control model assumptions.

Detailed calculation of key business elements.

Forecast of financial statements (pro forma).

Management reports and integrated dashboards.

Communicative charts to clearly outline the key messages.

Sensitivity tables to highlight the performance under various scenarios.

Integration of actuals with the possibility of connecting with various data sources (Power Query).

Who Are Our Clients?

Business Owners

Accountants

Business Buyers

Investment Funds

Attorneys

Business Brokers

Testimonials

Mr. Labonne is thorough, conscientious and has helped to obtain valuable information about our company through effective, relevant and communicative financial modeling.

Business Owner

Mr. Labonne is clearly an expert in his field and approaches situations with simplicity and efficiency. I am grateful for the work done to help me in my work.