top of page

When Excel Turns a 1.08x DSCR Into a 22% IRR (Send Help)
Broker: “DSCR 1.35x day one.” 🤡 Lender: “Cool—send T-12, rent roll, and proof the tenants exist on weekends.” Me in Excel at 2:13 AM: delete one hardcode → IRR jumps 9%→22%; underwriting or Excel war crime? 😵💫 Client: “Can we pivot to SBA, add mezz, 30-day close, and also make it industrial?” Sure, let me move the loading docks with my mind.
ricklahkar
May 41 min read
Excel Promised 1.30x; The Lender Started an Excel Crimes Podcast
Expectation: DSCR 1.30x after 'light' payroll trim and a cap rate 'vibe check' 🧮 Reality: tax reassessment + Florida insurance = 1.06x; Excel rounds up, lender rounds you out Broker: It’s stabilized once we 'stabilize it' Lender: Upload v37 of the T-12, Argus export, SNDA, and an estoppel from the soda machine 🤡
ricklahkar
May 31 min read
When Your 6 Cap Ghosts You at Due Diligence
Broker: It’s a clean 6 cap, turnkey, 'light value-add' Lender: After DSCR haircuts, meteor-strike reserve, and an interest cap, it’s a 4.1 🤡 Appraiser: Great news—I comped it to a goat barn and a RadioShack from 2008 Me at 2:13 AM: committing VLOOKUPs I can’t defend, whispering 'stabilized by Q3' 🧮
ricklahkar
May 21 min read
When One Excel Cell Deletes Your DSCR And Your Weekend
Expectation: cap rate +10 bps and model still at 1.30x DSCR 😎 Reality: one broken link to Sheet3!Broke, taxes auto-grow, DSCR 1.19x, lender now a myth Broker: stabilized in 90 days; T-12: 62% economic occupancy and a boiler older than me Me to Excel: stop rounding to pro forma and show how we pay debt service 🫠
ricklahkar
May 11 min read
I Changed One Cell And The DSCR Called 911
Broker: It's a light value-add Lender: Cool—send T-12, rent roll, estoppels, and Version_27_FINAL_FINAL.xlsx Me: tweak one cell -> Argus combusts, Excel circular refs, DSCR 1.35 to 0.98 ☠️ Client: Can we close Friday? Me: Sure, if SOFR naps, HVAC repents, and Phase I forgets the dry cleaner 😂
ricklahkar
Apr 301 min read
Pro Forma Uses 13 Months of NOI, Lender Brings 0% Humor
Broker: It’s stabilized Lender: Define “stabilized” Seller: We counted 13 months of NOI and forgot taxes Me: Committing Excel crimes until DSCR turns itself in 🚓
ricklahkar
Apr 291 min read
The DSCR Hunger Games: Broker vs Lender vs Client
Broker: “Stabilized by Q2.” Lender: “Based on… vibes?” Client: “Can we close Friday?” 😂 Me underwriting: copy/paste one cell → model shows 1.35x DSCR; reality: levered IRR says “nah.” Tour notes: “natural light.” Translation: holes in the roof. “Flexible zoning.” Translation: manifesting. Final hour: title uncovers a 1978 rail easement; appraisal finds 0.5 parking/KSF; my deal: finds the exit. 💀
ricklahkar
Apr 281 min read
Underwrote a 6 Cap, Got a 1.09x DSCR and a Migraine
Broker OM: Stabilized 6% cap, loss-to-lease upside, RUBS day one 🧮 T-12: insurance +48%, delinquency is a novella, 'other income' = one dusty vending machine Lender: Please re-underwrite at 1.30x DSCR, 8% econ vacancy, and oh—rates popped 50 bps Me at 2:13 AM in Excel: circular refs, negative levered IRR, still marketing it as 'light value-add' 🤡
ricklahkar
Apr 271 min read
Broker Math vs Lender Math: Mortal Kombat
Broker: 6.75% cap, T-3 rent roll trending up, “easy close” 🔥 Lender: Stress at SOFR+300, 1.35x DSCR, taxes reset to full—proceeds = Uber budget Me in Excel: change one rent growth cell; IRR swan-dives, waterfall drowns me 😵💫 Client: Why is equity 42% now? Me: IC underwrote the T-12, not your dreams
ricklahkar
Apr 261 min read
Expectation: 1.30 DSCR | Reality: T-12 Says 1.18 😵💫
Broker: Rent roll is spotless, like my pro forma Lender: Please upload the T-12, estoppels, SNDA, and a time machine Me in Excel: Hide column G, NOI magically +12.6% 🧮 Underwriter: Cool—adding roof reserve, 5% vacancy, and vibes Deal: Flatlines 3 minutes before rate lock
ricklahkar
Apr 251 min read
When Excel Says the Deal Works (But the Lender Can Read)
Broker: It's 'light value-add', 3-month stabilize, easy refi. Lender: Need 1.25 DSCR, 12 months P&I reserves, and your childhood diary. Me in Excel: Goal Seek until IRR does CrossFit; VLOOKUP to a rent roll that moved. Appraisal: Cap rate says no. Model: circular reference. Deal: LOI—Lots Of Imaginary. 🤡📉
ricklahkar
Apr 241 min read
Excel Promised a 6 Cap, Lender Said lol — My DSCR Left the Building
Broker: It’s a clean 6 cap, light value-add Lender: After T-12/T-3 and a vibes check, it’s 4.1 with rollover, tax escrow, and a rate cap Excel: Circular reference detected; DSCR has left the chat 🧮🤡 Client: Close Friday? Me: Sure—once Phase I stops yelling "REC" and the roof escrow stops multiplying
ricklahkar
Apr 221 min read
When Your Pro Forma Is 4D Chess and the Lender Plays Minesweeper
Broker: It’s a simple 7% cap, clean T-12, light value-add Lender: Remove 43 temporary addbacks, add TI/LC reserves, and stress to 9.5% — still pencils? Me in Excel: uncheck one vacancy macro; DSCR swan-dives from 1.35x to 0.99x; circular ref sirens 🤡 Client: Can we close Friday? Also the rent roll is a JPEG of a fax from 2003 🧮
ricklahkar
Apr 211 min read
Rent Roll Says 95%, Roof Says Pray
Broker: Pro forma at 7 cap Lender: After stress test? It’s giving 3 cap Me in Excel: v23_FINAL_final2.xlsx conjuring NOI with circular refs 🕯️ Inspector: FYI your TI/LC is actually raccoons 😬
ricklahkar
Apr 201 min read
Underwriting Be Like: 10 bps Cap Rate, My IRR Files For Divorce
Broker: Slam dunk, 6 cap, turnkey, trust me Lender: Need T-12, T-3, T-1, three DSCR stress tests, and why is 'Grandpa' on the rent roll? Me in Excel at 1:47am: Goal Seek vs Reality — circular ref says lol, 10 bps cap-rate move nukes IRR 📉 Client at closing: Quick pivot to axe-throwing pickleball anchor? Me: DSCR just rage-quit 🫠
ricklahkar
Apr 191 min read
When Your DSCR Is a Suggestion and Excel Is a Crime Scene
Broker: DSCR 1.35x on pro forma Lender: Cool—send T-12, T-3 rent roll, and proof you don’t use VLOOKUP Me opening model: FINAL_v38.xlsx, 62 tabs, 11 hidden, one labeled 'Do_Not_Touch' 🙃 F9 pressed: circular reference → DSCR 0.98x, debt yield crying, cap rate allergic to reality Client: Can we hit 80% LTV at 6 cap? Me: Sure, if we underwrite in Narnia 🧙♂️
ricklahkar
Apr 181 min read
Broker vs Spreadsheet: Who Lied First?
Broker: Pro forma hits 1.35x DSCR, 75% LTV easy. Lender: Cute—send T-12, rent roll, and a Phase I that isn’t from 2019. Excel: Circular reference engaged; capex vanished; IRR now 28% allegedly 🤡 Client: We still closing Friday? Me: Absolutely... in a different timeline.
ricklahkar
Apr 171 min read
IC Monday: When DSCR Cheats On You With Real T-12s
Broker: DSCR pencils at 1.27x if you believe in add-backs Lender: Cool, just need estoppels from 37 tenants and one from the raccoon in Suite B Excel: Circular reference detected—just like your capex timeline Client: So we hit a 5 cap by calling parking revenue 'AI adjacency'? 🤡
ricklahkar
Apr 161 min read
When Excel Says 18% IRR But The Rent Roll Says “LOL”
Broker: Proforma is “conservative” at 5% vacancy Me in Excel: delete reality until DSCR=1.25 and IRR=18% 🧮 Lender: Cool—send T-12, rent roll, tax certs, and your first-born Excel: #VALUE! the second I add real taxes; deal re-traded into dust 😵💫
ricklahkar
Apr 151 min read
DSCR Left the Chat: Excel Edition
Broker: Pro forma is 'conservative' Excel: Circular ref engaged — DSCR jumps 1.35x -> 0.98x when taxes uncap Lender: Remove optimism, add SOFR+450, a rate cap, and make TI/LC perpetual Me at 2:11AM: color-coding the T-12 while Argus crashes and one tenant has three SNDAs 😵💫🧮
ricklahkar
Apr 141 min read
bottom of page
.png)