Skip to content

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

IRR Spreadsheet Example

10.9 KB

File Size

1.6K

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