Hey @Keith Linne congrats on tying up a property which appears to have a good bit of upside to it! Here are a few of my thoughts after looking over your comments.
1. I noticed you calculated DSCR throughout the hold period, this is essential so great job focusing in on this. Make sure you also look at what DSCR would be if the debt were to be amortizing, not interest only. Most banks will underwrite a deal based on the amortizing DSCR regardless of whether or not the debt will have an interest only component. In general you want to make sure you hit a 1.25 DSCR on an amortizing basis.
The reason you want to make sure you are above that threshold is in case interest only is not an option when you go to refinance. While bridge lenders will go below 1.25, agency debt typically requires it, and it will also provide you some breathing room in case vacancy is higher than expected or your rent bumps do not pan out as expected.
2. I see that you have projected post renovated rents, however you can also factor in a rent growth projection depending on the market. This will give you a more accurate revenue projection as you hold the property over the next few years. You definitely want to be conservative, however if rent growth is more or less than expected, it will effect your loan proceeds when you go to refinance.
3. On the flip side, you will also want to add an expense escalator which accounts for inflation. For example 2% per year, to account for rising material and labor costs.
4. I'm sure you have already thought of this but make sure you budget Replacement Reserves on a per unit basis. The older the property the more reserves you will want to hold. For example if it is a 1970s property you may want to hold $300 a year in cash to account for unforeseen events.
5. Being that you are looking to add value here, you might also want to include an interest rate reserve (basically hold a couple of months of debt service in cash) in order meet the debt service in times of unexpected distress.
After factoring these things in, your current price you have under contract may still be sufficient for your personal return criteria, or you may have to revise your offer price downwards.
Let me know if you have any questions!