Skip to content
×
PRO Members Get
Full Access
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime.
Level up your investing with Pro
Explore exclusive tools and resources to start, grow, or optimize your portfolio.
10+ investment analysis calculators
$1,000+/yr savings on landlord software
Lawyer-reviewed lease forms (annual only)
Unlimited access to the Forums

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Followed Discussions Followed Categories Followed People Followed Locations
Market Trends & Data
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
Market Trends & Data
Buying & Selling Real Estate
Out of State Investing
Real Estate News & Current Events
Real Estate Technology
Investor Mindset
General Info
BiggerPockets Exclusive PRO Area
PRO
General Real Estate Investing
BPCON
New Member Introductions
Questions About BiggerPockets & Official Site Announcements
Off Topic
Starting Out
Real Estate Success Stories
Real Estate Horror Stories
Real Estate Strategies
House Hacking
Commercial Real Estate Investing
BRRRR - Buy, Rehab, Rent, Refinance, Repeat
Innovative Strategies
Mobile Home Park Investing
Multi-Family and Apartment Investing
Land & New Construction
Wholesaling
Rehabbing & House Flipping
Short-Term & Vacation Rental Discussions presented by
Tax Liens & Mortgage Notes
Medium-Term Rentals
Buying & Selling Small Businesses
Outdoor Hospitality
Landlording & Rental Properties
General Landlording & Rental Properties
Managing Your Property
Marketing Your Property
Tenant Screening
First-Time Home Buyer
Real Estate Professionals
Mortgage Brokers & Lenders
Contractors
Real Estate Agent
Financial, Tax, & Legal
Creative Real Estate Financing presented by
Personal Finance
Insurance
Private Lending & Conventional Mortgage Advice
Tax, SDIRAs & Cost Segregation presented by
Foreclosures
1031 Exchanges presented by
Goals, Business Plans & Entities
Legal & Legislation
Real Estate Classifieds
Classifieds
Real Estate Events & Meetups
Reviews & Feedback
Ask About A Real Estate Company
Real Estate Deal Analysis & Advice
Guru, Book, & Course Reviews
Syndications & Passive Real Estate Investing

Updated about 1 year ago on . Most recent reply

Hunter Purnell's profile image
Hunter Purnell's profile image
Hunter Purnell
  • Real Estate Agent
  • from Wellington, FL
  • Member since Jan 30, 2019

User Stats

33
Posts
19
Votes
Hunter Purnell's profile image
Hunter Purnell's profile image
Hunter Purnell
  • Real Estate Agent
  • from Wellington, FL
  • Member since Jan 30, 2019
Hunter Purnell
  • Real Estate Agent
  • Wellington, FL
19
Votes |
33
Posts
Market Trends & Data

How to find the rental rate based on a NNN cap rate in EXCEL?

Hunter Purnell
  • Real Estate Agent
  • Wellington, FL
Posted

I'm having trouble figuring out how to do this in excel. I want to see what the rental rate would be for a NNN lease based on the CAP rate. I have multiple % from 9% to 5% and want to see what rental rate would bring each CAP rate. For example 9% = (x - op. exp.) / PP x = rental rate. I'm not sure if I need goal seek or it can be done with an equation.

1 Vote
Follow
3 Replies
Jump to Last Reply
Log In or Sign Up to Reply
Sort By:

Loading replies...