Your ROI formula is wrong and perhaps that's why you are confused.

In my area, there is a formula based on the assessed value.

After all the formula of Operating Yield is NOI/Cost...

The formulas we use are below.ROI = (Income - DebtService - ManagementFee - Insurance - RETax - PeriodicFees) x (1 - StateIncomeTax) / ( DownPayment + ClosingCosts)Cash Flow = (Income - DebtService - ManagementFee - Insurance - RETax - PeriodicFees) x (1 - StateIncomeTax)Notes:There is no state income tax in Nevada but we include this variable (StateIncomeTax) for when we compare properties in states that do have a personal income tax.We do not include a constant for vacancy rate or maintenance when we compare properties.

The credit score is a formula that generally fits everyone, but there are situations where it is not perfect and messes up.

Is there a formula to do that?

If I designed the sheet and put all the formulas in it helped me understand how everything works, which makes me better even without the sheet.

Do you inspect all properties prior to determining a price or do you just do a quick visual combined with your seller interview and use a formula?

Here's the formula I use: Traffic>Conversion>economics.Thank you to Perry Marshall for distilling my 35+ years doing this into three words!

The ARV on that house is ~$160K so the bank way overpaid and my bid formula would be way under what the bank would probably look at.