Identify which debt number answers your question
A filing can show several different numbers for the same borrowing: face value, carrying amount and estimated fair value. A repayment table may show yet another presentation organized by year. Before comparing two companies or calculating a ratio, identify what each number measures. This tutorial builds a reconciliation worksheet whose purpose is to explain the differences, not to forecast refinancing or recommend a stock.
Begin with a company in ThesisMemo and follow available source links to its original filing. Use your own spreadsheet or document for this exercise. The product can help you locate research evidence where coverage is available; this guide does not assume it supplies a bond-pricing engine, an automated debt reconciliation or a complete history of every accounting adjustment.
Write the issuer, reporting date, currency, units and debt-note reference at the top of the worksheet. Give principal, carrying amount and fair value separate rows. Add one more column for scope: does the amount include the current portion, and does it cover the same instruments? A neat arithmetic result is not useful if the two sides describe different obligations.
Use a real disclosure to identify the bridge
Microsoft's debt note for the year ended June 30, 2026 provides a historical example of these separate presentations. Note 10 lists total face value, adjustments and total debt, then subtracts the current portion to show long-term debt. It separately discloses estimated fair value including the current portion. Its principal maturity schedule uses fiscal years ending June 30, while the instrument table labels maturities by calendar year.
The listed adjustments include unamortized discount and issuance costs, hedge fair value adjustments, and a premium on debt exchange. These labels demonstrate why you should read the actual reconciliation rather than apply a universal formula. The example is about the report's structure, not an assessment of Microsoft's present leverage or a claim that every issuer uses those same adjustments.
Copy the table headings and preserve the sign of each adjustment. A parenthesized amount often signals subtraction in financial tables, but confirm the table's convention instead of guessing. Keep the note's wording alongside your shorter worksheet label so a later reader can trace your calculation back to the report. If a label is unclear, flag it before proceeding.
Reconcile a hypothetical principal total
All figures that follow are hypothetical. Cedar Tools has three notes with face amounts of 50 million, 70 million and 80 million dollars. Their combined principal is 200 million. Assume that all three are denominated in the same currency and that no other borrowing belongs in this narrowly defined population. Start by summing the instruments before applying any accounting adjustments.
The fictional note gives two deductions: 3 million of unamortized discount and 1 million of unamortized issuance costs. It also gives a positive 2 million adjustment. For this exercise the disclosed bridge is therefore 200 minus 3 minus 1 plus 2, producing a carrying amount of 198 million. We assume that bridge is complete; it is not a universal accounting recipe.
Keep each adjustment on its own row. The net adjustment is negative 2 million, but collapsing everything into that subtotal would hide the positive item and make a later update harder to explain. Attach a source reference to every real-world row. If the report supplies only a combined adjustment, preserve that combined disclosure rather than inventing its components.
Keep the current portion inside the same total
Suppose Cedar's hypothetical 198 million carrying amount includes 29 million classified as current. Its remaining long-term carrying amount is 169 million. Adding 29 and 169 reproduces 198; adding the 29 million current portion to the already inclusive 198 million would incorrectly produce 227 million. This is a scope error even though the addition itself is arithmetically correct.
For the same fictional instruments, suppose the principal schedule contains 30 million due next year and 170 million due later. Those buckets sum to the 200 million face amount. Do not force the 30 million principal bucket to equal the 29 million current carrying amount without examining the relevant adjustments and classification. The worksheet has two different bases, both deliberately labeled.
The mismatch is a question to reconcile, not evidence that a filing is wrong. An actual company may disclose a different population or additional adjustments. Read its definitions before applying Cedar's simple example. If the sources do not explain a difference, leave a visible unresolved row and avoid presenting your worksheet as a complete reconciliation.
Treat fair value as a separate measurement
Now assume Cedar discloses an estimated fair value of 185 million for exactly the same debt population and reporting date. It is 15 million below the 200 million face amount and 13 million below the 198 million carrying amount. Those differences answer two distinct comparisons. Neither difference means the company received cash or automatically reduced its contractual principal by that amount.
For a narrowly defined illustration, assume Cedar could repurchase the entire population for 185 million, with no fees, taxes or other adjustments. Paying that amount would require cash. Whether an actual transaction produces a particular accounting result requires its facts and applicable treatment; this tutorial does not calculate a recognized gain from the disclosed estimate alone. A fair-value disclosure is not an executed repurchase.
Write down how the issuer describes its valuation and the measurement date. Microsoft's historical note identifies its estimate separately and describes the valuation input level. Do not treat an estimate as a current executable quote. When comparing periods, check whether the valuation population and method remain comparable before interpreting a difference as a change in borrowing economics.
Check interest labels without replacing the debt bridge
Principal and carrying amount are balances. Interest is measured over an interval, so it needs a separate part of the worksheet. Consider an independent hypothetical note with 50 million dollars of principal, a 6% fixed annual coupon, two equal cash-interest payments and no principal change during the full year. Its annual coupon payments total 3 million, with 1.5 million paid each half-year.
That calculation uses the stated coupon and face amount. It does not establish the reported interest expense of a real issuer or the effective interest rate of a discounted instrument. Microsoft's historical instrument table has distinct stated-rate and effective-rate columns, which illustrates why the column label matters. Use the report's actual explanation instead of treating two rates as interchangeable.
Do not divide an annual cash payment by a period-end carrying value and rename the result the company's effective rate. Such a ratio may use a different balance basis or interval from the issuer's calculation. If you intentionally calculate a descriptive ratio, state the numerator, denominator and period, and retain the issuer's disclosed measure alongside it.
Update one bridge at a time and preserve open questions
Create a second hypothetical worksheet date. Assume Cedar's face amount remains 200 million, its combined unamortized discount and costs fall from 4 million to 3 million, and the positive adjustment stays at 2 million. The resulting carrying amount is 199 million. Under those explicit assumptions, carrying debt increases by 1 million without any change in principal outstanding.
The arithmetic demonstrates a measurement difference, not a claim about the cause of a real issuer's change. To explain an actual movement, consult the relevant accounting note, financing transactions and other disclosed adjustments. A change in carrying value by itself does not tell you the amount of new cash borrowing. Keep transaction evidence separate from your reconciliation.
Finish with a short record of what you verified: instrument scope, face total, each signed adjustment, current-versus-long-term split, fair-value scope and reporting date. Include a final unresolved-items field. That field can contain a missing valuation explanation or an unallocated adjustment; leaving it visible is more useful than forcing a balanced-looking table with unsupported assumptions.
When you return through ThesisMemo, verify the original report and source dates before replacing the worksheet. The methodology page explains that reporting periods, publication dates and review dates differ, and that coverage has limitations. An updated research page alone does not establish a new borrowing transaction. Save the previous worksheet so you can explain which source, amount or definition changed.
For a peer comparison, start by asking whether both measures include current debt and use the same basis. A face-value subtotal for one issuer and a carrying-value subtotal for another are not automatically comparable. Label any deliberate difference and explain why it remains useful. The output should be an auditable comparison, not a confident ranking built from unlike numbers.
Product references
Questions & answers
Which amount belongs in a principal repayment schedule?
Use the amount and scope identified by the issuer's schedule. Cedar's hypothetical schedule totals 200 million of principal, while its carrying amount is 198 million. Do not silently substitute a balance-sheet measurement for a contractual principal amount.
Can I add current debt to total debt?
First check whether total debt already includes the current portion. Cedar's 198 million carrying total contains 29 million current and 169 million long-term. Adding the current amount again would double count it.
Does a lower disclosed fair value reduce what the company owes?
Not by itself. In the example, the fair-value estimate is 185 million while principal remains 200 million. A completed transaction and its terms would be needed to establish changes in the obligation; an estimate alone is not a repayment.
Why can carrying debt rise without new borrowing?
Accounting adjustments can change while principal stays fixed. Our explicit hypothetical bridge moves from 198 to 199 million when one deduction shrinks by 1 million. Investigate the real issuer's disclosures before assigning that explanation to its results.
Does ThesisMemo perform this reconciliation automatically?
This tutorial uses your own worksheet and original filings. Available source links help with evidence gathering, but do not assume a complete bond valuation or accounting reconciliation is supplied. Mark missing inputs and keep your calculations distinct from reported facts.

