Skip to content
Quick search links
Find an Agent Find a Lender Hard Money Lenders Podcast Books Columbus
Get Started
Resources & Media
Resource Hub Bookstore Blog Guides Pro-Exclusives PRO Podcasts Pro Partnerships Newsletter NEW
Events & Training
BPCON2026 Webinars Free Courses
Strategies
How to Manage Your Rental Property How to Operate a Short-Term Rental How to Passively Invest in Real Estate How to House Hack How Does the BRRRR Method Work How to Flip a House How to Invest in Commercial Real Estate How to Invest in Real Estate How to Invest in Multifamily Real Estate How to Build Wealth
Invest More Confidently
Join the real estate investing community that’s helped thousands of people achieve financial freedom.
The Podcast Investors Trust
No fluff. Just deals, strategies, and lessons from the front lines of today's market.
Pick Markets
Pick Markets
Market Finder PRO Picking a Market Workshop PRO Picking a Market Worksheet Top 100 Cash Flow Markets Market Insights - Sunbelt Region
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.
Pro membership
Get unlimited access to tools and resources that make it easier to find, analyze, and manage deals with confidence!
Find Deals
Find Deals
BiggerDeals Off-Market Deal finding PRO Real Estate Syndications Investor-Friendly Agents Find Foreclosures Community Listings (FSBO) Business Directory
Invelo - off market deals
Scale your portfolio with off-market deals.
Analyze Deals
Calculators
Rental Property Calculator PRO Rehab Estimator PRO Rent Estimator PRO BRRRR PRO Fix & Flip PRO Short-Term Rental PRO Sell vs. Keep PRO Landlord Insurance Calculator by Steadily All Calculators
Rental property calculator
Is it a good deal? Run your numbers like a pro with this simple yet powerful calculator.
Rent estimator
Understand how much rental income you can expect based on recent reports and data for your specific property.
Manage Properties
Manage Properties
Managing Properties 101 Find a Property Manager RentRedi Property Management Software PRO Baselane Automated Bookkeeping & Banking PRO Property Management Tools Ask a Management Question Finding Tenants Screening Tenants PRO Leases + Landlord Forms PRO Property Insurance Property Maintenance / Rehab PRO
Property management software
Manage tenants, tasks, and your entire portfolio with one simple tool.
Property manager finder
Find reliable property management partnerships that last.
Pricing
Plans & Pricing
Pro Membership Business Membership
Try PRO for 7 days completly free
Avoid mistakes and make informed decisions with Pro.
Grow your business
Promote your business on BiggerPockets and make quality connections with the right investors.
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
Store
All Books
Best Sellers Browse All New Books & Pre-Orders Bundle & Save Books for Beginners
Unlock hidden potential in every property and maximize returns
This is your creative breakthrough guide to escaping investment paralysis and unlocking hidden profit in any market.
Build a Cash-Flowing Glamping Business with High Equity Upside
Whether you're starting from scratch or expanding existing hospitality operations, learn the practical frameworks needed to capitalize on the growing demand for upscale outdoor experiences.
×
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
×
Try Pro Features for Free
Start your 7 day free trial. Pick markets, find deals, analyze and manage properties.
FilePlaceWendell De Guzman's FilesCorrected Cashflow Analyzer

Corrected Cashflow Analyzer

XLSX

uploaded by Wendell De Guzman

10.7 KB

File Size

2.1K

Downloads

N/A

Rating

This is the corrected cashflow analyzer. The old one calculates the cap rate incorrectly if the offer is not 100% cash.

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

This file will not download.

Wendy Branowitzer | over 8 years ago  

Thank you so much for this! I love the simplicity. As for the insurance, is this still a good guess (50* # units * 12 months)?

Alice K. | about 10 years ago  

Nice job, and thanks for the correction.

Brent Mattison | over 11 years ago