A useful break-even worksheet separates fixed project spending from costs that occur with each sale. Divide recoverable project costs by the contribution from a sale only after defining what that contribution includes. Keep assumptions, shared expenses, and unpaid author time visible so a clean-looking total does not conceal duplicated costs or missing work.
Define the question your worksheet answers
Start with one edition, one currency, and one recovery period. A worksheet asking whether this paperback can recover its editing and design costs is different from one asking whether an entire author business pays for its operating expenses. Write the question at the top. Then list the spending included in that calculation so future comparisons use the same boundary.
For a practical nonfiction guide, possible project expenses include editing, fact checking, illustration work, cover design, formatting, and proof review. Use actual quotes or recorded spending where available. If a cost is unknown, leave it as an estimate with a range and an owner responsible for obtaining a quote. A blank cell should not silently become zero merely because the work has not yet been commissioned.
Distinguish cash spending from author time
Prepare one view for cash outlay and another for the broader effort involved. The hours you spend checking examples may not create an invoice, but they still affect whether the project is worthwhile. Record those hours separately and apply an explicit hypothetical rate if you want to compare alternatives. Do not describe that imputed amount as money already paid.
This distinction matters when comparing a tool with a professional service. A less expensive generation tool can create a longer editing task, while a larger invoice might reduce revision time. Record the complete task required to reach an acceptable result. Avoid treating the first draft as the finished deliverable. The worksheet should compare equivalent outputs, including review, usable source files, and any corrections needed after proofing.
Allocate shared costs with a stated rule
A subscription used for several books should not be charged in full to every project unless you are intentionally showing a conservative scenario. Choose a simple allocation method, such as actual months used or documented project usage. State it next to the amount. Keep the original invoice in a separate expense record so the sum of allocations can be reconciled with what was actually paid.
Treat reusable artwork and templates similarly. If an illustration was commissioned for one specific guide, that project may carry the entire cost. A general template used across several titles may belong in shared overhead. The useful result is consistency, not an elaborate accounting model. When you compare books, apply the same allocation rule or explain why a different rule better represents the work.
Use contribution rather than list price
The money available to recover production spending is not the customer's full purchase price. For a paperback, obtain the current estimated royalty for the intended specifications, marketplace, and price from KDP. Understand what the estimate already deducts before subtracting anything else. In particular, do not subtract printing cost a second time from a royalty figure that already includes that deduction.
Consider a deliberately hypothetical example: fixed project spending is $1,200 and contribution per sale is $3 after the costs included in your definition. Recovering that spending would require 400 such sales. If an additional variable expense reduces contribution to $2, the result becomes 600 sales. These numbers illustrate the calculation; they are not KDP rate claims, a forecast of demand, or a recommendation for your book's price.
Test uncertain inputs and preserve the baseline
Create several explicit scenarios instead of presenting one exact-looking answer. Vary the uncertain production costs and contribution assumptions, keeping the underlying definition consistent. If contribution becomes zero or negative, ordinary break-even division is not meaningful: more of those sales do not recover the fixed spending. Review the assumptions and costs rather than hiding the result behind a very large sales target.
Save the baseline before approving major additions such as color illustrations or a second format. Compare the incremental expense and expected benefit with the original project purpose. Revisit the worksheet after final pagination and pricing, when estimates can be replaced with current values. Keep actual sales and spending in a separate tracking view so you can compare results with the plan without rewriting what you originally assumed.
Frequently asked questions
Clear answers for this publishing decision.
Should I subtract printing cost from the royalty estimate again?
Check the definition of the estimate first. If KDP's royalty figure already deducts printing cost, subtracting that same cost again would understate contribution.
Does a break-even sales target predict demand?
No. It describes the sales required under specified assumptions. It does not establish that those sales will occur or how quickly readers will purchase the book.
Where should unpaid editing time appear?
Record it separately from cash expenses, with the hours and any assumed hourly value clearly labeled. This supports comparisons without presenting unpaid effort as an invoice.
What does this book cost to print and produce, and what should the list price be?
Printing cost follows from the trim, ink, and page count, the list price sets the royalty after that cost, and the production budget should be estimated before generation starts, so compare these numbers before you commit to a format or a plan.
See what a book project costs in credits