BRRRR deal analysis help

[Farrukh Amini]

I'm looking to get into our first 5+ MFR deal and tried to create an excel sheet with all the info I gathered from other posts. None of the calculators in the file place were what I needed exactly. I have experience with 1-4 MFRs and how lending works, but this whole new commercial lending terms and requirements and Cap rates are a whole new game that I feel like I'm not too comfortable analyzing these deals.

So I tried to gather all of the info and metrics on one file to make it easier to read and understand it. I am looking for feedback from folks who've done this and are familiar with process and nuances. I'd like to know whether the items that I am including in the analysis are relevant and whether I'm missing anything crucial, and if my estimations are close to reality (like timelines to refi, cap rate, ARV, holding costs, other commercial loan requirements I'm missing, etc) Any feedback is appreciated.

Hard money rates at 8.35 and 1point amortized over 30

Refinance commercial loan: 30 yrs at 5% (am I able to get a commercial loan for 30 years?)