Spread Duration Calculator
The formula
What the spread duration tells you
The bottom line for spread duration and the margin it represents — the two numbers every owner checks before anything else.
Calculation: profit = revenue − costs; margin = profit ÷ revenue. Enter your inputs and every substitution is shown below the result.
Reading the result
A positive result with a sub-5 % margin is fragile; read the margin band, not just the sign.
Limitations and best practice
Accrual vs cash: this is P&L arithmetic — a profitable business still fails without the cash to pay Friday.
This calculator gives an estimate based on standard formulas; it is not professional financial, medical, legal or engineering advice. Verify anything you plan to act on with a qualified professional and your own records.
Frequently asked questions
Is margin the whole story?
Which costs count?
Source & methodology
Standard income-statement arithmetic.
Spread Duration: the number, the method and the caveats
You are counting something that matters — this tool counts it exactly, including the edge cases calendars hide. There are plenty of pages about Spread Duration; almost none of them show the working. This one does: the formula, every input, a fully computed example, and a sensitivity analysis calculated live from this engine’s own defaults.
In plain terms, Spread Duration answers the question "Net profit?". The measurement matters because it converts a situation that feels complicated — several inputs pulling in different directions — into a single number you can act on. Within Investing & Markets, Fixed Income is the context where this figure is quoted most often, and professionals treat it as a first-pass screen rather than a verdict.
The useful way to hold Spread Duration is as a ratio with a story attached: profit = revenue − costs; margin = profit ÷ revenue says how the parts combine, and the $-7,500.00 figure above is simply that sentence written in numbers. Everything that follows unpacks one clause of the sentence at a time.
Every figure in the prose is generated by the engine rather than written beside it — the worked example resolves to net profit = $-7,500.00 on the default inputs, and the sensitivity section ranks the inputs that move the result — Total costs first, at ≈170.0 % of the headline for a ten-percent error either way in that input. Work down the page and by the end you could re-derive the result in a spreadsheet from memory.
Inside the Spread Duration calculation: formula and every input
One formula, published in full: profit = revenue − costs; margin = profit ÷ revenue. Anything you can read, you can reproduce in a spreadsheet, and that reproducibility is the whole point of printing it rather than hiding it behind a button.
Revenue / gross value ($) (example value 120,000) is a numeric input whose unit is fixed by the label; a wrong unit is a wrong answer wearing a plausible disguise. The example value is there to demonstrate the mechanics, not to describe your situation — overwrite it.
Total costs ($) (example value 127,500) is a plain measured quantity — the unit shown in the label is the unit the formula expects. This input feeds the formula directly; a defensible figure here is worth more than false precision anywhere else.
Periods to compare per-month figures (example value 9) is a quantity rather than a category — precision here is cheap and worth having. If the period is partial, decide whether you mean elapsed or planned time and keep that meaning across every field.
Spread Duration on the example inputs: the complete substitution
The tool prints its own working; this is the same arithmetic on the example values, reproduced so you can follow it by hand. Starting figures: Revenue / gross value ($), Total costs ($), Periods to compare per-month figures. The computed net profit comes out at $-7,500.00, which the interpretation band labels “Loss at these figures — the cost base is the problem”.
- Profit = $120,000.00 − $127,500.00 = $-7,500.00
- Margin = ÷ revenue = -6.3 %
Margin — -6.3%. This is the number experienced users quote when the headline alone would mislead.
Cost coverage ratio — 0.94 ×. This is the number experienced users quote when the headline alone would mislead.
Per period — $-833.33. This is the number experienced users quote when the headline alone would mislead.
Overwrite any input above and every line of this example updates with it — the substitution is live, not a screenshot of somebody else’s numbers.
Scenario table: Spread Duration at ±10 % and ±20 % of the key input
Single-point answers invite false confidence, so the same engine was run across a band around the input that matters most here. Each row is a full recalculation of Spread Duration, not an interpolation.
| Total costs setting | Net profit |
|---|---|
| 80 % of the example value | $18,000.00 |
| 90 % of the example value | $5,250.00 |
| example inputs | $-7,500.00 |
| 110 % of the example value | $-20,250.00 |
| 120 % of the example value | $-33,000.00 |
That spread — $-33,000.00 at the low end, $18,000.00 at the high — is what a careful read of Spread Duration looks like: a band you can state out loud, with the reason for each edge. Reproduce it in the form above by editing Total costs alone; the substitution steps will follow your figures exactly.
Where Spread Duration is fragile — and where it is not
Generic advice says “it depends on your inputs”; this section says exactly how much. Each field was perturbed by ±10 % in isolation and the net profit recomputed, so the ranking below is measured rather than asserted. For Spread Duration the ranking is measured rather than guessed, and it belongs to these defaults: shift the starting point and the order can shift with it.
- Total costs: ten percent up gives $-20,250.00, ten percent down gives $5,250.00 — ≈170.0 % of the net profit either way
- Nudge Revenue / gross value by ±10 % and Spread Duration lands between $-19,500.00 and $4,500.00 (sensitivity ≈160.0 %)
Total costs is the dominant lever here: ten percent either way moves the result by about 170.0 %, from $-20,250.00 to $5,250.00. Spend your verification effort there first, and Revenue / gross value is effectively tied with it (≈160.0 % for the same nudge), so verify the pair together. The remaining fields can sit at safe defaults without materially changing the answer — knowing which is which is what separates a careful calculation from an anxious one.
Interpreting the Spread Duration verdict
The value above only becomes useful the moment you know what it is being measured against. On the example inputs the band reads “Loss at these figures — the cost base is the problem”; your own figures place you on a different rung of the same ladder. How much of that band is luck? On Total costs alone ten percent either way covers $-20,250.00 to $5,250.00. The practical reading rules: read the band as a starting hypothesis, then test it: change the two dominant inputs by ten percent and see whether the verdict survives. Verdicts that survive stress are the ones worth acting on.
Set Spread Duration beside its neighbours and it usually plays a specific role: this figure establishes the size of something, and the neighbouring tools establish whether that size is acceptable. Skipping the first step makes the second one arbitrary.
Common mistakes with Spread Duration (and the fix)
Accrual vs cash: this is P&L arithmetic — a profitable business still fails without the cash to pay Friday. This calculator gives an estimate based on standard formulas; it is not professional financial, medical, legal or engineering advice. Verify anything you plan to act on with a qualified professional and your own records.
Treating the example inputs as a recommendation. They are a demonstration of the mechanism — a decision-grade Spread Duration begins the moment your own figures replace them.
Attention is also misallocated between fields. Having measured this engine, we can say where it belongs: Total costs first, everything else second.
Another is comparing across contexts: a Spread Duration computed with one set of conventions should never be lined up against a figure computed with another. Check the inputs behind both before ranking them.
Before you trust your Spread Duration: a short checklist
- Recompute once with the dominant input deliberately set low, and see whether the decision changes.
- Verify each input against its original source document, not memory.
- Put Total costs under a magnifier; the sensitivity table above is the reason why.
- Confirm the example values are plausible for your own situation before replacing them.
- Compare the result with one independent method or published benchmark.
- Confirm the answer against one independent method or published benchmark for Spread Duration.
How to use the Spread Duration tool properly
Using a calculator well sounds trivial, but the difference between a decision-grade figure and a throwaway one lives entirely in the routine. The routine for Spread Duration takes a minute to learn and applies to every input above.
Step 1 — gather before you type. Spread Duration depends on revenue / gross value ($), total costs ($), periods to compare per-month figures. Collect them from a source document — a statement, a report, an invoice, a log — rather than from memory, because recalled inputs are the single largest cause of wrong results. If a result feels obviously right, that is the moment to check the inputs hardest.
Step 2 — compute the version you would not be embarrassed by. If a stranger audited your inputs, which set would you hand over? Enter that set, read the result, and treat everything else as upside. If a result feels obviously right, that is the moment to check the inputs hardest.
Step 3 — isolate your variables. Change one field, observe, revert. The live sensitivity list does the ranking for the default inputs; verify it against your own, because dominance shifts when the starting point shifts. A figure with a date beside it becomes evidence; without one it stays an anecdote.
Step 4 — stress before you commit. A decision that survives a ten-percent squeeze on its two biggest inputs needs no luck to be sound. One that does not survive is a decision about hope, not about arithmetic. If a result feels obviously right, that is the moment to check the inputs hardest.
Step 5 — record the context, not just the number. Note today’s date and the inputs alongside the $-7,500.00 output. Six months from now the context is what turns this figure into a trend. The test of a good estimate is not that it feels right but that it changes what you do.
The real-world conversations Spread Duration settles
In Fixed Income the figure computed here is usually the first one somebody asks to see. Having it — with the formula behind it — changes your position in the conversation from participant to reference. Say the answer out loud before you save it; if it sounds wrong, the model did not change, your understanding did.
The audience for this page is people planning around a point or span in time. In professional Fixed Income practice the pattern is always the same — screen with Spread Duration, then invest slow analysis only in whatever survives the screen. A figure nobody can reproduce is a figure nobody will act on twice.
Re-running this page costs nothing and catches the slow drifts that never announce themselves. In Investing & Markets the expensive mistakes are rarely sudden; they are small changes in Revenue / gross value ($) that nobody recalculated for a year. If a result feels obviously right, that is the moment to check the inputs hardest.
The questions that come up most about Spread Duration
What affects Spread Duration the most?
Measured on this engine, Total costs is the dominant lever: moving it ±10 % shifts the net profit across $-20,250.00 to $5,250.00 — about 170.0 % of the headline, with Revenue / gross value next at ≈160.0 %. The ranked list in the sensitivity section is computed live, not asserted from a template.
Do revenue / gross value and total costs matter equally?
Effectively. Measured on this engine they land at ≈170.0 % and ≈160.0 % for the same ten-percent nudge, so the honest advice is to get both right; chasing precision in only one of them buys almost nothing.
What is a typical Spread Duration?
On the worked example above Spread Duration comes out at $-7,500.00. Treat that as one point on a distribution rather than a norm: the bands, the companion outputs and the sensitivity ranking tell you how wide the plausible range really is.
How do I calculate Spread Duration by hand?
Use the stated model — profit = revenue − costs; margin = profit ÷ revenue — and substitute in the order the tool prints (it starts from Profit = $120,000.00 − $127,500.00 = $-7,500.00). On the example inputs the hand route lands on $-7,500.00, exactly what the calculator shows. A spreadsheet reproduces it in two or three cells; doing it once by hand is what makes the automated answer trustworthy.
What happens to Spread Duration if total costs changes by 10 %?
On these inputs a ±10 % change in total costs takes Spread Duration to $-20,250.00 against the $-7,500.00 example — around 170.0 % of the headline. The same test on every other field is in the sensitivity section.
Is the Spread Duration result of $-7,500.00 good or bad?
Good and bad are comparisons, so the honest test is three questions: where does your own Spread Duration sit against the $-7,500.00 reference above, how far would a plausible input error move it (≈170.0 % per ten percent on Total costs), and what does the alternative option compute to?
How often should I check Spread Duration?
Whenever an input changes by more than a few percent, and otherwise on the rhythm of your decisions — before a purchase, a review, a renewal. Spread Duration is a snapshot, not a subscription; stale snapshots are the most common silent error in Investing & Markets planning.
How do I calculate Spread Duration manually?
Write down the inputs, then follow the printed steps in order — profit = revenue − costs; margin = profit ÷ revenue. A spreadsheet replicates it with two or three cells. The manual route is worth doing once to build intuition; after that the calculator saves time and eliminates transcription slips.
Is margin the whole story?
No — capital turnover decides ROE. A 5 % margin at 10× turnover beats a 30 % margin at 0.5×.
Which costs count?
Everything below the definition you chose. State gross or net, and keep the same definition across periods.
Does this Spread Duration tool store my numbers?
No. The entire calculation runs in your browser session; nothing entered above is transmitted or saved, which is the correct behaviour for sensitive Investing & Markets figures and the reason you can re-run this page as often as you like.
Key terms on this page
- Margin
- -6.3% in the default Spread Duration calculation — one of the secondary figures an experienced reader checks before trusting the primary number.
- Cost coverage ratio
- 0.94 × on the example inputs — a companion figure printed beside the headline of Spread Duration so that no result is read in isolation.
- Per period
- $-833.33 for the Spread Duration worked case; it sits next to the main result because it carries context the headline leaves out.
- Net profit
- The primary output of this tool: $-7,500.00 for the default inputs, computed exactly from profit = revenue − costs; margin = profit ÷ revenue.
- Worked example
- The step-by-step substitution printed above, so the arithmetic can be re-derived by hand or in a spreadsheet.
- Verdict band
- The interpretation attached to a result (“Loss at these figures — the cost base is the problem” on these inputs), which turns a bare number into a position on a scale.
- Sensitivity (±10 %)
- How far the Spread Duration moves when a single input is nudged ten percent either way; the ranked list on this page is computed live from this engine.
Where the Spread Duration model comes from
There is no black box on this page — the engine evaluates profit = revenue − costs; margin = profit ÷ revenue. Source of record: Standard income-statement arithmetic. Specialist software layers extra coefficients on top of the same algebra; none are hidden here, and that transparency is what makes a disagreement traceable to a specific input instead of a black box.
This page is an estimation aid, not professional advice. The design rule is simple: two people entering identical figures must get identical answers. The design constraint was set by usefulness rather than by comfort: an estimate you can interrogate beats an answer you have to trust.
What to do with your Spread Duration next
Re-run whenever a start date moves — time calculations compound small shifts into large misses.
The audience here is people planning around a point or span in time. Everything you need to defend the result — formula, substitution, sensitivity, source — is printed above, so the only remaining variable is the honesty of your inputs.