Results 1 to 7 of 7

Thread: TSP Loan Amortization Schedule

  1. #1

    Default TSP Loan Amortization Schedule

    Does anyone know the formula used by the TSP in order to generate a loan amortization schedule? I am trying to break down my payments to show the amount of principle and interest paid for each pay period. I've tried creating formulas in Excel and also tried several online calculators. The problem is that both resulted in a different payment amount per period and the total interest paid on the loan did not match up.


  2.  
  3. #2

    Default Re: TSP Loan Amortization Schedule

    Quote Originally Posted by blueroadster View Post
    Does anyone know the formula used by the TSP in order to generate a loan amortization schedule? I am trying to break down my payments to show the amount of principle and interest paid for each pay period. I've tried creating formulas in Excel and also tried several online calculators. The problem is that both resulted in a different payment amount per period and the total interest paid on the loan did not match up.
    Determining the monthly payment to account for interest requires a complicated formula shown below.A*is the monthly payment,*P*is the loan's initial amount,*i*is the monthly interest rate, and*n*is the total number of payments.

    Attachment 25682

    the problem is that *i* is determined monthly by blackrock after close consultation with jacob lew and ben bernanke, and *P* is actually the outstanding loan amount at the time you calculate the ream (reamorization), which you can do 26 pay periods per year. there is a reason they call it *ream*.

    the trick is to continue to ream while never actually reducing the principal, kind of like a perpetual annual deficit or a continuing resolution, which is really no resolution at all.

    word. secret to the financial world right there. live it learn it love it. and keep refinancing, that is how you make money.
    100g

  4.  
  5. #3

    Join Date
    Jan 2011
    Location
    Okinawa, Japan
    Posts
    1,457

    Default Re: TSP Loan Amortization Schedule

    Is the calculator on the tsp.gov site inaccurate or unreliable for some reason?

  6.  
  7. #4

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

    Default Re: TSP Loan Amortization Schedule

    Quote Originally Posted by Sensei View Post
    Is the calculator on the tsp.gov site inaccurate or unreliable for some reason?
    It doesn't show how it is amoritized. I think BR wants to see the breakdown. I think I saw a post somewhere that basically spread everything out equally, but will have to research later.
    THIS IS WHERE I WOULD PUT SOMETHING TO REPRESENT MY THINKING, BUT THEN THEY SHOW UP!
    Tracker =
    Check my position

  8.  
  9. #5

    Default Re: TSP Loan Amortization Schedule

    Quote Originally Posted by Sensei View Post
    Is the calculator on the tsp.gov site inaccurate or unreliable for some reason?
    I'm just not sure how the tsp.gov loan calculator actually works. For example:
    https://www.tsp.gov/planningtools/loan/loan.shtml

    TSP Loan Calculator Inputs:
    Loan Amount: $10,000
    Type: General Purpose
    Repay Loan Over: 5 Years and 0 Months
    Pay Schedule: Biweekly (Every 2 Weeks, 26 Times a Year)
    Interest Rate: 2.250%

    TSP Loan Calculator Results:
    Repayment Frequency: Biweekly
    Interest Rate: 2.250%
    Payment Amount: $82.00
    Number of Payments: 130
    Total Interest: $660.00
    Total Loan Cost: 10,660.00

    Free Loan Amortization Schedule and Calculator

    Loan Information:
    Loan Amount: $10,000
    Annual Interest Rate: 2.25%
    Term of Loan in Years: 5
    Payment Frequency: Biweekly
    Payment Type: End of Period

    Loan Results:
    Biweekly Payment: $81.36
    Rate (per period): 0.087%
    Number of Payments: 130
    Total Payments: $10,577.37
    Total Interest: $577.37

    As you can see, the resulting monthly payment and overall amount of interest paid on the loan is not the same; the TSP calculator result is a higher amount of interest charged.

  10.  
  11. #6

    Default Re: TSP Loan Amortization Schedule

    "As you can see, the resulting monthly payment and overall amount of interest paid on the loan is not the same; the TSP calculator result is a higher amount of interest charged. "

    If I remember correctly the last time I borrowed from my TSP account they rounded up to the next dollar. Shouldn't really matter since you are borrowing from yourself and repaying yourself.

  12.  
  13. #7

    Default Re: TSP Loan Amortization Schedule

    Quote Originally Posted by Scout333 View Post
    "As you can see, the resulting monthly payment and overall amount of interest paid on the loan is not the same; the TSP calculator result is a higher amount of interest charged. "

    If I remember correctly the last time I borrowed from my TSP account they rounded up to the next dollar. Shouldn't really matter since you are borrowing from yourself and repaying yourself.
    It makes sense how the TSP calculator would round up each payment to the next dollar, but doing so would actually increase the interest rate itself. Where this does not make sense is that for the TSP loan I took out several months, my biweekly payments were not rounded up to the next dollar. In any event, I was able to create an amortization schedule for my loan simply by slightly increasing to the interest percentage so the resulting biweekly payment matches what I'm actually paying.

  14.  

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
  •  
SPY (C Fund) (delayed)
TSP Loan Amortization Schedule
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
TSP Loan Amortization Schedule
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
TSP Loan Amortization Schedule
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
TSP Loan Amortization Schedule
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes