Page 4 of 6 FirstFirst ... 23456 LastLast
Results 37 to 48 of 65

Thread: TSP Loan Rate

  1. #37

    Default Re: TSP Loan Rate

    Quote Originally Posted by fabijo View Post
    I have no idea if anyone will really see this post buried in the G Fund thread, but here goes...

    Every once in a while, I check out the TSP Loan rate out of curiosity. I've used it in formulas to compare investments/loans in Excel. But a couple times, I've used the TSP Loan calculator on the TSP site to see how much the biweekly payments are. Every time, the payment they show is different than the payment I calculate in Excel. I can get it dead on when I use Excel to calculate mortgage payments, but it never goes right with the TSP Loan. I've searched and searched and I just can't quite figure out how it works.

    Here's an example:

    Currently, the TSP calculator (here) says the rate is 2.625%. I plug in $10,000, 5 years payed off biweekly (26 times a year).

    It comes up with 130 payments at $83.00 each, with a total in payments equaling $10,790 - an interest payment of $790 by the end.

    now in Excel...

    I must be doing something wrong in my formulas, but the only way to get the payment and total interest to match is to use a rate of 3.0586%

    I use the PMT formula in excel. The syntax of PMT is:

    PMT(rate, number of periods, present value, [future value], [type])

    future value and type are optional. I usually leave them out, but I've tried using them to no avail.

    For rate, I use the quoted rate divided by 26 (.02625/26)

    For the number of periods, I use 26 * years. In this case, it's 26 *5 = 130 payments. That matches up with TSP calculator.

    Present Value is $10,000 in this case.

    If I plug those numbers in, I get 130 payments of $82.12, with a total of payments equaling $10,675.60. That's $114.40 less than what the TSP site calculates. The only way I can make it equal is to plug in a percentage of 3.0586%

    I've tried online loan calculators and it is the same thing. I'm guessing the TSP must be doing some strange rate calculations, but I just can't figure it out. Has anyone else noticed this or do you see where I'm going wrong???
    FRTIB skimming off the top maybe?
    God bless the United States of America!

  2.  
  3. #38

    Join Date
    Feb 2007
    Location
    San Diego, CA
    Posts
    6,999

    Default Re: TSP Loan Rate

    Quote Originally Posted by fabijo View Post
    Thanks, Tom. I wonder what strange accounting method the TSP is using then. Maybe I'll have to call them to find out what they are doing.
    They round the payment amount.

    It is an estimator Your calculations are correct, but if you change the dollar amount to 9993 - 10123 the payment is $83.00

    You can't get an odd number (83.35) on the estimator!
    THIS IS WHERE I WOULD PUT SOMETHING TO REPRESENT MY THINKING, BUT THEN THEY SHOW UP!
    Tracker =
    Check my position

  4.  
  5. #39

    Default Re: TSP Loan Rate

    Quote Originally Posted by Frixxxx View Post
    They round the payment amount.

    It is an estimator Your calculations are correct, but if you change the dollar amount to 9993 - 10123 the payment is $83.00

    You can't get an odd number (83.35) on the estimator!
    I like my explanation better.
    God bless the United States of America!

  6.  
  7. #40

    Join Date
    Feb 2007
    Location
    San Diego, CA
    Posts
    6,999

    Default Re: TSP Loan Rate

    Quote Originally Posted by Viva La Migra View Post
    I like my explanation better.
    You'd be sounding like he who will not be named
    THIS IS WHERE I WOULD PUT SOMETHING TO REPRESENT MY THINKING, BUT THEN THEY SHOW UP!
    Tracker =
    Check my position

  8.  
  9. #41

    Default Re: TSP Loan Rate

    Quote Originally Posted by Frixxxx View Post
    They round the payment amount.

    It is an estimator Your calculations are correct, but if you change the dollar amount to 9993 - 10123 the payment is $83.00

    You can't get an odd number (83.35) on the estimator!
    They do this beyond just in the estimator. I've got a home loan I took out a couple years ago and their math did the same funny magic. I also just went and tried to see what would happen if I logged in and applied for a loan to see if the numbers would be right. They still came out with payments similar to the "estimator."

    Maybe they use tables instead of a formula, similar to tax tables. Now that's something I can see happening.

  10.  
  11. #42

    Join Date
    May 2010
    Location
    Vancouver, USA
    Posts
    1,648

    Default Re: TSP Loan Rate

    Quote Originally Posted by Frixxxx View Post
    You'd be sounding like he who will not be named
    LOL @@@hnold?

  12.  
  13. #43

    Join Date
    Apr 2005
    Posts
    14,689
    Blog Entries
    13

    Default Re: TSP Loan Rate

    Fabijo:

    When you take out a TSP loan, you are also charged a $50 fee for doing the loan.

    Add $50 to the amount you are financing, and see if that covers the difference.
    (p.s.- and you aren't going to get exactly 26 pay periods every year. Some years have an extra one. )

  14.  
  15. #44

    Join Date
    May 2010
    Location
    Vancouver, USA
    Posts
    1,648

    Default Re: TSP Loan Rate

    Quote Originally Posted by fabijo View Post
    They do this beyond just in the estimator. I've got a home loan I took out a couple years ago and their math did the same funny magic. I also just went and tried to see what would happen if I logged in and applied for a loan to see if the numbers would be right. They still came out with payments similar to the "estimator."

    Maybe they use tables instead of a formula, similar to tax tables. Now that's something I can see happening.
    did you take into account that the interest rate has changed?
    today it's 2.5%, when we got our loan in 2006 it was 4% I believe.
    -actually 3.5% I checked

  16.  
  17. #45

    Default Re: TSP Loan Rate

    Quote Originally Posted by James48843 View Post
    Fabijo:

    When you take out a TSP loan, you are also charged a $50 fee for doing the loan.

    Add $50 to the amount you are financing, and see if that covers the difference.
    (p.s.- and you aren't going to get exactly 26 pay periods every year. Some years have an extra one. )
    If you take out $10,000 the $50 comes out of that, so the amount financed is still $10,000.


  18.  
  19. #46

    Join Date
    Apr 2005
    Posts
    14,689
    Blog Entries
    13

    Default Re: TSP Loan Rate

    Quote Originally Posted by Viva La Migra View Post
    FRTIB skimming off the top maybe?
    Now THERE you go. That must be it.

  20.  
  21. #47

    Default Re: TSP Loan Rate

    Quote Originally Posted by crws View Post
    did you take into account that the interest rate has changed?
    today it's 2.5%, when we got our loan in 2006 it was 4% I believe.
    -actually 3.5% I checked
    Yes, I saw that. So for $10,000 at 2.5% on TSP site, it says $82.06 for 130 payments with total interest @ $666.67.

    Putting those numbers into standard loan payment formulas, you get $81.87 for 130 payments with interest @ $643.10

    ....

    When I got my loan out in 2008, the rate was 3.375% and they also gave me a different number than what is calculated using standard formulas.

    I'm really leaning toward them using some form of payment tables.

  22.  
  23. #48

    Join Date
    Feb 2007
    Location
    San Diego, CA
    Posts
    6,999

    Default Re: TSP Loan Rate

    Quote Originally Posted by crws View Post
    LOL @@@hnold?
    Someone from the board who no longer plays here! But nice guess!
    THIS IS WHERE I WOULD PUT SOMETHING TO REPRESENT MY THINKING, BUT THEN THEY SHOW UP!
    Tracker =
    Check my position

  24.  
Page 4 of 6 FirstFirst ... 23456 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
TSP Loan Rate
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
TSP Loan Rate
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
TSP Loan Rate
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
TSP Loan Rate
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes