Core TSIs : Contracts : Apportionment calculation : Apportionment calculation using English quarters
Apportionment calculation using English quarters
Start date
01/06/2011
Price per YEAR (excl VAT)
12000
Payment frequency
3 months
Quarter type
English
Start payment frequency
24/06/2011
Start / end calculation based on price of
Year
VAT
19%
Contract line ends in a period containing Feb 29
Start date
End date
Amount (excl VAT)
Amount (incl VAT)
01/06/2011
23/06/2011
3000 * (23 / 91) = 758.24
758.24175 x 1.19 = 902.30
24/06/2011
28/09/2011
3000
3570
29/09/2011
24/12/2011
3000
3570
25/12/2011
28/12/2011
3000 * (4 / 91) = 131,87
131.86813 * 1,19 = 156.92
Explanation of the above example:
If you are using non-standard quarters, such as English quarters, the Apportionment calculation method is always Quarter.
The payment frequency is done quarterly and the apportionment calculation is done on the basis of the English quarters.
Here, the payment start date is 01/06/2011. The apportionment calculation is done for the period between 01/06/2011 and 06/23/2011. The payment calculations for the next two quarters are normal.
As the period between 25/12/2011 to 28/12/2011 is the beginning of the first English quarter (25/12/2011 to 3/24/2012), the calculations done in this period take February 29th into consideration.
The amounts for the first and last quarter are calculated as follows:
3000 (amount for a full quarter) * 23 (# days of contract line) / 91 (# days of full quarter) = 758.24
3000 (amount for a full quarter) * 4 (# days of contract line) / 91 (# days of full quarter in leap year (2012) or 90 days for non-leap year) = 131.87
* 
For more information on start and end dates of English quarters, see Quarters - comparative overview.