Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. 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