USDA OneRD B&I and REAP Guaranteed Loan 5-Part Independent Feasibility Schedule — Calculator, Excel Workpaper & API (BI-39)
Evaluates 7 CFR Sec. 5001.205(d) GAAP Tangible Balance-Sheet Equity Requirement (10% / 20%); 7 CFR Part 5001 Appendix A Economic & Market Breakeven Throughput Utilization; Technical Feedstock Supply-Contract Coverage & EPC Construction Contingency Audit; USDA OneRD Financial Feasibility DSCR (>=1.25x Base & +/-10% Adverse Stress). Submit: Total Project Cost (USD), New Venture Or Energy Flag, Bi Lender Spread, Loan Term Years. Excel Tabs: One RD 5Part Feasibility Summary, 5Yr Historical And Pro Forma IS, Monthly Cash Flow DSCR Coverage, Multi Scenario Stress Shock Matrix. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: 7 CFR Part 5001.205 Tangible Balance-Sheet Equity & Appendix A Five-Part Loan Feasibility Filing
Official Agency Form / Workpaper Standard: USDA 7 CFR Part 5001 Appendix A (OneRD B&I / REAP Feasibility Schedule)
Governing Accounting, Tax & Statutory Authorities: 7 CFR § 5001.303(c) & 7 CFR Part 5001 Appendix A (USDA Rural Development Business & Industry / REAP Guaranteed Loan Feasibility Study Requirements)
Common Practitioner & Search Aliases: USDA B&I Loan Feasibility Calculator, USDA REAP 7 CFR 5001 Tangible Equity, 10% and 20% Tangible Balance Sheet Equity, USDA OneRD 1.25x DSCR Stress Test, Rural Business Guaranteed Loan Sizing
Interactive USDA OneRD B&I and REAP Guaranteed Loan 5-Part Independent Feasibility Schedule Calculator (BI-39)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (2 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-39 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) 7 CFR Sec. 5001.205(d) GAAP Tangible Balance-Sheet Equity Requirement (10% / 20%) [7 CFR Sec. 5001.205(d) USDA OneRD Guaranteed Loan Tangible Equity Rule]
- (2) 7 CFR Part 5001 Appendix A Economic & Market Breakeven Throughput Utilization [7 CFR Part 5001 Subpart D Appendix A (Economic & Market Feasibility Prongs)]
- (3) Technical Feedstock Supply-Contract Coverage & EPC Construction Contingency Audit [7 CFR Part 5001 Appendix A Sec. (c) Technical Feasibility & Risk Mitigation]
- (4) USDA OneRD Financial Feasibility DSCR (>=1.25x Base & +/-10% Adverse Stress) [7 CFR Part 5001 Appendix A Sec. (d) Financial Feasibility & 10% Sensitivity Test]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 36-Month Historical Financial Statements, Tax Returns & 5-Year Monthly/Annual Project Financial Model (Sources & Uses) | Structured JSON object/array or CSV text |
FILE-2 | Client-Supplied Third-Party Design Engineer Technical Report, Process Flow Diagrams, EPC Schedule & Permits (Intake Input Only) | Structured JSON object/array or CSV text |
FILE-3 | Executed Off-Take Agreements / LOIs, Feedstock Supply Contracts & Target Market Competitive Pricing Dataset | Structured JSON object/array or CSV text |
FILE-4 | Executive Management Dossiers, Key-Person Resumes, Organizational Chart & Commercial Lender USDA Term Sheet | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | OneRD 5Part Feasibility Summary |
| Schedule 2 | 5Yr Historical and ProForma IS |
| Schedule 3 | Monthly CashFlow DSCR Coverage |
| Schedule 4 | Multi Scenario Stress Shock Matrix |
| Schedule 5 | Collateral OLV Discount Schedule |
| Schedule 6 | Technical Feedstock Mass Balance |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/suites/BI-39/compute" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-39",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})