The dilution report

With the dilution report you get the number for dilutive number of shares that you need as part of calculating diluted EPS in line with IAS 33.

Introduction

As part of the IFRS standard IAS 33 concern the disclosure of earnings per share (EPS) and dilutive earnings per share. Stock options and other types of equity compensation are a potential future obligation to the company that may dilute existing shareholders and the EPS. Hence, its potential dilutive impact should be considered as part of disclosing the diluted EPS.

The Optio dilution report provides this impact in the form of dilutive number of shares to be included as part of the potential dilutive shares in the diluted EPS calculation.

How can I get access to the Optio dilution report?

The Optio dilution report is an additional feature which is not typically included in our standard financial reports. Our reporting suite is designed with flexibility in mind, allowing you to add this report to your package at any time to meet your specific reporting needs.

If you're interested in enhancing your financial reports with the Optio Dilution Report, or if you have any questions about our modular reporting options, please don't hesitate to reach out. Contact your Optio representative or email us at contact@optioincentives.no for more information.

How can I include the dilution report when generating a report? 

When you create a new report (see How to create a new financial report?), the dilution report will be part of the complete report output if it is included in your report configuration(s).

Note that in case you have several report configurations available, the dilution report may not be included in all of them. Hence, you can try to use a different report config if it is not included in your default report config. If you would like to adjust any of your existing report configs you can reach out to your Optio representative.

What does the dilution report look like?

When you run a report, the first page you are redirected to is a web-version of the report. In the web version of the report you have access to the complete report, and you can make certain adjustments to tailor the report to your liking. You can of course download the full report to Excel, which will inherit any adjustments made in the web version of the report. Hence, the Excel download will contain all the information you have access to in the web-version of the report. 

To download the report to Excel, you can at any view of the report click on the "Download excel report" button. 

Average share price

At the top of the report you will find information about the share prices relevant to the reporting period. When the dilution report is included, this section will be extended by an additional row with the "Average share price" for the reporting period, which is used for dilution calculations.

In the web report you can drill-down to see the underlying share prices used for the average by clicking on Average share price text. You can of course download this table to Excel.

In the Excel report, the average share price is included as part of the share price table at the top of the Overview tab.

Overview tables

On the overview tab of the report is a separate table for the dilution report. This overview table contains a high-level view of the key figures relevant to dilution, grouped to your liking. 

Just like all our overview tables you can select to view the table grouped in different ways to see the dilutive figures grouped by entity, program, sub program, and potentially others, depending on your setup.

In the Excel download you can see the same tables, where each table is included separately of each other.

In both the web- and Excel version of the report, the dilution overview tables contain the following columns:

1. Underlying Shares: This is the the number of outstanding instruments as of the reporting date, i.e. the CB date.
2. Avg. Outstanding Shares: This is the average number of instruments outstanding for the period, considering for how long of the period they have been outstanding. If a grant was granted halfway through the period, it has only been outstanding for half of the period, and thus a 50% weight has been applied to its quantity for the dilution calculations. Similar, if an award has been fully terminated at some point throughout the period the appropriate weight is applied to reflect for how much of the period the award was outstanding. This is the quantity to be considered for the dilutive calculations.
3. Dilutive Shares: This is the number of dilutive shares which are to be included as part of the dilutive number of shares in the dilutive EPS calculation, which reflects the dilutive impact of all in-the-money instruments that have been outstanding for the period. 

Detailed dilution figures

To get a complete understanding of where the overview values come from, you can view the detailed figures, with a complete audit-trail, by clicking on the "Dilution" tab. 

In the Excel report the dilution details can be accessed by clicking on the "Dilution" tab in the Excel.

The dilution detailed report has a similar structure to the other report, where each row in the table is one TRANCHE, which reflects a single vesting of an award on a person, program and sub program basis. On each row you will find information about what award the row relates to, the relevant input figures used for the dilution calculations, columns with calculations steps to calculate the dilutive number of shares, and the resulting dilutive number of shares.

You can also expand a TRANCHE to see the underlying transactions that have had an impact on that award to see the full audit-trail of changes. In the web version you can do this by clicking on "Show" on a particular transaction line.

Once clicked, a module will pop-up showing each underlying transaction as well as the impact they have on the TRANCHE.

In the Excel report you can expand a TRANCHE by clicking on the ungroup "[+]" button on the left hand side.

To better understand the dilutive-specific columns found in the dilution report, an explanation of them can be found below:

• Transaction dilutive factor: This factor represents the portion of the reporting period a transaction was outstanding. If a GRANT transaction was granted halfway through the period this factor would be 50%. If a TERMINATION transaction was registered just 25% before the CB date it will show a factor of 25%. These factors are used in combination with their respective transaction quantities in order to determine the average quantity for the period. Please note that these calculations occur on a transaction level, hence these factors are only displayed on transaction rows, and not TRANCHE rows.
• Avg. Quantity Adjusted: This is the result of the transaction quantity multiplied with the transaction dilutive factor, to reflect the average outstanding quantity of that particular transaction for the period. If a GRANT has a quantity of 500, and the transaction dilutive factor is 50%, the 'Avg. Quantity Adjusted' will be 250 (500 x 50%). Please note that these calculations occur on a transaction level, hence this quantity is only displayed on transaction rows, and not TRANCHE rows.

Avg. Quantity Adjusted = Transaction quantity x Transaction dilutive factor

• Avg. Quantity: This column reflects the average outstanding quantity of a TRANCHE for the period, and is calculated by summarizing the 'Avg. Quantity Adjusted' for all underlying transactions.
• Avg. Quantity Perf. Adj.: This column reflects the 'Avg. Quantity adjusted' for the latest available performance estimate as of the CB date. Please note that according to IAS 33 the performance estimation used for dilution is a bit different than for other reports, so this estimate can be set differently.

Avg. Quantity Perf. Adj. = Avg. Quantity Adjusted x Performance Adjustment

• Assumed exercise quantity: This column reflects the number of instruments that were to be exercised if all in-the-money instruments were to vest, based on the 'Avg. Quantity Perf. Adj.'. Meaning that this column displays the 'Avg. Quantity Perf. Adj.' for instruments where the share price is higher than the strike, i.e. there is an intrinsic value.

Assumed exercise quantity = IF(Share Price > Strike; Avg. Quantity Perf. Adj.; 0)

• Total strike on assumed exercise: This column shows the total monetary amount the company would receive for the strike employees would have to pay for the Assumed exercised quantity.
• Unamortized cost: this is the unamortized IFRS 2 cost to be accrued for the average quantity outstanding for the period. In line with IAS 33 companies should consider the fair value of the remaining service employees have to provide in return for the awards, as this has a future value for the company, which will reduce the dilutive impact. Please note that if turnover rates are applied to your report, the unamortized cost will be the unamortized cost considering the turnover effect.
• Quantity buy back shares: this can be considered the shares that the company could buy back in the market using the total strike on the assumed exercised instruments received from employees, which would not cause any dilution and thus will reduce the dilutive impact of the instruments. This is also where we consider the reduction in dilutive impact due to unamortized cost. The share price considered for the hypothetical buy-back is the average quote for the period. 

Quantity Buy Back Shares =
(Total Strike on assumed exercise + Unamortized Cost) / Avg. Quote

• Dilutive shares: This is the dilutive number of shares to be included in the diluted EPS calculation. This figure is the difference between 'Assumed exercise quantity' and 'Quantity buy back shares', and reflects a value loss to existing shareholders due to the share based payment gain employees will receive. 

Dilutive shares = Assumed Exercise Quantity - Quantity Buy Back Shares

Customize your report

In the web-version of the report you have the flexibility to tailor the report to your liking. Any adjustments made in the web version of the report will also adjust the excel download of the report.

Overview tables

On the overview page you can define which tables you want to include in the report. You can select all or only some of the dilution tables as part of both the web view as well as the excel download. To do so, click on the "Overview Selections" drop down:

Then select the tables you wish to include in the browser- and Excel report:

Report Details

On the Dilution details tab in the web-view of the report you can define which columns you want to include in the report. You can select all or only some of the different columns. This will change the layout of both the web-report as well as the excel report download. To do so, click on the "Dilution Columns" drop down: 

Then select the columns you wish to include in the browser- and Excel report: