Consulting Firm Excel Financial Model
Originally published: 10/02/2018 17:45
Last version published: 27/01/2022 14:57
Publication number: ELQ-24760-3
View all versions & Certificate
certified

Consulting Firm Excel Financial Model

In this file I will show you how to model consulting business in Excel in order to create a business / financial model

Description
In this file I will show you how to model consulting business in Excel in order to create a business / financial model. We start with modeling capacity of the business. Later on I move on to modeling sales and cost side. Thanks to this model you will be able to estimate how much you can earn from you consulting business, assuming prices and costs on different level of consultants.
The financial model attach will help you start or scale your business, understand what drivers the profits and to prepare to potential problems that may occur. The attached model in Excel will also help you manage your cash flows and to understand the implications of the growth as well as changes to certain drivers (utilisation level, structure of the company, price and cost per 1 consultant, size of the office etc.)
The model can be easily modified by changing the parameters in blue. This will have no impact on the logic of the model and will help you to get immediately recalculated results.
For more information check the provided video where I explain how to use the model in practice and what is the starting point for the analysis of the model. Enjoy the model and please let me know if you have any questions regarding the model.

This Best Practice includes
1 Excel and link to the movie with explanation

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss


4.5 / 5 (101 votes)

please wait...