Skip to content
×
PRO
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
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x

IRR Spreadsheet Example

10.9 KB

File Size

1.5K

Downloads

N/A

Rating

From a blog post: "Let's say I want to model an empty apartment building that I'm rehabbing over the course of a couple years. I purchase it for $200K, and I have to immediately (over the first two months) put in $100K to start getting it rented. In the first twelve months after rehab, my model indicates a monthly cash-flow of $2500/month. Then, after twelve months of cash-flow, I plan to sink another $100K into more renovations (which takes 2 more months), and for the next twelve months, my model indicates that I can expect a cash-flow of $6000/month. At this point, I plan to sell the building for $500K. Given that example, I take my monthly cash flows projected by my two models, and augment them based on my purchase/sale/rehab expenses, and run an IRR to get my expected return (in this case, about 25%)."

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