Lender-Bid Comparison
Compare term-loan offers on effective all-in borrowing cost, cash required at close and downside DSCR. Runs locally in your browser.
1Browser comparison
Adjust the borrower cashflow assumptions and two competing offers below. Notice how an offer with a lower quoted margin can carry a higher effective all-in cost or weaker downside DSCR once fees, DSRA and repayment shape enter the calculation.
| Offer | All-in cost | Cash at close | Base min DSCR | Downside min DSCR | Covenant status |
|---|
2Full Excel workbook ($79)
The downloadable Lender-Bid Comparison Workbook (Lender_Bid_Comparison_v1.0.xlsx) extends this engine to 4 side-by-side offers over a 300-month timeline with sculpted repayment, capitalised interest during construction, commitment and prepayment fee schedules, cash sweeps, refinancing dates, XIRR cost build-up and 22 integrity checks per offer.
127 automated tests pass against an independent Python reference engine across 10 scenarios, agreeing to 0.01 on balances and 1e-6 on rates. Calculation tool only. It does not recommend a lender or a loan.