How do you calculate VAT on a spreadsheet?

VAT ? how to calculate ?

• selling price 300 vat 17.5 % settlement discount 3 % how to calculte vat ? if trade dicount is given den we subtract vat value from net price but in settlement discount we subtract vat value fron net seeling price

• Answer:

  If a settlement discount is offered, VAT should be charged on the discounted net cost only. In your example: Net selling price: £300.00 Settlement discount: -£9.00 VAT (17.5% on £291) £50.93 Total bill: £350.93 (If discount taken £341.93)