Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
General Landlording & Rental Properties
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated almost 5 years ago on . Most recent reply

User Stats

10
Posts
4
Votes

How did Dave Meyer figure the NOI?

Posted

https://www.youtube.com/watch?v=DHsbGR4zg5Q

If you watch this video and skip to about 11 minutes in. How in the world does he get the numbers for that NOI. Can someone please explain to me if this calculator is broken, or am I too new to real-estate. I've spent all night reading and watching videos on how you accurately calculate NOI and I can't find why his number is that

Most Popular Reply

User Stats

611
Posts
1,089
Votes
Tom Shallcross
  • Rental Property Investor
  • Chicago
1,089
Votes |
611
Posts
Tom Shallcross
  • Rental Property Investor
  • Chicago
Replied

 @Ifegwu Sampson Ifegwu - the calculator is spitting that out based off a 88k loan amount, 30yr amortization and rate of 4.25%.  Adjust any three of those data points and the PMNT amount will also adjust. 

If you want to create your own calculation you can create a table where you enter the loan amount (note that it's not the purchase price) rate and months of payment.  For the Monthly payment cell, the Excel calculation is =PMT(B2/1200,B3,B1).    B2 is the rate, B3 is the # of months and B1 is what you entered for loan amount. 

Loan Amount $100,000
Annual Rate 4.50%
Number of Payments 360
Monthly Payment ($279.66)

Loading replies...