Commercial loan sizing calculator - is this helpful to anyone?
You may remember me as the Quiz guy from some weeks ago. It was fun to see a lot of members here take our real estate finance quiz!

Another "internal" thing that I'd like to potentially make available more broadly, but first I wanted to check in with this awesome community to see if this adds value for anyone. When sizing up a potential acquisition loan or refinance, our team uses this quick loan sizing analysis tool to estimate whether someone's loan request is even in the ballpark of reality, before diving into more tedious NOI underwriting: [https://docs.google.com/spreadsheets/d/1NXIOfL7r5yUrXH8ep2MKcw00BKgIdWxF2M9ysuby1pA/edit#gid=0](https://docs.google.com/spreadsheets/d/1NXIOfL7r5yUrXH8ep2MKcw00BKgIdWxF2M9ysuby1pA/edit#gid=0)

I just added a quick "Instructions" tab to make it more obvious how to use the tool.

Here's the question: if this was prettied up and turned into a clean web-based tool, or maybe a browser extension analyzing the current property sales listing webpage you are on (Loopnet, CREXi, etc), would it be useful to you?
[{"id": "fggnzq9", "text": "Good start and definitely helpful for some investors.\n\nMight want to add some logic to the max DSCR. No bank is going to finance 90% LTC, regardless of DSCR.", "replies": [{"id": "fggrx8n", "text": "It highlights the lowest of the three measures (DSCR, Debt Yield, LTV) so that any one of them can constrain your loan size. I'll add more clear wording for that in the instructions.\n\nEdit: I deleted some of the other calculation cells that were confusing. Should be more clear now. Less is more.", "replies": [], "depth": 2}, {"id": "fgguxc0", "text": "Not a bank per se, but there are definitely some debt funds out there that would go up to 90% LTC", "replies": [{"id": "fghn3jj", "text": "Any idea what pricing looks like at that high leverage?", "replies": [{"id": "fgifx8n", "text": "I've seen L+450", "replies": [{"id": "fgifzxy", "text": "Is that the blended rate of a mezz and a senior loan or just the rate on a mezz loan?", "replies": [{"id": "fgig23u", "text": "That's the senior loan, no mezz piece. In my experience, mezz runs north of 12%.", "replies": [{"id": "fgigwex", "text": "Ok.  The mezz that I\u2019ve seen in the 75-85% LTV range is closer to L+400 to L+600", "replies": [], "depth": 7}], "depth": 6}], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "fggoowz", "text": "Would be interesting to know interest rate sensitivity vis a vis loan proceeds; i.e. what is the impact to proceeds should rates change", "replies": [{"id": "fghnhyt", "text": "Rates being low definitely allows you to make a justification for higher proceeds.  You probably need to buy a cap to make sure you keep the interest rate low through the tenor of the loan.", "replies": [], "depth": 2}, {"id": "fgih0qg", "text": "agree, especially with rates changing quickly. should be relatively easy to add a sensitivity analysis to this. I'd probably make the table around changes in loan amount and NOI (since this is a quick high level analysis, youd assume NOI will end up changing)", "replies": [], "depth": 2}], "depth": 1}, {"id": "fgi0e6r", "text": "In my opinion, you should spend more time looking at value. Do you have other quick value indexes you can look at? A market cap rate makes assumptions about the quality and quantity of income, but those might not apply to your property.\n\nHow about a gross income multiplier? Or land plus depreciated cost? Or what\u2019s being paid for similar properties?", "replies": [], "depth": 1}, {"id": "fgk1867", "text": "Is this supposed to be downloadable?", "replies": [{"id": "fgkraf0", "text": "Sure, if you'd like to download it, press File -&gt; Download.", "replies": [{"id": "fglc7rd", "text": "Not seeing \u201cfile.\u201dI would like to try it, but what you have is not downloadable.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "fgkaaww", "text": "Your spreadsheet is what\u2019s described as \u201cpaper napkin analysis\u201d. It\u2019s wayyyyyy to basic to be marketable.", "replies": [{"id": "fgkrcht", "text": "You'd be surprised how many investors do less analysis than this when it comes to thinking about financing strategy.", "replies": [{"id": "fgkxpss", "text": "I\u2019m a banker, so obviously I\u2019m not surprised the least bit.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}]