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
Results (10,000+)
Brad E. Help calculating IRR including sale proceeds
13 January 2021 | 4 replies
This is a key assumption to my problem so if that is incorrect please let me know.The excel formula of course uses the syntax IRR(values, guess)For this example:- Row 1 will hold yearly cash flow for years 1-5.- Row 3 will hold sale proceeds- I will sell the property in year 5 So it will look like this:A1= 100 (cash outflow)B1= 10C1= 15D1= 15E1= 15E3 = 25 (proceeds from sale of asset)Here is the formula I am using to calculate this=IRR((A1:E1,E3))This will return a value but I am not sure if it is the correct way to calculate this because I am not sure how Excel is interpreting these flows with regard to timing.
Andrew Pakchoian Getting started and ready to hit the ground running!
26 October 2018 | 9 replies
Are you looking for turn key houses to rent, or distressed/ fixer-uppers to buy low, renovate and rent out. 
Matt Kalish Looking for Florida Keys realtors
26 August 2018 | 1 reply
I am interested in investing in the Florida Keys, particularly for short term rentals.
Christopher Short New Investor using VA Loan (Zero Down)
27 August 2018 | 18 replies
The key I got from you is that you bought and sold.  
Kevin Phu Cashflowing 2/1 SFR in Indianapolis
30 August 2018 | 7 replies
The two keys for success are: 1.
John Hamrin Financing your deals
23 August 2018 | 19 replies
Hi John, one of the key things in most deals is knowing your options to financing. 
James Freeman Bigger Pockets Ultimate Starter Guide, 2 noobie questions
30 August 2018 | 22 replies
@Kris Wong so the key to Austin is appreciation more than cash flow positive unless you are doing a sizable down payment?
Stefan Grossett Sothwest Jersey Potential
21 August 2018 | 0 replies
Hello BP,I am interested in a purchasing a turn key flip in Somerdale NJ does anyone have any knowledge on the area??
Jake Snavely BRRR - start with your own cash or private money?
24 September 2019 | 3 replies
I usually order the apapraisal they day after we close on the cash purchase when the job just requires some minor cosmetic fixes.The key here is creating forced appreciation.
Scott Trench Full-Time Investors: What Do You Do for Healthcare?
11 April 2019 | 13 replies
And that really is the key to managing one's health...prevention first!