Template: Title costing

You can use this Excel spreadsheet template as a guide when costing your titles.

Kieran Rogers from Affirm, who prepared the template for the Independent Publishing Conference writes:

‘I have tried to add as many costs as I could think of for ease – if any aren’t relevant just leave them as zero. Once your work out your RRP, approximate sales, your discount off the RRP you will give to retailers and added your costs, the spreadsheet will automatically tell you what gross profit you stand to make.’

The cells highlighted green and yellow include formulas to calculate costs automatically. The formula bar shows what formula is in each cell. For example, the formula in cell B10 is =(B7*B8)*(1-B9) ‘which is essentially RRP less GST (B7) multiplied by sales (B8) less the retailer average discount in B9’, explains Rogers. ‘Use = to start any formula. The * means multiplied, / is divided by and + and – are exactly that.’

Members Only
Sign up or login to access this document

This content is restricted to SPN members

SPN Membership means being part of a thriving community that creates the best possible conditions for publishing, writing and reading to flourish in.

Membership eligibility

SPN membership is open to anyone interested in the writing and publishing industry, including small and independent publishers, self-publishers, readers and writers.

Engage with the community

Keep up to date with the latest news, opportunities and expert perspectives through SPN’s discussion groups, emails, and networking events.


Streamline your publishing workflow

Over 50 factsheets, templates and guides are made exclusively available for SPN members

Save money

Access discounts on services, and industry events

Mailing-list signup

Keep up to date with Australian small and independent press news and events with our timely email notifications

I'm a...

View past newsletters.

Your Cart