Calculating Simple Daily Interest?

jldugger at gmail.com jldugger at gmail.com
Mon Jun 13 16:29:43 EDT 2011


I've got some student loans in repayment, and I'm trying to get
GNUCash to accurately model the principal interest split. According to
the DOED[1],
they use a Simple Daily interest formula, which calculates interest on
days between payments. Is there a way to represent that in a scheduled
transaction
template somehow? I scarcely understand ipmt() and ppmnt()...

Here's a schedule to give you an idea of how the split varies.
Month   Pmt        Principal    Interest

Jan'11  $81.38  $60.06  $21.32
Dec'10  $81.38  $61.33  $20.05
Nov'10  $81.38  $59.13  $22.25
Oct'10  $81.38  $60.41  $20.97
Sep'10  $81.38  $61.00  $20.38
Aug'10  $81.38  $58.07  $23.31

This has been annoying me for years, that my number for principal
remaining and the lender's number never agree. If anyone can help,
thanks a lot!

Justin

[1] http://studentaid.ed.gov/PORTALSWebApp/students/english/MonthlyInterestCalculation.jsp


More information about the gnucash-user mailing list