Mortgage/Loan druid comments
Tim Wunder
tim@thewunders.org
Sat, 13 Jul 2002 16:06:33 -0400
On Saturday 13 July 2002 03:00 pm, Josh Sled wrote:
> On Sat, Jul 13, 2002 at 12:08:26PM -0400, Tim Wunder wrote:
<snip>
> | - It seems that the druid should calculate the payment amount based on
> | the input of the loan amount, the interest rate, and the term. Will it?
>
> Yes; see src/scm/fin.scm. :) The facility to hook these up to the template
> transaction credit/debit cells is there ... but a few more things need
> to be hooked up before it will work. But that's the idea. As for it
> displaying them in the druid... well, I think the formulae would be put
> into any "Amount:" entries, but perhaps there's room for an Amortization
> Table page... would this be useful?
>
Probably
<snip>
> | prompted for amounts for each individual field. A final calulated field
> | would then be the Total Payment amount, which can only be changed by
> | changing the Esrow amount, or the other editable fields in the Repayment
> | dialog (based on select options).
>
> There was talk about this earlier. While it will be true for a lot of
> people that the Repayment is just the sum of the other splits, a lot
> of people just pay something "Fixed" per month [perhaps something that's
> calculated and the fudged by their bank, but otherwise a set dollar
> amount]. So it will need to be edited in some cases by the user.
>
Hmmm, that brings to mind my current Home Equity line of credit...
It consists of 2 10-year phases, a borrowing phase and a payoff phase. During
the borrowing phase, the minimum monthly payment is calculated based on a 20
year term and is an interest-only payment. It is only during this phase that
I'm allowed to borrow against the loan. I can pay against principal, if I
want, but it's not part of the minimum payment as delineated by the bank on
my statements. Once the 10 year anniversary comes, the Payoff phase kicks in
and I can no longer borrow against that line of credit. The minimum payment
becomes a P&I calculation based on a 10 year term (still with a variable
rate).
I'm not sure how this can fit in with the Druid, but I figgerd I'd throw it at
you to see what you thought. I also don't know how many banks out there have
loans that are stuctured like that. So I can't comment on whether the ability
of gnucash to handle it would be important.
Regards,
Tim
<snip>