Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 54%
$32.50 /mo
$390 billed annualy
MONTHLY
$69 /mo
billed monthly
7 day free trial. Cancel anytime
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
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...