top of page

My T-12 vs The Proforma She Told Me Not to Worry About
Expectation: 6-cap, 75% LTV, DSCR 1.30x, closing in 30 days Reality: Reassessed taxes vaporize NOI, DSCR 1.09x, lender: '55% max... and a rate cap' 😬 Broker: 'Taxes already modeled' — me reading page 73 rent roll footnotes: surprise 28% hike Excel: circular reference; me at 1:47am: circular life, Argus just crashed 🥲
ricklahkar
12 hours ago1 min read
When DSCR Does CrossFit But Appraisal Eats Pizza
Broker: 6-cap, turnkey, lender loves it Lender: Cool—send T‑12, rent roll, Argus, Phase I newer than my intern, and a DSCR that lifts Me in Excel: If I add one more “Other Income,” the model files a restraining order 🧮😵💫 Client: Close Friday? Me: After the surprise $800k roof and the estoppels coming back from vacation 🔥
ricklahkar
2 days ago1 min read
My Excel Just Committed Felony Underwriting
Broker: Numbers are clean, cap rate ‘market’ Lender: Please remove the 19 hidden sheets and the Magic NOI tab Client: Can we round DSCR to 1.25 because ‘future leasing momentum’? Me at 1:47 AM: VLOOKUP fighting rent roll gremlins, Other Income = Hope 😵💫 Excel crashes; file resurrects with a better IRR—pretty sure that’s securities fraud 🔥
ricklahkar
2 days ago1 min read
Expectation: 22% IRR, Reality: T-12 With Plot Twists
Broker: Pro forma rents are conservative Lender: Cool, email T-12, T-3, T-1, and maybe your soul Excel: IRR 22% if expenses take a nap 🧮😅 Seller: BTW roof is from 1927 and CAM reconciliations are interpretive Me: Extending LOI again like it's a free trial that never ends
ricklahkar
2 days ago1 min read
Broker vs Lender vs Excel: The 6 Cap That Wasn't
Broker: Pro forma DSCR 1.35x, 'light value-add', we’re cruising Excel: #REF! + circulars until my IRR becomes a mood ring💀 Lender: Need fresh T-12, 3rd-party rent roll, new leases, oh—and DSCR is 1.19x so +75 bps Me/Client: Expectation: 45-day close; Reality: TI/LC grenade, escrow holdback, retrade speedrun 🤡
ricklahkar
Oct 141 min read
Excel Promised 20 IRR, DSCR Told Me To Sit Down
Client: we need 20% IRR, no risk Broker: easy, just light value-add Excel: DSCR 0.98 because Opex is hiding in a merged cell 😵💫 Lender: please remove 'plug' from Sources & Uses Me: renaming final_FINAL.xlsx to this-time-i-swear.xlsx 📈
ricklahkar
Oct 111 min read
I Changed One Cell And The DSCR Filed For Bankruptcy
Broker: Whisper price is firm Lender: Sizing off T3 net of snowstorms, 1.35x, rate cap priced like a yacht Excel: You moved one row and now EGI says Saturday, DSCR says #DIV/0! 🧮 Client: At 5 cap we distribute, right? Me: At 7 handle debt we distribute kombucha samples 😵💫
ricklahkar
Oct 101 min read
My DSCR Says 1.30x, Lender’s Calculator Says “lol 1.09x”
Broker: Model’s clean, 1.30x DSCR, send the LOI Lender: Remove addbacks, add reserves, haircut M2M—now it’s 1.09x Excel: Circular reference detected; your exit cap was a prayer 😂 Me: Hitting F9 while Phase I discovers a 1987 dry cleaner plume ☠️
ricklahkar
Oct 91 min read
When the IRR Goes Witness Protection After One Hardcode
Broker: 50% LTV, quick close Lender: Cool, just send T-12, T-3, rent roll, estoppels, SNDA, Phase I, roof report, and your firstborn Me in Excel: add 19 tabs, hardcode one cell, IRR teleports from 18.1% to -3.7% 😵💫 Appraiser: Parking ratio mid, value lower; Client: But my pro forma says billionaire Seller at closing: BTW CAMs were vibes-based and two tenants are ghosts 📊
ricklahkar
Oct 81 min read
Expectation: Clean T-12; Reality: 47 Tabs And One REF
Expectation: 6% cap, turnkey, lender nodding Reality: T-12 is a scavenger hunt, Argus expired, DSCR 1.19, Excel screams #REF! Me: Rename CapEx to “value-add,” convince debt yield it’s a vibe 😂 Seller 11:59pm: “No TI/LC, but can you underwrite pro forma rent on T-0?” 🥲
ricklahkar
Oct 71 min read
When the 'conservative' OM meets my T-12 and Excel calls the cops
Broker: “Day-1 stabilized, light value-add” Lender: Great—prove DSCR > 1.35 with actuals, estoppels, SNDAs, and your blood type My Excel: adjust vacancy by 0.01% → waterfall detonates → #REF everywhere Me at 11:59pm: emailing Final_FINAL_v38, whispering “capex is non-recurring” 🧮😵💫
ricklahkar
Oct 61 min read
Cap Rate Catfish: OM Expectations vs Post-DD Reality
Broker: It's a clean value-add Lender: Need 3 more rent rolls, 2 more T-12s, and your childhood credit score Client: Can we hit 7 cap day one with 90% LTC and free TI? Me at 2:03 AM in Excel: adds 'lease-up by vibes' cell, model still #DIV/0! 😂🧮
ricklahkar
Oct 51 min read
When Excel Says 18% IRR But the Lender Reads 0.98x DSCR
Me underwriting at 1am: 'Pro forma stabilizes in month 3.' Excel: 18% IRR Lender: 'Send T-12, T-3, rent roll, and your will to live.' Credit Committee after comps: 'We re-traded your cap rate to vibes.' 😬 Model v47: DSCR jumps from 1.25x to 0.98x like it's a TikTok dance 📉
ricklahkar
Oct 41 min read
My Excel Said 6 Cap, IC Heard Fairy Tale
Broker: LOI accepted—turnkey, light lift, day-1 cash flow Lender: Neat, please send T-12, rent roll, Argus, Phase I, ALTA, estoppels, and DSCR baby photos Client: Can we close Friday if we pivot to condo-hotel, add mezz, and keep the rate fixed at vibes? Me opening Excel: 🧮 Model says 1.25x—after one tiny rent concession, IC says myth; my sanity says bye 😬
ricklahkar
Oct 21 min read
Underwriting At 1AM vs Seller Email At 8AM
Me at 1:12am underwriting: DSCR 1.36, T12 tied out, vibe immaculate 8:00am Seller: taxes reset, HVAC is “vintage”, anchor wants 6 months free Lender: need a “final-final” model with +50 bps stress and no TI/LCs 😵💫 Excel: not responding; cap rate widens; my promote evaporates 🪦
ricklahkar
Sep 301 min read
Light Value-Add, Heavy Therapy: Underwriting vs Reality in CRE
Broker: 'It's a light value-add' My model at 2am: 47 tabs, 18 circular refs, DSCR 1.19 and vibes 😵 Lender: 'Send the T12 and rent roll' — Excel: auto-saves, corrupts, restarts Seller: 'Here’s our 2019 pro forma' — Me: 'Cool, I underwrote the Tooth Fairy too'
ricklahkar
Sep 291 min read
Underwriting vs Reality: VLOOKUP Says 1.30x, Lender Says “Cute”
Broker: Model shows 1.30x DSCR Lender: After T-12 scrubs, 3% mgmt, reserves… it’s 0.99x Excel: Circular ref; VLOOKUP pulled proforma not actuals Me: Renaming ‘FINAL_v12’ to ‘pls_work’ and marking TI/LC as “future me” 🧮😬
ricklahkar
Sep 281 min read
When Your DSCR Is 1.34 And Excel Says New Phone, Who Dis?
Broker: 'Pro forma is conservative' Excel: =IF(MAGIC,TRUE,FALSE) - 47 hardcodes, 2 circulars, 1 #DIV/0! 🤡 Lender: 'Send T-12, rent roll, estoppels, and a DSCR > 1.35 after TI/LC by COB' Me at 1:58am: arguing with the Exit Cap while INDEX/MATCH gaslights my OM 🙏
ricklahkar
Sep 271 min read
Cap Rate Catfish: Expectation vs Lender Reality
Broker: DSCR pencils at 1.31 on stabilized NOI Lender: Cute—send T-12, estoppels, and a time machine Excel: Circular reference detected; your cap rate has left the chat 😵💫 Client: Thought we were at 5.25%... why is the term sheet 7.1%? Me: Roof report, TI/LC bomb, and a surprise Starbucks drive-thru easement ☕
ricklahkar
Sep 271 min read
Broker Math vs Lender Math: The Excel Cage Match
Broker: Pro forma shows 10% rent growth, easy Lender: Cool—send 3 years where unicorns paid above market, plus SNDA/estoppels Me at 2am in Excel: hiding columns, circular refs on, praying DSCR rounds UP 🙏 Client: Why's the rate higher? Market: Your T-12 reads like a true-crime podcast 📉
ricklahkar
Sep 161 min read
bottom of page
.png)