GLGRANT LUEDTKE
← Finance work

INDEPENDENT PROJECT · 2026 · FICTIONAL EDUCATIONAL CASE

Dairy expansion
credit review.

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

Build the operating and financing picture

I prepared an integrated 2023–2029 Excel model linking production, financial statements, and debt amortization for the proposed expansion.

Test repayment capacity and risk

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.

Make a supported recommendation

Term debt coverage in this case

Proposed structure1.08×
Case minimum1.25×

Recommendation: decline the proposed structure.

I documented the reasoning and conditions for reconsideration in a credit memorandum and committee presentation.

What the project demonstrates

  • Connecting dairy operating assumptions with financial statements and debt schedules.
  • Evaluating repayment capacity, liquidity, and collateral considerations.
  • Testing sensitivity to agricultural and financing risks.
  • Communicating a credit recommendation and the conditions for another review.

EXAMINE THE ACTUAL WORK

Model. Memo. Presentation.

All borrower figures and lending thresholds are fictional educational assumptions.

DISTINGUISH THE COVERAGE MEASURES

Repayment beyond one headline ratio.

1.08×

Term debt coverage

2027 base case, after living costs and owner income taxes.

1.51×

Business DSCR

Before owner withdrawals; this measure precedes important cash uses.

0.40×

Replacement cash DSCR

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

From assumptions
to a clear recommendation.