Howdy @Anthony Heatley
I see no one has responded to your post. Let me say first that I do nothing but BRRRR deals currently. However, I do not use the BP calculator. I have a few issues with it. Here's what I see:
1. The information you provided for the HML is incorrect. The loan amount is $80,000. Not $82,195. The $2,195 in points is the fee you must pay up front and separate from the loan. Your Monthly P&I is really Interest only payments at $800 ($80,000 x 12% = $9,600 / 12 months) per month. Not the $821.95 you are showing.
2. Good to see you included all Closing costs (Acquisition, HML Points, and Refinance Closing Fees).
3. Holding costs is where many people mess up with their calculations. Holding costs can include (but not limited to) mortgage payments, insurance, taxes, utilities, HOA fees, etc., that occurs during the Rehab period and up until the property is fully rented. So your Holding costs ($3,127.60) is automatically transferred from the HML P&I payment and information you included in your Cash Flow analysis (insurance and taxes).
P&I $821.95 +
Insurance $70 +
Tax $150.58
= $1042.53 x 3 months Rehab
= $3,127.59
You did not include any utilities in your Rehab budget I’m sure. This area is where I have issues with this calculator.
4. According to my math you still have cash in the deal. This does not include the missing utilities during the Holding period.
Purchase price $52,000 +
Rehab estimate $28,000 +
Purchase Closing costs $4,600 +
HML Points $2,195 +
Refinance Closing Fees $3,000 +
Holding costs $3,127.59 =
$92,922.59 -
Refinance loan $91,000 =
$1,922.59 Cash remaining in the property
Again, my problem with this calculator!
5. Cash Flow analysis: Using the 50% Rule is a good start in your analysis. Because you don't know what you don't know. It is much better over estimating expenses than under. Unless you have detailed accurate data from the current owner. That being said here's my 2 cents on your individual expenses. I always use a minimum of 8.34% (one month rent) for Vacancy reserves. If the average vacancy rate for the area is 5% or less, great. You are covered. However, if you have a vacancy that ends up lasting a month (or longer) your cash flow disappears in a hurry. Remember, the money is in reserve. It is not actually spent unless you need it. Your CapEx and Repairs amounts are okay. I always initially start off with 10% CapEx. Once the property is under contract I have it inspected to determine the current condition and life expectancy of all major components and appliances. From that report and in coordination with my GC we decide what to include in the Rehab and what can be deferred. I then adjust my CapEx reserves requirement accordingly. You did not include Property Management as an expense. You should always include it as part of your analysis even if you plan to self manage. If you plan to grow your portfolio you may eventually want a PM Service. If you did not include it in your original analysis it will be difficult adding it later and remain positive cash flow.