A little puzzle? (1 Viewer)

Simon_MT

Registered User.
Local time
Today, 12:53
Joined
Feb 26, 2007
Messages
2,177
In the UK under certain circumstances you can use the Retail Margin VAT Scheme. There are several ways to apply this scheme, the first, the VAT is calculated on your Gross Profit and you apply this rate as your effective rate of VAT. The second, and the one I use, is per transaction, the amount of VAT you pay depends on the amount of profit received for each sale that the Retail Margin Scheme is applicable. The difference between the UK and some EU countries is the sales tax on art is a fixed but substantially reduced rate.

This worked all very well until Artist Royalties (AR) came along. The wizards at DAC's decided to follow the EU model and use a banded scale based upon the Euro Day Rate which may impact on the bands to calculate Artist Royalty. It would be easy if the sales staff quoted a price plus AR, oh no, they give inclusive prices, this price is binding as it has been accepted.

To calculate the AR you need to know the Profit but to calculate the Profit you need to know the AR. Two unknowns!

The sale is £75,000 inclusive of both VAT and Artist Royalty
The cost is £50,000.

The Euro Rate is 1.3962 based on 16th November 2007
The AR bands are €50,000 @ 4% and €200,000 @ 3%
Vat 17.5% is calculated on the Profit element only
Atist Royalty is exempt from VAT

How much is the Profit?
What is the Vat Payable?
What is the Amount of Artist Royalty due?

This is the link to the AR Calculator.

http://http://resale.dacs.org.uk/ARRCalculator.aspx

I found a way in Excel to work this out but it is less than elegant and to me using Excel is like surrendering.

Simon
 

neileg

AWF VIP
Local time
Today, 12:53
Joined
Dec 4, 2002
Messages
5,975
Bit of school algebra here. I'm ignoring the mix of Euro and GBP and assuming only the 4% rate, just to establish the approach. If Selling Price is Sp, etc then this is the algebra:

Obviously Sp=Cp+Ar+Pr*117.5%
=> Ar=Sp-Cp-Pr*1175%
But also Ar=Pr*4%
Therefore Pr*4%=Sp-Cp-Pr*117.5%
=> Pr*4%+Pr*117.5%=Sp-Cp
=> Pr*121.5%=Sp-Cp
=> Pr=(Sp-Cp)/121.5%

Does that help stimulate your thoughts?
 

Simon_MT

Registered User.
Local time
Today, 12:53
Joined
Feb 26, 2007
Messages
2,177
Neileg,

Thanks for the reply, the problem is that if the AR is a flat rate (eg 4%) then you could simply say:

Net = Sp / (1 + Ar)
Pr = (Net - Cp) / 1.175

Where I get stuck is when AR is on a sliding scale ie up to €50,000 it is 4% then, in this case, the remainder is calculated at 3%. Once you change the Net

Pr changes
Vat changes
and so does the Net
and therefore so does the basis of Ar

I have written a script to calculate AR just to come to terms with the mechanics of sliding scales but its inutiile until you can establish the amount to base the calculation.

Its nice to see some good ole algebra - brings back memories.

Simon
 

Users who are viewing this thread

Top Bottom