The Business Plan module in Valutico is a vital component of the valuation process, as it forms the foundation for financial forecasts. Here's a quick guide to help you get started with using the Business Plan module on Valutico.
Understanding the business plan
The Business Plan module contains financial forecasts that serve as the basis for your valuation. When you first open this module, you have two options for populating it with financial forecasts: "Valutico Estimates" or "Valutico Financial Model."
Additionally, you have the ability to add custom scenarios through the "Scenario Manager." This feature allows you to assess how different scenarios impact the valuation results.
In cases where you have not uploaded financial forecasts, Valutico provides default financial forecasts based on the following process:
The last annual revenue figure you entered in the Valuation Creation screen serves as the basis for the forecasts.
The forecast financials are calculated based on specific criteria:
For public companies, analyst estimates are used if available.
For private companies or public companies without forecasts, Valutico calculates medians based on peer data for metrics like sales growth, EBITDA margin, EBIT margin, net income margin, capex as a percentage of sales, and other relevant factors.
Values for the period between the last analyst estimate year and the Terminal Year are interpolated.
If no analyst estimates or peer medians are available, Valutico uses the last available data point for sales growth and the previous period's margin or ratio for other metrics.
Financial model - Valutico model template
You can upload your own financial forecasts by following these steps:
Navigate to the Business Plan screen and create a new scenario, or use the upload button on the Business Plan screen.
Download the "Valutico Model Template" Microsoft Excel Template, which is required for uploading custom financials.
The Valutico Model Template consists of two tabs: Projections and Export.
The "Projections" tab serves as an example of an integrated financial model. It's not mandatory to use this tab and can be replaced/deleted if needed.
The "Export" tab presents financials in two tables: calendar years and fiscal years. When uploading the financial model to Valutico, only data from the Calendar Year table is considered.
Refrain from adding or deleting rows or columns or changing cell formatting, as this may affect data mapping to the platform.
The Business Plan module displays both historic and forecast financials. The data is categorized into Actuals, Phase 1+2 (Budget and Projections), and the Terminal Year. Different colors indicate how each value was determined:
Blue: Uploaded by the user or manually entered.
Green: Valutico estimates based on peer ratios.
Black: Calculated values, either interpolated or based on the last year with user input or peer ratios.
You can modify any financial projection by clicking on the cell and changing the value.
The Scenario Manager, accessible by clicking the button at the top right of the Business Plan module, allows you to add, duplicate, rename, or delete scenarios. Scenarios are useful for creating different versions of the Business Plan, such as a base case and a best-case financial forecast.
Duplicating scenarios enables you to make changes directly on the platform without re-uploading financial forecasts.
The Validation screen helps you quickly assess financial forecasts for irregularities, ensuring that assumptions are correct. It provides access to typical financial metrics to identify any unusual spikes or trends.
The Benchmarking tab allows you to compare your company's financial projections to selected peers in detail. You can analyze key line items and ratios, compare them to your company's "Applied Metrics," and review inputs when using Valutico Estimates.
You also have the option to directly change your financial projections on the Benchmarking screen based on your analysis.
The Enterprise Value to Equity Value Bridge (EV-EQV Bridge) displays the difference between Enterprise Value and Equity Value. It allows you to make adjustments to the default Net Debt position, taking into account various factors like Pensions, Non-controlling interests, or minimum cash.
To add custom positions, select "add custom positions" and create the necessary custom positions, ensuring assets are entered as negative amounts and liabilities as positive amounts.
These are the basics to get you started with the Business Plan module on Valutico. As you become more familiar with the platform, you can explore advanced features and functionalities to enhance your valuation process.