Driscoll's berries
Session 02Exercise A

Session 02 · Capital Structure

DSCR Simulator

Adjust the inputs. Watch whether the business can service its debt.

Your P&L Starting Position

Revenue

$100.0m

Gross Profit

$30.0m

EBITDA

$5.0m

Business Parameters

Revenue
$100m
50m200m
Gross Margin
30%
10%60%
EBITDA Margin
5%
1%20%
Capex (annual)
$2m
0m10m
Working Capital Change
$+1m
-2m5m

Existing Debt

Existing Debt Balance
$20m
0m60m
Interest Rate on Existing Debt
6.5%
3%12%
Remaining Term on Existing Debt
7 years
1 yrs15 yrs

New Loan Request

Loan Amount Requested
$10m
1m40m
Interest Rate on New Loan
7%
4%14%
Loan Term
5 years
1 yrs10 yrs

Cash Flow Available for Debt Service (CFADS)

EBITDA+$5.0m
− Tax$1.1m
− Capex$2.0m
− Working Capital Change$1.0m
= CFADS+$0.9m
Total Debt Service$6.1m
DSCR (CFADS ÷ TDS)0.15×

Covenant Dashboard

DSCR
0.15×Breach
Interest Cover
2.5×Watch
Leverage
6.0×Breach

Covenant Bars

DSCR
0.15x
Threshold: 1.3xRange max: 3.0x
Interest Coverage
2.50x
Threshold: 2.0xRange max: 6.0x
Net Leverage (Debt/EBITDA)
6.00x
Threshold: 0.0xRange max: 6.0x

Bank Decision Simulator

✗ Loan Declined

DSCR of 0.15× signals the business cannot service this debt. The bank will decline. Try reducing the loan amount to ≤$0.0m, extending the term, or improving EBITDA margin.

Total Debt
$30.0m
Annual Debt Service
$6.1m
Debt / Revenue
30.0%
CFADS
$0.9m

Key Insight

A 5% EBITDA margin on $100m revenue gives just $5.0m of EBITDA. Even before new debt, your existing $20m at 6.5% costs $1.3m/yr in interest. The thinner your margins, the smaller your borrowing headroom — and the faster a revenue shock turns a passing DSCR into a breach. That’s why lenders stress-test before they lend.

Bank's DSCR-implied max loan

Request $10m is above covenant limit

$0m