Duplex Deal Analysis Spreadsheet Help

[Account Closed]

Thank you in advance to anyone who provides help and insight.

I am relativity new the the real estate world and and hoping I can have some help determining the accuracy of the spreadsheet I have put together. The spreadsheet can be accessed in the link below. I decided to create a simple multifamily deal analysis spreadsheet in lieu of using the Bigger Pockets calculator in hopes to better understand how the "numbers" work.

The deal that is currently populated in to the spreadsheet is not real. My main concern right now is checking the accuracy of the spreadsheet and calculations. Any suggestions on how I can correct or improve this spreadsheet would be appreciated.

I am based out of CT and plan to purchase my first owner occupied duplex using a FHA or Freddie Mac HomeReady loan in the near future.

https://www.dropbox.com/scl/fi...

[Jaysen Medhurst]

Hi @Account Closed. Welcome to BP. What part of CT are you considering? Also, since you're house hacking you should run the numbers both as owner-occupied and after you move out.

I took a look at your spreadsheet. Here are my suggestions:

• Don't use a % of purchase price for your closing costs. It's way to inaccurate. No way you'd have $8k on a $160k purchase. Talk with local lenders to get a more realistic idea.
• Always include a budget for initial repairs. There's going to be something!
• I think it's better to use a formula for PMI. Your lender will tell you what percentage of the loan amount you'll be charged.
• 20% combined for Repairs and CapEx is high. I use 15% each, but do adjust based on the property.
• Always underwrite with Management, even if you plan to self-manage at first.
• Break out utilities. At the very least you'll have water/sewer. I use $30-40/unit/month.
• You will almost certainly have some expenses for lawn care and snow removal.
• Advertising will cost something. You can use your vacancy rate and the cost so posting to Zillow/Craigslist/etc. to figure that out.