Calculate the number of Bullabulling shares you will...

Calculate the number of Bullabulling shares you will receive.

Create yourself a spreadsheet.

Enter current values into the following 4 DATA ENTRY cells.
Cell A1 - Total Number of AZX shares on issue (eg. 130,200,000).
Cell A2 - AZX shares held by GGG Resources (currently 9,600,000).
Cell A3 - Total number of GGG shares on issue (eg. 165,700,000).
Cell A4 - Your current shareholding in AZX (eg. 100,000 shares).

Enter formula's into the following CALCULATED cells.
Cell A6 - =(0.5*((A1-A2)/A1)) - Adjustment to allow for AZX shares held by GGG on the record date. (Format the cell as a number to 2 decimal places).
Cell A7 - =(A3/(1-A6)) - Total number of Bullabulling shares on issue after implementation. Format to zero (0) decimal places.
Cell A8 - =(A7*A6) - AZX share scheme consideration. Format to zero (0) decimal places.
Cell A9 - =(A8/A1) - Ratio (Format the cell as a number to 2 decimal places).

Your current Bullabulling Gold share entitlement.
Cell A11 - =(A9*A4) - Format the cell as a number to zero (0) decimal places.

For example.
Cell A1 - 130,200,000
Cell A2 - 9,600,000
Cell A3 - 165,700,000
Cell A4 - 100,000

Cell A6 - 0.46
Cell A7 - 308,642,918
Cell A8 - 142,942,918
Cell A9 - 1.10

Your current Bullabulling Gold share entitlement
Cell A11 - 109,787

Gw