Odoo • Text and Image

Balance sheet forecast

The purpose of balance sheet forecast is to obtain a continuous view on the balance sheet of the company that is as accurate as possible, including its different elements and development trends on a chosen period. Important key indicators for management include at least cash position, equity ratio, indebtedness and various turnovers (inventory, sales receivables and accounts payable).

The major part of the balance sheet forecast is generated automatically:

  1. Depreciations of fixed assets are calculated automatically, and the system can be used to simulate investments and their financing.
  2. The inventory, especially the total inventory, indicates how much company capital is committed to the stores. The amount of inventory may vary strongly between seasons, and could have a significant influence on balance, working capital etc. Revise EPM utilizes for automatic balance calculation mathematical models incorporating historical trends (turnover, seasonal variation etc.).
  3. Sales receivables and accounts payable are calculated automatically from profit and cash flow forecasts.
  4. Cash balance is obtained directly from cash flow forecast.
  5. The balance sheet total indicates the total amount of capital committed to the company: cash (assets), equity and debt (liabilities). Both the line of business and business model have a substantial effect on the balance sheet total. Large, traditional manufacturing companies are usually highly capital intensive. When calculating the company return on investment, the second component is usually turnover of capital. This is calculated by comparing balance sheet total to the company turnover.
  6. Equity ratio describes the solvency situation and existing reserves in the balance.
  7. The company financing can be set up in many alternative ways: equity and its different instruments (share capital, hybrid loan, convertible bond, subordinated loan) and debt. These and their effects on the company solvency, cash flow, liquidity etc. can be easily simulated by Revise EPM. There is a separate section for debt financing design and simulation, that calculates and amortizes the interest and repayments on finance for each debt and its useful life.
  8. Holiday pay, VAT and other equivalent debt is calculated automatically.


Read more about other forecasts 

Cash flow forecast

Cash flow forecast is one of the most important tools for measuring the success and profitability of a company. Cash flow forecast gives a good overview on future cash flow, and it can be used as a basis for designing the actions needed to reach business goals. 

Sales forecast

With the Revise EPM sales forecast tool future sales, gross margin and resulting turnover and margin are forecasted. Profitable sales are at the core of every business. Sales forecast enables foreseeing sales trends and necessary actions can be started on time, whether the sales or sales margin are ahead or under the set goals.

Profit forecast

The goal of profit forecast is to estimate future turnover and profitability of the company. Trends per area of business and cost center are an essential part of this.