Rental Property calculator- Total profit if sold?

Rental Property calculator- Total profit if sold?

Gautier, MS · Member since 2016 · 8 posts · 7 votes

In an effort to get accustomed to the rental property calculator tool, I ran the analysis for 2 different properties.  The math makes sense for all of the calculations but the total profit if sold.  Since I couldn't get the numbers to make sense, I watched Brandon's youtube video (https://www.youtube.com/watch?v=xqVF-_hkhfk) introducing the total return feature and the article here (https://www.biggerpockets.com/renewsblog/2016/05/2...).  The article states the following:  

Total Profit if Sold: This is the profit you would make on the property if you sold it. It is computed by taking the After Repair Value in that given year, subtracting out all the sales expenses (the percentage you entered on the bottom of page 3), subtracting out the mortgage balance, subtracting out any money you put into the deal, and adding in all the combined cash flow since you purchased the property.

Even when I worked the calculations along with Brandon on the youtube video, the Total Profit if Sold value never equals the correct number.  I must be doing something wrong, so if anyone can shed some light on this I would appreciate it.  

2Reply
46 views

2 Replies

Jump to latestLatest
  • Investor · Vancouver, WA · Member since 2014 · 359 posts · 143 votes
    10y

    So in brandons video I ran the numbers for year 1 and it seems to work out for me.

    ARV - sales expences - total cash needed - loan balance + cash flow

    (121,200 X 90%) - 25,132.5 - 37,685.67 + 2,162.99 = 48,424.8

    Total return = 48,424.8/25,132.5 = 1.92 = 192 %

    Let me know If you have any questions

  • Gautier, MS · Member since 2016 · 8 posts · 7 votes
    10y

    @Austin Youmans thank you for the breakdown. I was making a very silly mistake. This is what I was doing:

    121,200 - (121,200 x 10%) - 25,132.5 - 37,685.67 + 2,162.99

    Makes a huge difference. I appreciate the help. 

Join the conversationCreate a free account to reply, vote on answers and follow this thread.