top of page
Writer's pictureSarah Ritchie

TEMPLATE | Pricing calculators

Pricing calculator template by Sarah Ritchie

There are many ways and many different formulas that you could use to price out your art. Which one is the best for you? To help figure this out, the Pricing Calculator resource (link below) gives you six different pricing calculators in one Microsoft Excel file.


The resource also contains a Research tab. Here you can make notes on similar artwork to yours, so you get a sense of what you could charge in the marketplace that you are targeting. It will also help you to sense-check your pricing.


POINTS TO NOTE:

The Pricing Calculator numbers have been based on New Zealand currency and taxes. The details can be easily updated to suit your own country, as follows:

  • Change ‘GST’ (tax) to whatever tax is appropriate for your country. The spreadsheet is currently set to 15% GST (New Zealand). If you wish to change this %, you’ll need to update the formula in the grey boxes. Where it reads "0.15", change this number to suit your own tax %.

  • Likewise, the 'Income tax' figure is set to 33%. If your income tax rate is different, you’ll need to update the formula in the grey boxes. Where it reads "0.33", change this number to suit your own income tax %.

  • Column F gives a 30% commission scenario. Column J gives a 50% commission scenario. These formulas can be updated to suit your own commission situation. In the same way as above, change the formulas in the grey boxes to suit.

  • Once you have the formulas set up to suit your needs, then, going forward, you will only change the figures in white boxes. Do not touch the grey boxes and the formulas should work fine. If not, please get in touch with me and I'll help you to set up the calculators to reflect your personal business situation.


If you have any questions, please let me know!







Instagram, Pinterest, YouTube: @sarahritchiehq


Comments


bottom of page