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...

[Account Closed]

@Jaysen Medhurst Thanks a lot for the feedback. I've made these adjustments to my spreadsheet.

I'm currently looking at property's in the Central Connecticut area i.e. New Britain, Middletown, East Hartford etc.

Again, I'm relativity new to RE and am open to suggestions.