I know this is an old post but I signed up just to thank you for this simple, concise and useful tool. The only other thing I would appreciate clarity on is where VAT comes in to the cost/sale prices.
Many of us buy at trade prices, we calculate our landed cost then do you add VAT then markup or add VAT on at the end?
cost + markup + VAT or
cost + VAT + markup?
VAT goes at the end as this is % of the gross pay.