Excel
Insurance Premium Breakdown
Building Premium: 7,900,000
Demolition Premium: 18,328.00
Inflation Premium: 632,000
Contents Premium: 1,466.24
Total Sum Insured (Building + Demolition + Inflation + Contents): 10,087,704
Cyclone Total: 10,087,704.00
Cyclone Premium: 9,583.32
Flood Premium: 13,636.36
All Risk Premium: 647.73
VAT Calculations
VAT on Premium (I * 9%): 5,502.09
VAT on Total Premium: 36,680.61
Comprehensive Summary of Premiums
Premium Subtotal: 42,733.23
Stamp Duty: 5,502.09
Fire Levy: 48,235.33
Document Fee: 48,235.33
Final Amounts
Total Premium (Q + R): 48,235.33
Total VAT Inclusive (S + T): 48,235.33