Newbie migration issues
Rod Engelsman
rodengelsman at ruraltel.net
Sat Jan 29 01:05:17 EST 2005
Thank you for your reply, Derek. Comments and f/u question at bottom.
Derek Atkins wrote:
>Rod Engelsman <rodengelsman at ruraltel.net> writes:
>
>
>
>>1. Setting up my wife's student loan. What numbers is the Loan Druid
>>expecting in various places? For instance, in the "Loan Information"
>>dialog, where it says "Amount", is that the amount borrowed or the
>>amount of the payment? Is it supposed to be positive or negative? And if
>>that is the amount of the payment, then where does this thing get the
>>amount of the principal from? No matter what combination of possible
>>entries I make to this thing it comes up with absurd amortization schedules.
>>
>>
>
>It's the original principal amount.
>
>
>
Then I'm still doing something screwed up. Here's the loan information:
It's a student loan that she started repaying last year. The first
payment was 20 Jan 2004. The payment amount is $30 for the first two
years, then increases to $80.37 for 116 months with a final payment of
$66.71 in 2015. I went to the Sallie Mae website and got the current
balance information. Our last payment was made on 19 Jan 2005 and the
balance owing at that point was $8183.47. So what I want to do is set it
up for the next 11 payments at $30 starting 20 Feb 2005.
I go into the Loan Druid. On the first screen I enter 8183.47 in the
"Amount" box. Loan account is "Liabilities:Loan:Student Loan". Interest
rate 3.125%. Type is "Fixed". Start date 2/20/2005. Length is 476 months
(calculated by the Financial Calculator). Months remaining says 476 as
well. Hit "Next".
Skip all the Mortgage options because they don't apply. Next screen
says: Name = Loan, Amount = pmt( 0.03125 / 12 : 476 : 8183.47 : 0 : 0 ).
Payment from, principal to, and Interest to is all correct. Repayment
frequency is monthly, start date 2/20/2005. Hit "Next".
This is where it gets weird. The Amortization Schedule looks like this:
Date Payment Principal Interest
2/20/2005 3190.80 1060.69 2131.11
3/20/2005 3190.80 1336.91 1854.89
4/20/2005 3190.80 1685.07 1506.74
.
.
.
11/20/2005 3190.80 8515.61 -5323.81
12/20/2005 3190.80 10733.20 -7541.42
1/20/2006 3190.80 13528.30 -10336.50
Obviously, this amortization schedule is way screwed up. So what did I
do wrong?
Rod
More information about the gnucash-user
mailing list