Financial Model, Loans & Lending Businesses, Real Estate, Residential Properties

Cash Flow Analysis, Debt Service Coverage, Excel, IRR (Internal Rate of Return), Loans, Return on Investment (ROI), Sensitivity Analysis

Underwrite a single fix-and-flip or bridge-rehab loan from both sides of the table in one workbook.

Lender view

Loan commitment sized as the lesser of loan-to-cost (purchase LTC plus a share of rehab and contingency) and a maximum loan-to-ARV cap, with the binding constraint called out
Purchase funded at closing; the rest held back and drawn monthly over the rehab period
Interest on drawn balance or on the full commitment (Dutch interest toggle), origination points and lender fees
Monthly lender cash flows and annualized IRR

Borrower view

Total project cost: purchase, closing, rehab with contingency, holding, financing and selling costs
Projected profit and margin on ARV, cash required, return on cash and annualized return, skin in the game

Underwriting tests (pass/fail)

Loan-to-ARV within cap, minimum profit margin, minimum borrower equity, rehab period within hold, sale proceeds cover payoff.

Sensitivity

Borrower profit across ARV -15% to +10% and rehab overruns of 0-30%, loan-to-ARV under ARV declines, breakeven ARV and ARV cushion, with a chart.

Tabs

Start Here, Inputs, Summary, Draws (months 0-12 with chart), Sensitivity. Yellow cells are inputs; everything else is formula. No macros. Hold period up to 12 months.

Built with AI assistance and checked for formula errors. A modeling template, not lending or investment advice.

You must log in to submit a review.