Calculators
The calculators below have been developed to help you in planning for various different client circumstances. They all require Microsoft Excel (version 97 or later).
Offshore bonds for early retirement calculator
The calculator shows how a non-taxpayer could cash in segments of an offshore bond with minimal income tax liability by offsetting the gain against personal allowance. This could be used, for instance, to provide funding for early retirement.
Download calculator (Microsoft Excel file 49Kb) - please ensure you have read the Terms of Use below.
Long-term withdrawals calculator
The calculator shows the effects on investment capital of making long-term regular withdrawals in a taxed and untaxed environment. The 'gross roll-up' on offshore bonds means they can support withdrawals over time more effectively than onshore bonds that are taxed at source.
Download calculator (Microsoft Excel file 41Kb) - please ensure you have read the Terms of Use below.
Making use of personal allowances with offshore bonds
The calculator shows how a non-taxpayer can create a chargeable gain each year equal to the personal allowance, so there is no immediate tax liability and the final chargeable gain on cashing in may be significantly reduced.
Download calculator (Microsoft Excel file 223Kb) - please ensure you have read the Terms of Use below.
School and university fees investment calculator
The calculator shows what level of investment would be needed in an offshore bond to meet school or university fees and what tax might be payable on withdrawals.
Download calculator (Microsoft Excel file 184Kb) - please ensure you have read the Terms of Use below.
The calculator shows comparative after-tax cash-in values for an investment into a collective, offshore bond and onshore bond.
Download calculator (Microsoft Excel file 168Kb) - please ensure you have read the Terms of Use below.
Offshore v onshore bonds calculator
The calculator shows comparative gross and net cash-in values for an offshore and onshore bond, illustrating the effects of gross roll-up.
Download calculator (Microsoft Excel file 30Kb) - please ensure you have read the Terms of Use below.
TERMS OF USE
1. In the Terms of Use 'The Software' means all software (excluding Microsoft Excel) and other materials contained within the spreadsheet.
2. Microsoft Excel is a registered trademark of the Microsoft Corporation.
3. Copyright and all other intellectual property rights in respect of The Software is, and shall remain at all times, in the ownership of Prudential.
4. The Software shall be for your own use and shall not be given, sold, loaned to or allowed to be used by any person not employed by or contracted to you.
5. You must not decompile, reverse engineer or otherwise tamper with The Software contained within the spreadsheet.
6. We may, from time to time, issue amended or updated versions of The Software. The updated version will then become the current version of The Software at any time.
7. Prior to release of this spreadsheet, we have carried out virus checks using up-to-date virus-checking software. We do, however, recommend that you carry out such checks as you consider appropriate prior to using this spreadsheet. We cannot be held responsible for any loss or damage caused by the continued presence of a virus which has not been detected by the virus-checking software.
8. We have applied care and skill to produce The Software to a professional standard. However, we cannot guarantee that The Software is free of errors or omissions, nor can liability be accepted for any losses, howsoever incurred, arising from the use of The Software.
