Free Excel templates

Debt and Equity Accounting Model

A term loan with a warrant, the 10 percent test and two restructurings, a SAFE and convertible notes at fair value, and a Series B closing in temporary equity.

Type the financings once and the workbook does the issuer's accounting: it allocates the proceeds of a term loan between a liability warrant and the debt, solves the effective interest rate, runs the 10 percent test of ASC 470-50 on an amendment, tests two troubled debt restructurings, values a SAFE and convertible notes at fair value, and books the Series B closing with its conversions and its accretion in temporary equity. The worked case starts from a term loan of $20,000,000.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 136 free models.

Debt_and_Equity_Accounting_Model.xlsx (29 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Debt and Equity Accounting Handbook, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 137 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

9 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
The term loan, the warrants, the amendment, the restructuring variants, the SAFE, the notes and the Series B, in yellow cells.
Term loan
Allocation of the proceeds to the liability warrant and the debt, issuance costs, the effective interest rate and the schedule.
Amendment
The 10 percent test at the original rate without third-party costs, the break-even coupon, the modified schedule, the extinguishment variant and the IFRS 9 comparison.
TDR
Two hypothetical troubled debt restructurings: gain or no gain, the new effective rate and the concession test.
SAFE
Shares at the cap, the calibrated discount rate, fair value at year end and at conversion.
Notes
Convertible notes under the fair value option: conversion price, shares, calibrated rate and fair values.
Series B
The closing with the conversions, the redemption value and the accretion schedule in temporary equity.
Earnings
Financing charges of 2025 and 2026 line by line, and the balance sheet lines at each year end.
Checks
General checks and the figures of the book, with an overall status.

What the worked case returns

MeasureValue
Initial carrying amount of the term loan$18,461,480
Effective interest rate11.09%
10 percent test: change in present value5.20%
New effective rate after the amendment12.44%
SAFE fair value at 31 December 2025$4,420,000
Convertible notes fair value at 31 December 2025$9,378,000
Series B carrying amount at the closing$40,875,675
Financing charges in 2025 earnings$5,216,099

The 10 percent test discounts both cash flow streams at the original effective rate without the third-party costs: 10.75%, not the 11.09% that drives interest expense. At that rate the new terms move the present value by 5.20%, below 10 percent, so the amendment is a modification and the loan takes a new effective rate of 12.44%.

How to use it on your own case

  1. Enter the term loan, the lender fee, the third-party costs and the fair value of the Series A warrant.
  2. Enter the amendment terms; Amendment runs the 10 percent test and, below 10 percent, the modified schedule.
  3. Enter the SAFE and the notes, with the scenarios of the valuation specialist; their tabs calibrate the rate and value them at year end.
  4. Enter the Series B price, new money and costs; Series B books the conversions and the accretion to the redemption value.
  5. Check that the Checks tab reads ALL PASS before you take any figure into a memo.

Questions people ask about it

Why is the 10 percent test run at a lower rate than the effective interest rate?

The test compares cash flows between the debtor and the creditor, so the third-party issuance costs stay out of the rate: 10.75% in the case, against 11.09% for interest expense. The lender fee and the warrant stay in, because they came out of the lender's proceeds.

Why is the SAFE a liability?

On a sale or listing before the next round, the SAFE may require the issuer to buy out the holder's claim on its equity by paying the purchase amount in cash, on an event the issuer does not control: an obligation to repurchase the issuer's equity shares by transferring assets, or indexed to such an obligation. That makes it a liability under ASC 480 (the second class), measured at fair value: $4,420,000 at the first year end in the case.

Where does the Series B go?

Redeemable at the holder's option, the Series B is not a liability under ASC 480 but sits in temporary equity, between liabilities and stockholders' equity, at $40,875,675 at the closing, then accreted to its redemption value of $41,475,675.

Go further

The free workbooks of The Debt and Equity Accounting Handbook go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Debt and Equity Accounting Handbook. See the book.