Real Estate
CRE Due Diligence Tracker
Every diligence item, who owns it, when it is due and what it cost
What it does
Inside the workbook.
What is outstanding, what is overdue, and what diligence has cost you so far.
WHAT YOU GET
- A 5-tab workbook: START HERE · DEAL SETUP · DILIGENCE REGISTER · DASHBOARD · FAQ
- 2 charts that update themselves as you type
- Realistic example figures already filled in, so you can watch it work before you replace them
- A plain-English START HERE guide built into the file, plus a 12-question FAQ
WHY THIS ONE
- Works in FREE Google Sheets. Also opens in Excel. No add-ons.
- One-time purchase. No subscription, no account, no upsell.
- Nothing connects to your bank or your software. You type the numbers in yourself.
- Input cells are unlocked and formulas are protected so a stray paste cannot break the math — and there is NO password, so you can unlock and change anything.
- Every formula was opened in a calculation engine, fully rebuilt, and checked against values worked out independently of the file. If one disagreed, it would not be on sale.
HOW IT WORKS
1. Download and open the file. Nothing to unzip.
2. Read the START HERE tab — about two minutes.
3. Type your numbers over the examples in the blue cells.
GOOGLE SHEETS
File > Import > Upload > choose the file > Replace spreadsheet. No XLOOKUP, no LAMBDA, nothing that breaks on import.
INSTANT DOWNLOAD
Available immediately after purchase under Purchases and Reviews. Nothing ships.
REFUNDS AND SUPPORT
Instant digital downloads cannot be returned automatically through Etsy. Message me — if something is broken or not what you expected, I will fix it or refund you.
AI DISCLOSURE
This workbook was built with AI assistance. Every formula in it was then opened in a calculation engine and tested against independently calculated values before it was listed. The math is checked, not assumed.
This is a digital file only. No physical item will be shipped.
The proof
Every figure, worked out twice.
Before this workbook was listed it was opened in a calculation engine, rebuilt, and every headline figure was compared to a value computed independently in code from the same seed inputs. This is an excerpt of that ledger.
- BuildGenerated from a written spec, opened in a calculation engine, fully rebuilt.
- RecomputeEach figure worked out again in code — never read back from the sheet.
- CompareCell by cell, to a stated tolerance. One disagreement and it does not go on sale.
| Sheet | Cell | Expected | Calculated | Figure | |
|---|---|---|---|---|---|
| DEAL SETUP | F5 | 44 | 44 | ✓ | Days left in diligence period |
| DEAL SETUP | F6 | 72 | 72 | ✓ | Days to closing |
| DEAL SETUP | F7 | 60 | 60 | ✓ | Diligence window length |
| DEAL SETUP | F8 | 28 | 28 | ✓ | uffer expiry to closing |
| DEAL SETUP | F9 | 26.7% | 26.7% | ✓ | Share of window elapsed |
| DEAL SETUP | F12 | 14 | 14 | ✓ | Items on register |
| DEAL SETUP | F13 | 11 | 11 | ✓ | Items still outstanding |
| DEAL SETUP | F14 | 1 | 1 | ✓ | Items overdue |
Questions
Before you buy.
Will it work in free Google Sheets?
Yes. File > Import > Upload > choose the file > Replace spreadsheet. Every formula was written to run in Google Sheets as well as Excel — no XLOOKUP, no LAMBDA, no dynamic arrays, no add-ons and no subscription. The dropdowns, the date maths and the dashboard counts all survive the import.
Why can't I type in some cells?
Those are formulas, locked so a stray paste cannot break the math. There is no password. Review > Unprotect Sheet in Excel, or Data > Protected sheets and ranges in Google Sheets, opens the whole thing if you want to change something.
Is this legal advice? Can I rely on the dates it shows me?
No, and no. This is a tracking tool, not legal, tax or lending advice. Your purchase and sale agreement is what actually decides when your diligence period ends, what notice you have to give and whether your deposit goes hard. Read it with your attorney and type the dates it gives you into Deal Setup. If a 1031 exchange is in play, confirm every date with your qualified intermediary and your tax advisor before you rely on it.
Where does the 85 percent loan-to-value figure come from?
From the Office of the Comptroller of the Currency's Comptroller's Handbook, "Commercial Real Estate Lending," Version 2.0, March 2022, in the section "Supervisory Loan-to-Value Limits" — which sets out the Interagency Guidelines for Real Estate Lending. Improved commercial and multifamily property is 85 percent; raw land is 65, land development or improved lots 75, commercial construction 80. It is a US government publication and free to read at occ.gov. It is a supervisory ceiling, not a promise — your bank's own credit policy governs what it will actually lend you.
Why does the LTV divide by the lower of price and appraisal?
Because that is how the federal guidelines define value on a purchase: "For loans to purchase an existing property, the term 'value' means the lesser of the actual acquisition cost or the estimate of value." So if your appraisal comes in above your price, the price is what counts. Plenty of spreadsheets get this backwards and flatter the deal.
Does it work in free Google Sheets?
Yes. Every workbook is built with an older, universal formula vocabulary so it imports into free Google Sheets without add-ons, and it opens in Excel as well. You get both in one purchase.
How was it tested?
The workbook was opened in a calculation engine, fully rebuilt, and 39 figures were compared to values worked out independently in code from the same seed inputs. One disagreement would have stopped the release. An excerpt of that ledger is on this page.
Get it
CRE Due Diligence Tracker — $24.99
Instant download on Etsy. Google Sheets and Excel versions in the same purchase. No subscription, ever.
Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.