Comprehensive financial models (CFM) are revenue cash flow models of companies and enterprises related to projects, assets and businesses. A CFM is a primary decision making, management and negotiation tool, where a wide array of model inputs can be changed and the impacts on outputs (operational and financial performance) can be observed. Over the course of any advisory mandate, we will utilize the CFM extensively for the purpose of running a wide variety of "scenarios" and "sensitivities". In particular, when we are engaged as a transaction advisor, developing, maintaining and operating the CFM will an essential component of our advisory work. In a transaction advisory role, the analyses provided by the CFM is used for such purposes to demonstrate to a potential equity investors that there is sufficient equity up-side potential (the probability of achieving a certain minimum level of return) given realistic and defensible operational, financing and market development scenarios developed in the model. Similarly, we may also use a CFM to convince prospective lenders that if they should lend into a company, that the companies net revenues will be sufficient to achieve sufficient minimum debt service coverage ratios over the term of a loan, given realistic and defensible operational, financing and market development scenarios developed in the model. In many cases, we will build a CFM that is taken over by our client and used for many years for the purpose of making management decisions with respect to operations & maintenance, financing, pricing policies and many other aspects of their business. A CFM is really a key modeling tool both for our work as advisors and our client's ongoing management responsibilities with respect to its projects, businesses and assets.
We offer state-of-the-art CFM modeling services to our public and private sector clients in the sectoral areas that we cover, including infrastructure, energy & utilities, oil & gas, industrials and real estate. Developing a CFM is always advisable step for all parties engaged in transactions in these sectors. Transaction participants including sponsor governments/government agencies, equity sponsors / developers, companies, utilities, contractors, vendors and contractors, buyers and sellers of companies and assets, investors, lenders, multilaterals and regulators can all benefit from independently developing a CFM.
Each time we are mandated to develop a CFM on behalf of a client, prior to beginning to develop a model, we will always schedule one or more meetings with our client in order to fully understand all necessary details of their business, project or asset and the client's specific modeling needs. We custom-build each and every CFM around the specific requirements of our client's project, business, enterprise or assets. However, in simplified terms a CFM is always structured as a revenue cash flow model with the following common model architectural components:
We individually custom-build each and every one of our CFMs using standard Microsoft® Excel® software in a the most user-friendly manner possible. We provide a user manual and in-model user instructions for our CFMs which are handed over to our clients. Our objective is to create a model that can be handed over to the client and operated proficiently by the client's own staff (in some cases for many years). After our model is in our client's hands we can provide ongoing services such as model training & capacity building workshops for client staff, model maintenance and update services and support and specific modeling analysis utilizing the client's model, as may be requested by the client.
In addition to developing, updating and maintaining our own CFMs for our client advisory mandates, we also provide model review and audit services of financial models produced by our clients or by another third-party model developer on behalf of our client. Model review and auditing services are often required by our clients (as an independent review or audit) in other transactions that DCS is not otherwise a party to.
DCS advisors are able to provide CFM modeling services on a stand-alone basis on behalf of public and private sector clients who have mandated us to provide transaction advisory, workout & restructuring, project feasibility advisory or strategic planning services. In most cases, as CFM modeling services will be only one element of a larger project delivery program, DCS will also be providing other complementary analytical services in relation to other transaction elements. Our preference is always to provide such comprehensive advisory services and coordinate all elements of the transaction, including CFM modeling services on behalf of our clients.
Under any CFM modeling services mandate, DCS will draw from our vast global network of veteran industry expert advisor affiliates and our relationship consultants in order to assemble the most appropriate team to match the specific needs of the transaction at hand. This will always include leadership of DCS affiliate experts who possess decades of global transactional experience related to the specific sector and transaction type. In any economic and market modeling services mandate, our preferred role is always to serve as the lead project/program manager. Within this role we are also able to assist in the selection and procurement (or subcontracting) and management of other advisors, including local and international legal, technical, economics, commercial/operational and other specialized advisors or other specialized advisors, as the specific transaction may require. To the extent that other third-party advisors are required, there are many value added advantages of allowing DCS to assist in the procurement of these advisors. First, DCS expert affiliates themselves possess many of required legal, technical, economics and managerial skill sets and we are best positioned to determine which additional outside third-party skill sets are required and which firms or individuals should be hired in these roles. Secondly, financial modeling is a very complex undertaking, requiring the management and coordination of many simultaneous workstreams. DCS advisors are experts inproject and program management services and are ideally suited to manage and coordinate a multi-dimensional advisory team most efficiently and effectively.
Complementing our CFM modeling services, DCS advisors offer the following complementary advisory services that may be applicable, dependent on the specific needs of our client.
DCS experts provide CFM modeling services in the following sectors that we specialize in. Please click on the below links to learn more about the sectors that we cover:
DCS experts provide CFM modeling services to the following categories of clients:
dcs advisory Experts team
comprehensive financial models
Lewes DE, USA
|Meet Our CFM Modeling Experts Team!|
© 2022 Dean Capital Strategies GmbH
Dean Capital Strategies GmbH
TELEPHONE +43 (0) 1 293 6321