ALDER CREEK DAIRY | AGRICULTURAL CREDIT PROJECT
Independently prepared fictional educational case study
Analysis date: October 24, 2026 | Reference ACD-2026-01

DELIVERABLES
Alder_Creek_Dairy_Underwriting.xlsx - 14-tab integrated financial model.
Alder_Creek_Credit_Memorandum.pdf - four-page credit decision memorandum.
Alder_Creek_Credit_Committee.pptx - six editable committee slides.
Dairy_Underwriting_Project_Summary.pdf - one-page executive summary.
Dairy_Lending_Business_Development_Plan.pdf - separate 90-day appendix.
Validation_Summary.pdf - calculation review and verification limits.
Read_Me.txt - controls and refresh guide.

START AND CUSTOMIZE
Open in Excel with Automatic calculation, including data tables. The saved
case is Base. Dashboard is the main output; StartHere provides native
internal navigation. There are no macros or external workbook links.
Edit blue input values on pale gold backgrounds. Gray input-panel cells
contain calculations or fixed model scope. Financial results are formulas
or native Excel data-table outputs; inputs themselves remain editable values.
Labels and dated research observations are text.

ONE ASSUMPTIONS SECTION
D5 selects 1 Base, 2 milk, 3 feed, 4 production, 5 variable rate, 6 combined.
D8:J43: annual herd, production, prices, costs, owner needs, working capital
and LOC. H8:J8 calculate the expanded herd; D8:G8 are separate inputs.
D52:D71: new loan, equity, cattle, rate, term, funding and credit thresholds.
D54:D55 calculate PPE and cattle project costs.
D73:D83: opening financial balances at December 31, 2022.
D95:D99: opening herd and animal-unit screening parameters.
D102:D105: expansion PPE components; D106:D109 reconcile project financing.
D112:F114: opening existing loan principal, rates and remaining months.
D118:E124: collateral market values, advance factors and other prior liens.
D127:G132: scenario presets. D135:G138: sensitivity grid increments.
Stress E6:E9 are additional manual shocks, normally zero. Grid increments
and manual shocks add to the selected case; return the selector to Base
and manual shocks to zero to reproduce the delivered report figures.

SCOPE AND UNITS
2023-2025 fictional history; 2026 estimate; 2027-2029 projections. Monthly
term debt extends through 2042. Funding year may be 2027-2029; align herd
freshening and other annual drivers after timing changes. Do not extend
the seven-year financial horizon by changing a year label.
Annual statements display USD thousands; underlying values and input cells
remain full USD. Monthly amortization displays full USD. Prices use USD/cwt;
production uses pounds or cwt as labeled. Mature cows include dry cows.

MODEL FLOW AND REVIEW
Operations and Dairy calculate production, revenue and cash expenses.
Debt calculates monthly amortization, annual service and current maturities.
Income, Balance and CashFlow reconcile accrual earnings, cash and equity.
Capacity defines distinct coverage ratios and break-even prices. Collateral
documents prior liens and lending values; Stress contains two native grids.
Audit is a terminal review area. Sources owns research and accounting limits.
Loan structure is with Collateral; the development plan is a separate PDF.

PDF and PowerPoint reports are fixed snapshots, not live links. Refresh them
separately after Excel inputs change. The live credit screen is a model
screen; it cannot establish appraisal, permit, lien or final approval status.
Review cash, repayment, project financing and Audit after every material edit.
The model does not add automatic borrowing to conceal a cash deficit.

EVIDENCE AND LIMITS
USDA NASS, UW Extension, Wisconsin DNR and USDA ERS references include dates,
URLs and locators on Sources. Industry benchmarks are separately identified
from fictional borrower inputs and author underwriting thresholds. No actual
borrower, internal lender policy, lender affiliation or endorsement is implied.
Managerial accrual simplifications, annual seasonality limits and exclusions
are disclosed in Sources and the memorandum. The package is educational.

Verification includes independent financial reconstruction, saved-formula
recalculation, sensitivity checks, input changes, cross-file figure matching
and visual review. See Validation_Summary.pdf for the checks and boundaries.
Native Excel and PowerPoint desktop execution was not performed.
