If you're happy with the spreadsheet that you created and if it's functioning as you expected it to, then there's no need to use a different tool. 

Our combined expertise and strategic approach enabled us to negotiate favorable terms, ensuring a successful whole-tailing transaction for Partner Driven.

@Leisy Bartumeut Partner up with a private investor, whether that be debt or equity partner, to finish the rehab and buy them out during the refinance part of the transactionYou need capital and someone needs return on their money, combine those two parts for a win-win 

I don't know your relationship with this renter either as I think that will dictate much of your next steps here..Since they left you (the homeowner) out of the process of replacing a key feature of the property's form and functionality, I think I would require them to pay for a 3rd party inspection to properly assess the install and make sure it's what you need.

Cap rate is the ratio of net operating income over the property value.It is not a function of the financing rate used to acquire a property.It is a good tool to compare various commercial assets just based on the cashflows those assets produce and the asking price or market value they command.For that reason there is no direct relationship between cap rates and interest rates.It is more of an indirect one.

I would see what is the price I would pay for both separately and combine that price and possibly go in a little lower.

I am willing to apprentice with a company, solo investor or any combination thereof.

Its a combination of art and science.

Use the Grammar and Spelling function.  

Personally, I wouldn't take a tenant so low functioning they don't have internet.