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

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Private Lending & Conventional Mortgage Advice
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 7 years ago on . Most recent reply

User Stats

36
Posts
1
Votes
Jacob Stephen
  • New York, NY
1
Votes |
36
Posts

IRR of paying points to buy down rate on a loan = 26%??

Jacob Stephen
  • New York, NY
Posted

I am debating paying points to buy down rate on a loan.  The property is a multifamily investment which I intend to hold onto for 10+ years.

I am getting quoted 1 point to buy down the loan 25 basis points.

Lets say the base rate on a $100,000 30 year amortizing loan is 4%.  I can buy down rate to 3.75% for $1000.   (100,000 x 0.25%)

In Microsoft excel, I can calculate the monthly interest payment in each scenario (4% vs 3.75%) for the 360 periods(12 months x30 years) using the IPMT function.  

I can then calculate the difference in interest payment for each period. This translates into my monthly savings. I then use the IRR formula to calculate the internal rate of return on the $1000 upfront investment. Since the savings are monthly, I annualize the savings using (1+ Monthly IRR)^12 -1.

The number comes out to 26.69%!!! 

This seems like an insane return provided i hold onto the property.  Am I doing something wrong?  Are there other factors I'm missing?

Thanks

Loading replies...