Skip to main content

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 A

Offer B

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.

Request the $79 workbook