How do you calculate VAT on a spreadsheet?

Vat spreadsheet calculation please for profit?

  • I want to know how much profit I make on a product, taking into account buying and selling vat costs, vat on courier etc. Can anyone give me the correct spreadsheet cells and formulae for the following example :- cost of product to me £11.16 ex VAT cost of ebay fees, 10% of selling price selling price £21.90 cost of courier £4.05 ex VAT what is the amount of my profit in pounds and pence after purchasing and selling the product and sending it via courier, taking both lots of VAT into account, on product and courier, and paying VAT man his cut on the sale and what is my final percentage profit. Thanks in advance

  • Answer:

    Hiya Steve, just emailed you the spreadsheet. Good luck and if you need any further calcs, just email me. Cheers....;-))

Steve Jones at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

9 out of 10 new businesses fail, and the MAIN REASON is INSUFFICIENT CASH FLOW .. Since it seems you are unable to do simple arithmetic on your costs and profits, I'm betting your don't even know what Cash Flow is .. so I SERIOUSLY suggest you start looking for a business partner (who does know) before it's too late and your cheques start 'bouncing' and the bailiffs turn up on your doorstep

Steve B

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.