The Hard Money Lender Comparison Spreadsheet That Ranks True Cost

Ask a flipper how they picked their hard money lender and most will name a number: the interest rate. Lender A quoted 9.99 percent, Lender B quoted 11.5 percent, so they went with A and felt smart about it. Then the loan closed, the fees came out at the closing table, the draws got nickel-and-dimed by inspection charges, and the interest reserve ate six months of payments on a five-month hold. The 9.99 percent loan cost them thousands more than the 11.5 percent loan would have. A hard money lender comparison spreadsheet in Excel exists to stop exactly this: it strips the headline rate off the cover page and ranks every lender on the number that actually leaves your bank account.

The rate is the one cost hard money lenders advertise loudly because it is usually the one that matters least on a short flip. Points, origination, junk fees, draw inspection charges, interest reserve rules, and prepay penalties do the real damage. This article shows you how to lay out a comparison sheet with lenders as columns, load in the fees they bury on page four of the term sheet, and let a ranking formula tell you which lender is cheapest for the specific deal in front of you. Not in general. For this deal, at this hold length.

The Rate Sheet Lies, and It Costs Real Dollars

Here is a live comparison on one deal. Purchase price $220,000, rehab budget $65,000, total project cost $285,000, ARV $360,000, planned five-month hold. Three real-shaped lenders:

Read the last two rows again. The lender with the cheapest rate is the most expensive loan. Lender A costs $6,088 more than Lender B on the same deal, and Lender B also funded $28,500 more of your money (90 percent LTC versus 80 percent), so you left less of your own cash in the deal and your return on cash climbed on top of the savings. If you do the deal with Lender A, you spend $22,696 to borrow money for five months. If you do it with Lender B, you spend $16,608 and keep more cash liquid. Same house, same timeline, a $6,088 swing you never see if you shop on rate.

That is the entire argument for building the sheet. A single-loan calculator answers "what does this loan cost." A comparison sheet answers the question that actually decides the deal: "which of these three costs me the least, and by how much." If you have not built the underlying cost math yet, the companion hard money loan calculator walks through the interest and reserve mechanics line by line. This piece assumes that math and puts three lenders side by side.

Lay It Out With Lenders as Columns

The layout is the whole trick. Deal-level inputs live in one column on the left because they do not change between lenders. Lender-specific inputs get one column each, so you can drop in a fourth or fifth lender by copying a column. Every formula reads across the row.

Deal inputs in column B:

Lender inputs in columns C, D, and E (Lender A, B, C):

The "Avg Outstanding % of Loan" in B7 is the input generic calculators ignore. On a flip with draws against receipts, you do not pay interest on the full loan from day one. You pay it on the money that has actually been advanced. Across a typical rehab the average outstanding balance runs 70 to 90 percent of the loan depending on how front-loaded the work is. Model it as one number so every lender gets judged on the same footing.

The Junk Fee Rows Nobody Puts on the Rate Sheet

Row 14 is a single total, but it hides the fees that make or break a lender. Build a small block below the sheet that itemizes them, then sum it into row 14. These are the line items that never appear next to the rate:

Sum each column with =SUM(C_start:C_end) and feed it into row 14. The draw inspection line is the sneaky one. A lender that charges $350 per draw and forces four draws costs you $1,400 in fees plus the delay of waiting on an inspector before the money releases. A lender at $150 per draw with three draws costs $450. That gap alone can swing which lender you pick, and it is invisible on a rate comparison.

The Formulas That Normalize Every Lender

Now the calculation rows. Each one is written for column C (Lender A) and copies straight across to D and E, because all the lender inputs sit in the same rows. That copy-across behavior is why the column layout matters.

Loan Amount in C16: =C10*($B$3+$B$4)

Loan to cost times total project cost. Lock the purchase and rehab cells with dollar signs so they hold when you copy across. Lender A: 0.80 times $285,000 = $228,000.

Points Cost in C17: =C16*C12/100

Points as a percentage of the loan, paid at close. Lender A: $228,000 times 3.5 divided by 100 = $7,980.

Effective Interest Months in C18: =MAX(C13,$B$6)

This is the reserve trap in one formula. You pay interest for the greater of the reserve months or your actual hold, because lenders rarely refund an unused reserve. Lender A forces a six-month reserve on a five-month hold, so it charges six. Lenders B and C have no reserve, so they charge the five months you actually hold.

Interest Cost in C19: =C16$B$7(C11/12)*C18

Loan amount times average outstanding percentage times the monthly rate times the effective months. Lender A: $228,000 times 0.80 times (0.0999/12) times 6 = $9,111. Notice the 9.99 percent lender pays more interest than the 10.75 percent lender here, purely because the reserve forces an extra month on the meter.

All-In Cost of Capital in C20: =C17+C14+C19

Points plus junk fees plus interest. Lender A: $7,980 + $5,605 + $9,111 = $22,696. This is the number that should decide the loan, and it is the number no rate sheet shows you.

Cost per $1,000 Borrowed per Month in C21: =C20/(C16/1000)/$B$6

The great equalizer. Because each lender funds a different loan amount, raw dollars are not apples to apples. This normalizes cost against how much money you actually got and how long you held it. Lender A: $22,696 divided by 228 divided by 5 = $19.91. Lender B lands at $12.95, Lender C at $14.24. Cheaper per dollar deployed, and it funded more of the deal.

The Ranking Line and the Hold-Length Crossover

Two formulas turn the sheet from a table you have to read into a sheet that tells you the answer.

True-Cost Rank in C22: =RANK(C20,$C$20:$E$20,1)

Ranks each lender by all-in cost, cheapest first. Put a matching rank on rate in C23 with =RANK(C11,$C$11:$E$11,1) and watch the two ranks disagree. On this deal, rate rank says A is number one. True-cost rank says A is dead last. That divergence is the finding you paid for.

Decision Flag in C24: =IF(C20=MIN($C$20:$E$20),"BEST ALL-IN",IF(C14/C16>0.02,"JUNK FEE FLAG",""))

It labels the cheapest lender "BEST ALL-IN" and flags any lender whose junk fees exceed 2 percent of the loan as a "JUNK FEE FLAG." Lender A's fees are 2.46 percent of the loan, so it lights up red on top of ranking last. Lender B wins the flag. Lender C stays quiet. You can scan three columns and know the answer in one second.

Here is the part that makes the sheet worth re-running for every deal. The winner changes with your hold length, because a reserve and points are sunk costs while interest accrues over time. Run the same three lenders at a two-month hold and a nine-month hold:

At two months, Lender A costs the same as at five months, because the six-month reserve is a sunk expense the moment you sign. If you flip fast, that reserve is pure waste. At nine months, the picture flips again: Lender C's lower rate finally beats Lender B's, because on a long hold the rate compounds and the upfront points matter less. Lender A never wins at any hold length. The RANK and MIN formulas re-sort automatically the instant you change B6, so you are never guessing. Input the hold length you actually believe, not the one the lender's timeline assumes.

A Buy Box for Lenders, Not Just Deals

Flippers build a buy box for properties and then shop lenders on vibes. Turn the comparison sheet into a lender buy box you run before you even have a deal under contract. Keep a standing tab with your three or four go-to lenders and update it whenever a term sheet changes. Before you accept a loan, confirm every one of these is entered, because each is a place lenders hide cost:

• Points and any separate origination fee, entered as real dollars, not just the percentage
• Every junk fee itemized: underwriting, doc prep, processing, funding, admin, wire
• Draw count, per-draw inspection fee, and how long draws take to fund
• Interest reserve months and whether unused reserve is refundable
• Prepay penalty or minimum interest floor, in months
• Extension fee per month and the term length before extensions start
• The realistic hold, not the optimistic one, because it re-ranks the field

If a lender will not give you the fee schedule in writing before you commit, that is your answer. The all-in cost you cannot see is the all-in cost you will pay.

Stop Shopping on Rate

The cheap rate is often the expensive loan. Points, reserves, draw fees, and junk charges routinely swing the true cost of a hard money loan by five figures on a single flip, and none of them appear next to the rate the lender leads with. A comparison spreadsheet that stacks lenders in columns, itemizes the fees they bury, normalizes to cost per dollar per month, and re-ranks the field for your actual hold length turns a gut decision into a math decision. Build it once and every future deal takes ten minutes instead of a leap of faith.

Our Flip and BRRRR Calculator carries this lender comparison logic inside the full deal model, so the winning loan flows straight through to your net profit, cash to close, and return on cash instead of living in a separate workbook. It already models points, interest reserves, draw structures, and holding costs against ARV, and it scores the deal on dollars-per-day and cash-at-risk so you see how the financing choice moves your actual return, not just your cost of capital. Drop in your purchase price, rehab, ARV, and three lender term sheets, and let the numbers pick the loan before you sign anything. Shop the true cost, not the cover page.