I wish BP removed that metric from its calculator.

So I was hoping people here could educate me.I'm trying to calculate the interest earned on a $100k loan over 15 years at 7%. 

Keep learning by reading books and using BiggerPockets calculators to analyze deals.

Either my calculations are wrong, or the numbers on Redfin are wrong ( I am very suspicious of the home insurance that they show on the website), or I am in the wrong market. 

I put some numbers below into this Rent or Sell calculator.https://www.narpm.org/members/resources/rent-vs-sell-calculator/ESTIMATES ON ROI (15 year time frame)at 5% Appreciation would profit $100K if SELL nowat 6% Appreciation would have $3,500K more if KEEP and sell after 15 yearsat 7% Appreciation would profit 122K if KEEP and sell after 15 years(Assuming a conservative 6% ROI on money invested from sale.)NOTE: The property appreciated 10% in the last year so I’m thinking 7% over the next 10-15 is reasonable.DETAILSSale Value: $520,000 (Best guess)Paid: $437,000Original Mortgage: $415,000Mortgage Balance: $380,000Interest: 3.375%Monthly mortgage: $2,899Mortgage Difference: $1064Annual Taxes, Insurance, HOA etc**: $20,345**$13,865 (Non Homestead tax) $4,680 (HOA) $1,800 (Landlord Insurance)Monthly Rental Charge $3,500*Appreciation 7%Years to Hold: 15More assumptions used in ROI Estimates Above90% occupancy,15% capital gains charge6% selling feeRate of return on gains if selling now instead 6%Annual maintenance 1%Annual rent increase 4%$3,500 is slightly aggressive. unlikely I could get more.Thanks in advance for any constructive thoughts and comments!!!!

This form is used to calculate the income: Rental income worksheet

So I was hoping people here could educate me.I'm trying to calculate the interest earned on a $100k loan over 15 years at 7%.

BiggerPockets also has a calculator to analyze deals, and I highly recommend you start this as soon as possible, even if you are not ready to buy.

I set a number in my mind that worked with my calculations and did not get it.

After using the calculator the offer price was around 260k.