Construction Loan Interest Reserve & LTC Sizing Calculator: Monthly Draw Schedule, Funded Reserve, LTC/LTV Test (Excel)

Size a construction loan to the lower of loan-to-cost and loan-to-value, with the funded interest reserve and origination fee solved together from a monthly, equity-first draw schedule.

, , , ,
, , , ,

Construction lenders size to total project cost, and total project cost includes the interest reserve that the loan itself has to fund. A larger loan means more interest, more interest means a larger budget, and a larger budget supports a larger loan. Most quick spreadsheets break that loop with a plugged reserve number. This calculator solves it: the loan commitment, the funded interest reserve and the origination fee are solved together from a monthly draw schedule, using Excel’s iterative calculation with a circuit breaker.

Who it is for

Small and mid-size developers preparing a construction loan request, brokers checking how much a lender’s LTC and LTV limits will actually fund, and credit analysts who want a fast, transparent check on a borrower’s interest reserve before building a full model.

Inputs

  • Land or acquisition cost, hard costs with contingency, soft costs and the share of soft costs paid at closing
  • Construction period of 1 to 36 months, with hard costs drawn on an S-curve or straight line
  • Maximum loan-to-cost, maximum loan-to-value on as-completed value, all-in interest rate and origination fee
  • Stabilised NOI for a debt yield read

What it calculates

  • Monthly schedule: costs by month, equity drawn first, then loan draws, with interest on the opening balance each month funded from the reserve
  • Loan sizing: loan commitment at the lower of LTC and LTV, and which constraint binds
  • Summary: interest reserve, origination fee, total project cost, equity required, LTC, LTV, debt yield, reserve as a share of the loan and the month loan draws begin
  • Rate shock: approximate reserve shortfall if the rate is 100 basis points higher
  • Integrity checks: closing balance equals commitment, equity fully drawn, sources equal uses, valid month count
  • Charts: loan balance by month and monthly equity versus loan funding

Sample deal included

The file ships with a worked example: $2.5m land, $9.0m hard costs plus 5% contingency, $1.5m soft costs, 18-month build, 65% LTC and 60% LTV on a $19.0m as-completed value, 9.50% rate and a 1% fee. It solves to a $9.14m loan, a $514k interest reserve and $4.92m of equity, with loan draws starting in month 5. These figures were checked against an independent calculation.

Format

One .xlsx file with four tabs (Start Here, Summary, Inputs, Schedule). No macros. Input cells are yellow with blue text; everything else is formula. Works in Excel and Google Sheets with iterative calculation switched on; instructions are on the Start Here tab.

Built with AI assistance and checked against an independent calculation. Educational tool; not lending or investment advice.

You must log in to submit a review.