THE BEST SYSTEM TO RUN THE NUMBERS ON A RENTAL PROPERTY

[@jakeingledue]

I have read several real estate books, watched hours of KZbin videos, and listened to many podcast; none of which broke down the numbers like this video!!! Absolutely loved this video and am grateful you were willing to include the spreadsheet you use to analyze numbers!!! Keep up the good content!

[@ChandlerDavidSmith]

Jacob ingledue thank you so much! So glad you enjoyed it!

[@UnlockingsecretsoftheUniverse]

Check out Bigger Pockets

[@charlesg7926]

Yes, this was a really good video. I’ve watched bigger pockets, and Graham Stephan too (I like all these channels) but honestly I feel like this video here was most informative of all. It’s not as “fun”- it involves actual math, lol- but it’s the most useful video

[@vicdubc2309]

most investors ive talked to and I ask these questions arent transparent. This guy just answered all my questions and backed it with numbers. Thank you! best wishes to all!!

[@Matake2007]

I think this probably top 5 videos on real estate investing I’ve seen, and I’ve binged a lot. Thanks for putting in all the time and effort to share this information!

[@ChandlerDavidSmith]

KiinGDolo thank you so much! That really means a lot!

[@jessicachiang0127]

Finally not just "positive thinking" crap, but real numbers in real markets. Thank you so much for the spreadsheet!

[@95TurboSol]

Something magical just happened, I found a singe youtube channel that answered all my questions about rental investments in 4 videos. Thanks for the straight to the point style, wow

[@thomassiswick8963]

Hard to find someone thats as honest with their numbers as this. Living in a similar area i can see that these numbers are completely reasonable. Thanks, the spreadsheet works great!

[@ChandlerDavidSmith]

Thomas Siswick thanks for watching! Glad you enjoyed it! Let me know how I can help!

[@johncody-newinvestments5187]

Came here because of meet kevin. Stayed/subscribed for the content quality.

[@ChandlerDavidSmith]

Johnathan Cody thanks so much! Means a lot!

[@DavidTheDave]

It's so easy to look at a prospective investment property through rose tinted glasses. This video and your spreadsheet are a great reality check that everyone should take.

[@ChandlerDavidSmith]

David Shields thanks! That means a lot!

[@miavnavarro]

I know it’s a good video when I run it back to hear it again instead of have to skip forward through some bullshit! Thanks for the info man!

[@ChandlerDavidSmith]

Mia Navarro that’s awesome! Thank you so much! I’m glad you enjoyed it!

[@RajveerSingh-bg2xz]

0:23 absolutely correct no one is such honest

[@GreenspudTrades]

This is a great video for anyone who wants to get into this business! Your spreadsheet also serves as a good checklist for things to consider. I've done an analysis like this a few years ago, thinking about renting vs selling a house I was moving out of. I came to the conclusion that for just one house, the stress and uncertainty outweighed the benefit of a couple of thousands of dollars in profit per year assuming everything goes to plan. One thing I see don't see discussed on channels like this or Kevin's is how the margins are so tight that it incentivizes very cheap, low quality materials to be used in any repairs or upgrades. This is especially true if you've got mortgage payments on the property. That old home of mine had some nice flooring and hardware, and if it got run down by the renters the margins I was making would force me to replace any wear and tear with something not as nice as it was originally. I've seen this happen to other homes in the same neighborhood that turned into rentals. This is why HOA's don't like rental properties in their neighborhood.

[@paytonsmith856]

Just downloaded the free spreadsheet! This makes it all seem less intimidating to me when it's all broken down. Thanks!

[@ChandlerDavidSmith]

Payton Smith thank you!

[@Faisal0729]

How did you download it? When I click on the link it takes me too the main page.

[@craigrider2116]

This is probably the most succinct and clear breakdowns of a property I’ve seen! Thanks for sharing this Chandler!

[@ChandlerDavidSmith]

Craig Rider thank you! Thank you for watching!

[@RT710.]

You and Marko-WBF are the real deal! Don’t change dude, you’re making the world a better place

[@ChandlerDavidSmith]

Ryno Throwton thanks so much man! That really means a lot!

[@shinwonmoon6803]

I found your KZbin channel through MeetKevin. Great content and killer spreadsheet!

[@ChandlerDavidSmith]

Shinwon Moon thanks so much! Kevin is the man! Thanks for watching and commenting!

[@butterflyj685]

Me too!

[@ChandlerDavidSmith]

Butterfly J thank you!!

[@jfrealestate201]

This video is great! Thank you for being very transparent and Going over all of the details. I have never seen a video quite like this on estate investing. No glamour, no bells and whistles just analyzing. !

[@thediceflayer7959]

Awesome video, Chandler! It's good to see people breaking down affordable real estate investing with real numbers, not hiding anything. Keep it up!

[@ChandlerDavidSmith]

Till do! Thanks so much!

[@graysonstidham5412]

Appreciate the candor and honesty of your channel. No need to change, man!

[@sjenkauski5235]

So I have to buy the corse for the spreadsheet?

[@infocortebella7542]

Great job Chandler. Appreciate your straight forward and clear explanation. Lot of “Guru’s” on the web with all different schticks. I appreciate your approach. You aren’t selling anything, which is truly a relief. Thank you.

[@justinarnold84]

Really like the video content. Have watched several of your videos now and my only advice is to watch it at 125% playback speed! Not a knock on you at all just helped me stay engaged better

[@thedetailedreview8264]

The spreadsheet was not found on your website, just a course to purchase. Does one need to purchase the course to get access to the spreadsheet? You did not state that in the video.

[@willhumbleg8190]

Nice video Chandler. I feel more confident and purchasing my first property. I don't know why it is so scary for me even with VA benefits hopefully with my newly found grit lol shall be on the move

[@JubileeGiggles]

This channel actually seems pretty legit and full of information compared to a lot of the hot garbage out there

[@user-ym7kx8je6o]

Chandler! Could you do a video on running the numbers on an apartment buildingv

[@jonasbaas]

Great content and thank you for the free breakdown. That's why you're winning sir.

[@ChandlerDavidSmith]

Jonas Baas thank you! Glad to help!

[@kazi8026]

I just stumbled upon this video and I just want to say thank you so much for doing this!!! I can't wait to use this to run my numbers as I am getting ready to buy my first rental property. Cheers, mate!

[@ChandlerDavidSmith]

Kazi Islam thank you! So glad that you like it!

[@kierrawinston2638]

Is the insurance number per month or annually?

[@adammeyer9304]

i have the same question

[@newhebrewrib]

Chandler, you are truly the BEST!!!!!! I thank you from the bottom of my heart!!!

[@moviecook7717]

Excellent video and spreadsheet! Thanks for sharing. Look forward to more great content.

[@ChandlerDavidSmith]

moviecook thank you so much! Will do!

[@michigan_616]

Just downloaded! Can't wait to put it to the test!

[@frenchyalicea649]

Honestly, I prefer this vid over watching Kevin talking smack about cordone or clickbaiting etc. Great content Chandler!

[@ChandlerDavidSmith]

Frenchy Alicea thanks man! Means a lot!

[@frenchyalicea649]

@@ChandlerDavidSmith I invest in real estate as well, one of my sweetest deals generate 25% and was a total find. I'll be checking out your vids, keep it up.

[@ChandlerDavidSmith]

Frenchy Alicea congrats man! That’s awesome! Sounds good! Thanks!

[@cosmic_pamf7141]

Hey I just started watching your videos and I wanna say I’m impressed by your honesty. I am currently 20 years old and would like to start investing in real estate I would like to know when exactly should I hire a property management team. Also how do you deal with bad tenants.

[@TheBallin24k]

hey chandler awesome work, can you do one for condos?

[@cihatecicek]

Thank you .. from Turkey .. of course I have to work with local currency things are more diffucult ... ı have to guess USD values in future to have excel sheet to work :) will find out if investing for rent is a good deal overseas or not and let you know when I work it out .. I made lot of projections in the past for USD investments in Turkey so hopefully it works here as well .. All the best

[@ChandlerDavidSmith]

Cihat Cicek best of luck! Glad to help!

[@IAbebe-ed6bw]

This is great! I randomly came across your channel and have subscribed! I truly APPRECIATE all the information you're providing, including the free spreadsheet! I want to start investing in real estate, so I am soaking up information. I plan to watch all your videos. Thank you!!

[@dj1tay]

Amazing content, truly impressed by the transparency.

[@ChandlerDavidSmith]

Wayland Sejour thank you! Glad you enjoyed it! Thanks for watching and commenting!

[@akadhing129]

This is honestly amazing.

[@ChandlerDavidSmith]

addiedas-Adrien Salvador thanks so much! I’m happy you enjoyed it!

[@sophieyulinluo3567]

I liked the video and subscribed, looking forward for other great stuff :)

[@daryadorofeeva234]

Glad to have found you now before buying! Thank you 😇

[@tylermcginniskin3199]

Those numbers seem ridiculous in the Australian market, but bloody hell thats a cracking spready Cheers mate 👍🏼

[@sergioblanco4504]

I don’t see the amount for repairs to make it ready included in the expenses. Assuming you get a loan for this amount, where would you add this expense? Great worksheet, thank you!

[@darkice241]

Wow, thank you so much to share your knowledge & experience like this, super cool!

[@ChandlerDavidSmith]

Thank you!

[@UnitFan101]

Chandler! Using your excel sheet now...are the insurance and taxes amounts per year or per month? Thanks!

[@ChandlerDavidSmith]

Yearly

[@UnitFan101]

@@ChandlerDavidSmith thank you!

[@paifictower604]

Love this! Very easy to understand and Straight forward

[@sameermohammed7653]

CHANDLER if I bought a house I should rent it out first then put it for sail right I'm 16 years old and I'm trying to get as much info about investing real estate.

[@agtj9019]

Are you using this method for the brrrr method as well?

[@plexer09]

I am currently in a deal and this has helped me so much with my confidence. This was exactly what I needed. Thank you so much for this. L&S'd.

[@Sehvan.]

Get the app: DealCheck it’s way better

[@ericvann4620]

Like your video great content but wish you could make your spreadsheet bigger so I see it when your going over it. It's hard to see when watching with a phone.

[@jimross2101]

Not sure I agree that purchasing rentals with cash is so bad. There are several good reasons to own free-and-clear. For one thing, if you experience a number of vacancies, the mortgage(s) may be tough to pay while you are doing your reno with no/little cash flow. And one bad eviction can take the entire profits of a rental for the year. It really depends on how many additional financial resources you have and your personal risk tolerance - especially in the early phases of building your portfolio.

[@kenchu2752]

Very informative! Thanks for breaking this down, Chandler. Had to subscribe after watching this.

[@Peterandtheend]

I'm curious about the raising of rents. I totally understand the business side of that, but how do you navigate the ethical issues around that? I want to start getting into this but I'm concerned about that.

[@WorkersComp]

I like your spreadsheet. My one question in using it. To determine the net operating income (NOI) your spreadsheet calculates it AFTER subtracting the annual taxes (i.e. NOI is an after-tax figure). This results in a much lower cash-on-cash. Is this the general way of calculating NOI or should it exclude the annual taxes (i.e. in that case it would be 0, NOI is a before-tax figure) such that it would result in a higher CoC. Thoughts?

[@irone7050]

Based on your scenario, the hard part is looking for tenant willing to pay 4 times your mortgage which is ridiculous imo lol

[@reacting_to_stuff_]

Agree, he’s bumping up rents like crazy forcing these poor ppl to move iut

[@AKINGSNY]

Chandler you are the goat

[@ChandlerDavidSmith]

Haha thank you!

[@Pharmaquatics]

when i run the same numbers between the sheet and the app, it doesn't produce the same C on C...

[@teddycastro5224]

Love this video , Great job Chandler.

[@perpetualdividends6719]

I gotta move. Multi Fams are being listed at 3.5% cap rates hour outside of Vancouver. Feel like Id be better off finding a fund that invests in markets like yours..

[@thaddeus1519]

Are those taxes and insurance for the month or for the year?

[@junkman2758]

The house with nightmare tenants? Another great video thank you.

[@Sara-kp5ox]

This is a game changer for me. Thank you!

[@ikeepsitreel]

Excellent video,...super high yield!

[@hamzeroofthesouth1749]

Hi Chandler. Thanks for the video. I am filling out the sheet and I have a question. Are the numbers for Insurance and Taxes annually or monthly?

[@MeghanDonnellyIPY]

This was super helpful, can't wait to check out the app and the spreadsheet. Thank you so much.

[@therealtimray]

Awesome! Tons of value

[@ChandlerDavidSmith]

Tim Bearden thank you! Glad you liked it!

[@throbbed5644]

R the percentages mentioned in the chart coming from projected income. I'm confused. Lol I'm new to real estate investing.

[@kylenigl4477]

Another great video. Thank you.

[@perfectpaddles]

New here and can’t find where the spreadsheet is available for download. I found the course but no spreadsheet. Curious to run numbers first to see if this is even possible in my area. Can you send me the link please?

[@miximum1]

Thanks Chandler. Appreciate it!

[@zackbee874]

Great videos, great explanations, and great attitude! Btw, who’s the 1 person that goes through and dislikes your videos? Haters gonna hate.. smh

[@ChandlerDavidSmith]

Zack Bee thanks so much! And ya! Hahaha wish I knew who that gypsy was!!

[@InefficientOdds]

If you're buying a 4plex with an FHA loan, do you include the potential 4th rent when running these numbers even though you'd be living in 1 unit? The C on C return is negative with only 3 units rented out, but cost of living wise is much lower still than renting in my area. How do you personally take this into account? Thank you very much for the informative breakdown!

[@wytas20]

Where does the $7,120 amount come from? and how do the %'s next to them change the numbers?

[@TheBallin24k]

now that i think about it im very confused is the expenses monthly or yearly

[@danielmills2268]

Hey Chandler, I love the spreadsheet but one thing is confusing. It seems that income is monthly, but the expenses are yearly, right? So the number I put in in the rents cell is monthly rent, but insurance would be the yearly payment?

[@ChandlerDavidSmith]

Correct. Sorry if that’s confusing!

[@johnf.hebert1409]

@@ChandlerDavidSmith so that makes cash flow yearly.

[@ChandlerDavidSmith]

John F. Hebert yes

[@Cfomodz]

Likes, subscribed, and downloaded :) Super excited to learn!

[@ChandlerDavidSmith]

CfomodzGaming thanks! Glad you enjoyed it!

[@emmanuelsurf]

Great stuff! Thank you

[@esmiley3]

It all makes perfect sense! Thank you for that.

[@alexsmith2345]

This is awesome man!

[@ChandlerDavidSmith]

Alex Smith thanks so much!

[@rainbowdurag6826]

I understand running the numbers, the problem I'm having is location... There's plenty of houses with great numbers in the hoods of Milwaukee, but that comes with obvious problems and I know I don't want to own those properties, but how do I put dollar values on locations? How do I account for poor crime rate when evaluating whether or not a property will be profitable? Any help is greatly appreciated.

[@believeimages6034]

Real estate investing seems like a full time endeavor. If you want a deal you basically have to buy in a low income area which increases risk or you have to buy and flip a place which cannot be done with a full time job unless you work in the construction business. Just my experience after trying to find a place to buy rent out for the last 5 years.

[@youngceoclark8853]

I love your channel!!!!

[@ChandlerDavidSmith]

YOUNG CEO CLARK thanks man!

[@bhupindersingh-lh3qk]

Real teacher

[@ChandlerDavidSmith]

Thank you!

[@believeimages6034]

Can you give me tips on how to find a turn key property with a 5-6 percent cap rate? My full time job makes it impossible toa manage a flip or big reno

[@dyamigadiel5649]

Is zillow accurate on insurance and utilities?

[@itsallgoodbro9080]

Great video

[@ChandlerDavidSmith]

Bearded Mutt thanks so much!

[@thatcoolkidjoey]

Who do you go through for your home insurance or who do you recommend

[@ChandlerDavidSmith]

thatcoolkidjoey I use a guy a farm bureau. He is and active real estate investor. I suggest finding an agent who invests in your area

[@cvratny]

@@ChandlerDavidSmith I agree with the concern. Insurance makes or breaks most of the deals I analyze for CoC. Most YT video glance over this. I think it should be emphasized much more by everyone provided REI content.

[@madalynsmith6487]

Great video!

[@ChandlerDavidSmith]

Madalyn Smith thank you! Thanks for watching!

[@nosillafarooq]

Can you elaborate further on the 10% down packages? And how to find banks who do that? Thank you

[@ChandlerDavidSmith]

Umar Farooq those options are always with smaller credit unions in your area. I would go and connect with a couple of those credit unions and see what they have to offer.

[@nosillafarooq]

Chandler David Smith Thank you! Would it be a portfolio loan? And I’m guessing non-commercial, correct?

[@ChandlerDavidSmith]

Umar Farooq it would be a personal loan. Not commercial, correct.

[@nosillafarooq]

Chandler David Smith Thank you for the quick responses! Best of luck to your continued success!

[@ChandlerDavidSmith]

Umar Farooq thank you! You too!

[@miguelteran-raful2718]

Is there a website to find vacancy rate?

[@brandotex]

This is fantastic, thanks so much.

[@gtcam723]

Here by accident. But this is cool. As I’m getting set up for my next place.

[@danwaskey4489]

Awesome content

[@ChandlerDavidSmith]

Dan Waskey thank you!

[@janieornelas108]

Hi Chandler, Thanx for sharing, great content. Haven’t invested yet but plan to very soon. What is debt service? How did you calculate a cash flow of 6449.

[@lionheart93]

I think it is time for a correction in the housing market or thoughts?

[@blessonbiju59]

How do you get the closing costs covered by other people , are they solely your costs ?

[@MeleeMotors]

Please respond, I am very curious, and need to know in the expenses area do you put the month expenses or yearly expenses? Thanks

[@jonathankangasoja8148]

I know you posted this 4 years ago but i stumbled across this now. i just have one question and that is if the c on c return and the the ROI is monthly, yearly or life time based. would love to see a comment:)

[@kingsfansneak1886]

I live in California, I am thinking about buying a rental out of this state due to the laws here, where would you suggest that I buy?

[@howo357]

What lender are you using chandler? The interest rate is exceptional low for a non owner occupied.

[@raulfernandezjr5295]

I dont understand the vacancy formula if you have the properties rented? Can you please elaborate thanks!

[@ChandlerDavidSmith]

Raul Fernandez Jr plan for the worse! These are not real numbers I plan on but worse case scenarios so my numbers are conservative