Skip to content
Learn
Get Started
Learn SMARTER Real Estate Investing Real Estate Syndications
SMARTER Phases
Strategy Market Acquisition Rehab/Rent Tracking Exit Repeat
Resources & Media
Interactive Bootcamps Self-Guided Bootcamps Pro-Exclusive Videos Events Webinars Podcasts Books Blog Resource Hub Guides
Summer Bootcamps Open for Enrollment
Pick your 8-week bootcamp: Short-Term Rentals, Small Multifamily, or Rookie?
Free Webinars
Real estate investors break down the basics, and share tips on how to get your next deal.
Tools
Calculators
Rental Property Fix And Flip BRRRR Wholesaling Mortgage Payment 70% Rule Airbnb Rent Estimator Rehab Estimator
Software & Services
Tenant Screening Property Management Lease Agreement Packages RentRedi Insurance Pro Partners
Find Deals
Real Estate Listings Find Foreclosures Real Estate Syndications Off-Market Deal Finding
Pro Membership
Get unlimited access to tools and resources that make it easier to find, analyze, and manage deals with confidence!
Build Your Team
Suggested Vendors
Find an Agent Find a Lender Find a Tax & Accounting Pro Find a Financial Planner Find a Property Manager
Vendors & Partners
Build Your Team
Search
Members Businesses Classifieds
Events & Meetups
BPCON2024 Local Meetups
Agent Finder
Investor-friendly agents who get the best deals done.
Lender Finder
Investor-friendly lenders who can get you the best funding for your strategy.
Forums
For You
Newest Trending Unanswered My Discussions Followed Discussions Followed Categories Followed Locations Followed People
General Real Estate
General Real Estate Investing Starting Out Deal Analysis Buying & Selling Business & Marketing Landlording Property Management Reviews & Feedback
Real Estate Strategies
House Hacking BRRRR Short-Term Rentals Mid-Term Rentals Multi-Family Fix & Flip Other Strategies
Finance & Financing
Lending Creative Finance Personal Finance Taxes & Legal Issues
News & Announcements
Official Site Announcements Market Trends & Data Real Estate News & Current Events Pro Exclusive Area
Events & Networking
Events & Meetups Classifieds Off Topic
Blog
General Real Estate
Real Estate News Market Trends Financing Landlording Tips Personal Finance Taxes Opinion
Top Strategies
BRRRR Short-Term Rentals Multifamily House Hacking Flipping
The Investor’s Guide to a Single-Family Rental Emergency Fund
As real estate investors, your emergency funds are a critical line of defense against unexpected costs. It prevents you from dipping into your budget to handle them. But what should you really use an emergency fund […]
Don’t Overlook This When Buying an Investment Property—Learn From My Mistake
Let’s get one thing straight: Real estate investing isn’t a get-rich-quick scheme. If you think you can just waltz in and start raking in cash without a solid game plan, you’re setting yourself up for a financial face-plant.
Store
All Books
Browse All Best Sellers New Books & Pre-Orders Bundle & Save Books for Beginners
Simplify your goals and find clarity for your investing
Dave Meyer's newest book gives a practical framework to craft and execute YOUR personalized real estate plan.
Save money and time with efficient property management
Make the most of your time and money as a DIY landlord. Pre-order your copy before April 25 for exclusive bonuses!
Welcome! Are you part of the community? Sign up now.
Sign Up
x
FilePlacePeter Albanese's FilesProperty Analysis

Property Analysis

XLSX

uploaded by Peter Albanese

29.6 KB

File Size

3.6K

Downloads

N/A

Rating

Spreadsheet used to analyze Cash On Cash return for a single family home, duplex or 4 plex with inputs for loan amortization, down payment and capital improvements.

Download File
Disclaimer: Safety of files uploaded to the BiggerPockets FilePlace cannot be guaranteed. Download at your own risk.
Rate this file
Pick a rating between 1 and 5 stars

Comments

Great worksheet!!! I have the same questions as Justin Dryden. Also, is it ok to manually input assumption changes next to each expense item, for example insurance and maintenance amounts, without messing up any of your formula calcs. Lastly, please double-check you formula for calculating vacancy.

Chad Sander | about 7 years ago  

First of all, love this worksheet. Thanks! My only question is under valuation; why did you include the debt service in the CAP rate, and use revenue less insurance and taxes instead of NOI for the CAP valuation?

Justin Dryden | about 7 years ago  

Thanks and this is very handy.

Elbert D. | over 7 years ago