Term debt coverage
2027 base case, after living costs and owner income taxes.
INDEPENDENT PROJECT · 2026 · FICTIONAL EDUCATIONAL CASE
An integrated financial model, credit memorandum, and committee presentation connecting a dairy’s operating assumptions with a lending recommendation.
Agricultural credit analysis · Model, memo & presentation
I prepared an integrated 2023–2029 Excel model linking production, financial statements, and debt amortization for the proposed expansion.
The review analyzed term debt coverage, debt service coverage ratio (DSCR), working capital, and collateral lien priority. Stress tests considered milk prices, feed costs, production, and interest rates.
Term debt coverage in this case
Recommendation: decline the proposed structure.
I documented the reasoning and conditions for reconsideration in a credit memorandum and committee presentation.
EXAMINE THE ACTUAL WORK
All borrower figures and lending thresholds are fictional educational assumptions.

DISTINGUISH THE COVERAGE MEASURES
2027 base case, after living costs and owner income taxes.
Before owner withdrawals; this measure precedes important cash uses.
Also reflects working-capital growth and recurring replacement capital.
These definitions and figures belong to the October 24, 2026 fictional case. The memo and model explain the assumptions, sources, and limitations.
EXPLORE MORE FINANCE WORK