Build scenarios using the current applicable royalty rate, list price, and printing cost for the actual marketplace and edition. KDP describes the basic paperback calculation as rate multiplied by list price, minus printing cost. Keep that per-copy result separate from editing, design, advertising, and other project expenses.
Record the inputs before calculating
List marketplace, format, trim and production choices, final page count, proposed list price, applicable rate, and estimated printing cost. Use current KDP guidance and tools for platform-specific inputs. The applicable rate is not one universal value for every paperback price and marketplace.
Record the date and source of the estimate. If the book is not final, identify provisional values explicitly. This helps you distinguish a change caused by the manuscript from one caused by updated pricing information. Do not treat a remembered rate or an old project quote as a current verified input.
Show the arithmetic clearly
Use separate columns for list price, rate, printing cost, and the calculated per-copy royalty. Label hypothetical examples so readers do not mistake them for current KDP quotes. Keep currencies consistent throughout a scenario.
For an invented illustration only, a price of 20 units, an assumed rate of 0.50, and an assumed printing cost of 4 units produce 6 units after the stated calculation. Those inputs are not a recommended price or a statement of current platform terms. Replace them with the applicable verified values for your edition.
Separate royalty from overall profit
Add fixed project expenses and any variable costs you need to evaluate, keeping their assumptions visible. Editing and design costs do not disappear because the per-copy royalty is positive. Advertising and other activities may create additional costs that are not part of the basic KDP royalty formula.
Do not call the calculated royalty net profit without defining what expenses have been deducted. Use precise labels so a collaborator can understand the model. A simple, transparent worksheet is more useful than a complicated forecast that combines different kinds of cost in an unexplained total.
Compare a small number of meaningful scenarios
Change one or two important assumptions at a time: price, production choice, or estimated unit volume. Use the currently applicable rate for each price scenario rather than carrying one rate across all rows automatically. Check any platform limits and current rules before treating a scenario as available.
A sensitivity comparison shows what the outcome depends on. It does not predict how many copies readers will buy.
- Record current edition and marketplace inputs.
- Keep the calculation visible.
- Distinguish royalty from project profit.
- Label hypothetical values and uncertain volume.
- Recheck scenarios after production changes.
Use the worksheet to frame a decision
Compare the results with the book's reader value, production constraints, and project budget. Identify which assumptions would need to be true for the plan to work. If the model depends on an unsupported sales forecast, make that uncertainty explicit.
Keep the worksheet with the release specification and update it when page count, settings, or pricing decisions change. Use current KDP confirmation before submission. The worksheet supports a clearer publishing decision; it does not guarantee a return or replace a careful assessment of your own circumstances.
Frequently asked questions
Clear answers for this publishing decision.
Is the paperback royalty rate always the same?
No. Current KDP guidance makes it dependent on factors including list price and marketplace. Verify the applicable rate for each scenario.
Does a positive royalty mean the project is profitable?
Not by itself. Project expenses and other costs may still exceed the amount earned. Keep those calculations and assumptions separate.
Can this worksheet predict sales?
No. It shows the consequences of assumed inputs. Treat unit volume as an uncertain scenario unless you have appropriate evidence for a narrower estimate.
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