
| Construction, Development, Financial Model, Loans & Lending Businesses, Real Estate |
| Calculator, Debt Schedule, Developers, Excel, Loans |
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.
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.