System Requirements

In order to use the Calculator, your computer must meet the following minimum system requirements:

1. Windows-based computer running the Windows XP, Windows Vista or Windows 7 operating system;
2. A full version of Microsoft Excel 2007 or above.

Note - Microsoft Excel Viewer is not a suitable alternative as it does not allow the use of macros.

 

Use of Macros

A macro is an instruction that expands automatically into a set of instructions to perform a particular task. In relation to the Calculator, macros are used to calculate the appropriate cost base adjustments that are necessary as a result of a distribution.

In order to use the Calculator, you must enable the use of macros when prompted by Microsoft Excel.

To enable the use of macros in the Calculator:

1. Open the relevant Microsoft Excel file (with the .xlsm extension); a "Security Warning" box will be shown at the top left of the screen
2. Click on the Options button in the "Security Warning" box
3. In the "Microsoft Office Security Options" popup box, select Enable this content from the "Macros and ActiveX" section and press the OK button
4. Macros will now be enabled in the Calculator

 

Using the MIG/SRG Demerger Cost Base Calculator

On 24 July 2006, SRL shares were distributed in specie from MIT(II) and SRT units were distributed in specie from MIT(I). SRL shares and SRT units were stapled together in a 1:1 ratio to form an SRG stapled security. Security holders received 1 SRG stapled security for every 3 MIG stapled securities they held.

This Calculator has been prepared to assist ALX investors, who held MIG securities as at 23 July 2006 and who received SRG securities as part of the in specie distribution from MIT(I) and MIT(II), in calculating the appropriate cost base adjustments that are necessary as a result of this distribution.

You will need to have handy information about your investment in MIG. You will need your acquisition date, acquisition costs (brokerage), your DRP participation dates (if any) and any selling information (eg which MIG securities you may have sold).

Please note that you should consult your tax advisor or the annual MIG Tax Booklet for further information.

INTERNET EXPLORER USERS SHOULD RIGHT-MOUSE CLICK ON THE "DOWNLOAD MIG/SRG DEMERGER COST BASE CALCULATOR" LINK BELOW, SELECT "SAVE TARGET AS", AND THEN CHANGE THE FILE EXTENSION FROM .ZIP TO .XLSM WHEN PROMPTED

Download MIG/SRG Demerger Cost Base Calculator | Return to home page