Skip to content
Learn
Get Started
How To Manage Your Rental Property Real Estate Syndications
SMARTER Phases
Strategy Market Acquisition Rehab/Rent Tracking Exit Repeat
Resources & Media
Resource Hub Webinars BPCON2024 Podcasts Pro-Exclusive Videos PRO Books Blog Guides Self-Guided Bootcamps Interactive Bootcamps
BPCON2024 Is Heading to Cancun October 6-8
This is your chance to learn from the best, network with the best, and become one of the best in the game.
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
Build Your Team Tenant Screening Property Management Lease Agreement Packages PRO RentRedi PRO Insurance Pro Partners PRO
Find Deals
Find Markets Find Deals PRO Real Estate Syndications Off-Market Deal Finding PRO Community Listings Find Foreclosures
Market Finder
Pinpoint the best real estate market for your specific goals with expert recommendations and real-time data on appreciation, affordability, rent to price ratio, and more.
Build Your Team
Suggested Vendors
Find an Agent Find a Lender Find a Property Manager Find a Tax & Accounting Pro Find a Financial Planner
Vendors & Partners
Build Your Team
Search
Members Businesses Classifieds
Events & Meetups
BPCON2024 Local Meetups
Agent Finder
Match with an investor-friendly agent who can help you find, analyze, and close your next deal.
Lender Finder
Get the best funding for your strategy. Find and compare investor-friendly lenders.
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 PRO
Events & Networking
Events & Meetups Classifieds
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
My First Big-Time Deal Failed. Here’s Why I’m Happy About It.
I finally got my feet wet with a syndication deal, and it didn’t go so well.
Home Insurance Rates Set to Increase Another 6% This Year. Here’s What Investors Should Know.
Home insurance rates are set to climb another 6% this year, and that’s after a 20% gain over the past two years.
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.
Claim your piece of a $30B industry.
Build wealth with this insider's guide to glamping, campgrounds, and RV parks in the outdoor hospitality industry.
×
Pro Members Get Full Access
Succeed in real estate investing with proven toolkits that have helped thousands of aspiring and existing investors achieve financial freedom.
$0 TODAY
$32.50/month, billed annually after your 7-day trial.
Cancel anytime
Find the right properties and ace your analysis
Market Finder with key investor metrics for all US markets, plus a list of recommended markets.
Deal Finder with investor-focused filters and notifications for new properties
Unlimited access to 9+ rental analysis calculators and rent estimator tools
Off-market deal finding software from Invelo ($638 value)
Supercharge your network
Pro profile badge
Pro exclusive community forums and threads
Build your landlord command center
All-in-one property management software from RentRedi ($240 value)
Portfolio monitoring and accounting from Stessa
Lawyer-approved lease agreement packages for all 50-states ($4,950 value) *annual subscribers only
Shortcut the learning curve
Live Q&A sessions with experts
Webinar replay archive
50% off investing courses ($290 value)
Already a Pro Member? Sign in here
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
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 | over 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 | over 7 years ago  

Thanks and this is very handy.

Elbert D. | over 7 years ago