Data Example from London Marriott Hotel Regents Park

We don’t have the tax amount, but we know the VAT of London is 20%, we can base on this information to calculate with the program as below:

Please find the calculation progress as below:

VAT: 20%

Price per night on average: Total Cost / (1+VAT)/nights 1284.35/(1+0.2)/5 = 214.06 Total Room Charges: Total Cost / (1+VAT) 1284.35/(1+0.2) = 1,070.29 Total Taxes & Fees: Total Cost - (Total Cost / (1+VAT)) 1284.35 - (1284.35/(1+0.2)) = 214.06 Total Charge: Total Price 1284.35 Complimentary Night Credit: Sum(Daily Rate of first 4 night with tax) / (1+VAT) / 4 (223.2+271.15+271.15+279.65)/(1+0.2)/4 = 217.74