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.