Financial calculation

[Terry]

On Friday 07 January 2005 04:47, saher edris wrote:
> Suppose i'm processing the following lease transaction with the following
> input parameters :
>
> lease created date = Sep., 13 th 2004
>
> first payment date  = Nov., 30 th 2004
>
> * grace period is considered " accounted for " since lease creation date up
> to first payment date .
>
> p.v. " lease amount " =  6725 $
>
> no. of payments        = 72   months
>
> payment amount    = 118
>
> f.v.  "lease amount + interest" = 10436 $
>
> balloon amout = 1440
>
> no. of balloon payments = 6
>
> balloon payment = 240
>
> balloon first payment date = Oct.,30 th 2005
>
> CF = PF = monthly
>
> My question is .... in trying to find the value of  the " nominal rate " 
> ...does the existance of
>
> balloon payments affect the calculation of the " nominal rate "  ? and if
> it does please explain ?

Your numbers translate into the following parameters:

Present Value == pv = 6725

number of periods == n = 72 (months  == 6 years)

periodic payment == pmt = -118 (note that minus sign, since (I assume) this 
money is being paid out, then it is negative. If you neglect the minus sign, 
and try to compute an interest, you will get a calculation that never ends, 
i.e., it will oscillate between positive and negative values (and rather 
large values) for the interest rate. The calculation will never converge on a 
value. It cannot converge, since with a positive 'pmt' value you will have an 
'insoluble' problem - i.e., no solution.)

After this your scenario departs radically from the scenario that can be 
handled by the financial calculations I submitted to gnucash. You posit 6 
"balloon" payments of -240 (again negative) starting approximately 12 months 
(1 year) after the initial payment. This is in addition to the periodic 
payments made during the 6 years of the life of the transaction. 

There is no way to account for your "balloon" payments in the computations as 
I submitted them to gnucash. 

Now "balloon" payments as that term is "normally" handled by financial 
institutions (at least in the US) means a single payment made at the end or 
termination of the entire transaction, i.e, on the final payment and not 
during the life of the transaction.  

Thus,  a "balloon" payment as used by US financial institutions (and I am 
pretty sure as used world wide by financial institutions) would be a single 
payment of 1440 as the 73rd payment.

Thus, added to the above parameters you would have:

Future Value == fv = -1440.

With this value you now have four parameters (besides CF, PF, discrete or 
continous, and beginning or end of period payments - assuming the typical 
values for those). You can now solve for an interest rate. Making this 
computation you have:

pv = 6725
n = 72
pmt = -118
fv = -1440

solving: i = 12.0702 Nominal Annual Interest Rate or 
    Effective Interest Rate Per Payment Period: 0.0101092

How you are going to handle your 6 "balloon" payments during the life of the 
transaction is anybody's guess. Those payments cannot be handled by the 
financial calculations as I submitted to gnucash.

You could possibly break the transaction into 6 separate transactions, each of 
12 months duration, each with monthly payments of 118, each transaction 
starting on the payment of the previous transaction's "balloon" payment and 
with a pv equal to the balance remaining on the previous transaction.

Setting up the transaction in this fashion, you would compute a nominal 
interest rate for the 6 year period of:

i = 8.02708 

At the end of the first 12 month period, the future value would be:

fv = -5,815.86

Using this (less 240) as the basis for the next 12 months we would have the 
following:

pv = 5,815.86 - 240 = 5,575.86
pmt = -118
i = 8.02708 

Using these compute a Future Value at the end of the second 12 months as:

fv = -4,571.00

For the 3rd 12 month period, we would have:

pv = 4,571.00 - 240 = 4,331.00
pmt = -118
i = 8.02708

Which leaves a Future Value at the end of the 3rd 12 months of:

fv = -3,222.46

For the 4th 12 month months we have:

pv = 3,222.46 - 240 = 2,982.46

which leaves a Future Value at the end of the 4th 12 month period of:

fv = -1,761.60

For the 5th 12 month period we have:

pv = 1,761.60 - 240 = 1,521.60

which leaves a Future Vaule at the end of the 72 periodic payments of:

fv = -179.06

and thus a Final "balloon" payment of 179.06. 

Note that the last "balloon" payment is not 240 exactly since the previous 
payments of 240 have reduced the principle upon which the interest is 
accmulating.

Your scenario with 6 payments of 240 during the life of the transaction would 
have to have a different interest rate than what I have computed since the 6 
payments reduce the principle during the 6 years of the transaction.

>
>
> P.S. this is an actual transaction with actual parameters

This may be an "actual" (maybe even typical) leasing transaction (you keep 
writing about "lease amount" and "lease transaction", etc), but it is NOT an 
actual or typical transaction for a financial institution in loan or interest 
generating transactions.

If any gnucash user or developer can supply data or details on any financial 
institution that would consider such a transaction as typical, I would be 
most happy to learn of such transactions. If they could be explained lucidly 
and in detail, maybe a means of computing such transactions could be worked 
out.

Hope this helps,
Terry

>
>
> Regards
>
> Saher Edris
>
>
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Mail - You care about security. So do we.

-- 
++++++++++++++++++++++++++++++++++++++++++++++++++++++
======================================================
******************************************************

"A human being is part of the whole called by us the 
Universe. We experience ourselves, our thoughts and 
feelings as something separated from the rest --a kind 
of optical delusion of consciousness.
This delusion is a kind of prison for us, restricting 
us to our personal desires and to affection for a few 
persons nearest us. Our task must be to free ourselves 
from this prison by widening our circle of compassion 
to embrace all living creatures, and the whole of 
nature in its beauty."

Albert Einstein.
                  
"We can't solve problems by using the same kind of 
thinking we used when we created them." 
--Albert Einstein

******************************************************

We have the best government money can buy, and it has.

Terry Boldt.     

******************************************************

You must decide: 

Are you a body with a soul or a soul with a body?

Terry Boldt

******************************************************

When you change the way you look at things, 
the things you look at change.

******************************************************
Paraphrasing Ben Franklin:

Those who sacrifice freedom for safety, have neither.

The exact quote:               

They that can give up essential liberty to obtain a little
temporary safety deserve neither liberty nor safety.
  Benjamin Franklin (1706 - 1790),
  US author, diplomat, inventor, physicist, politician, & printer
  Historical Review of Pennsylvania, 1759

******************************************************
A thought often repeated becomes an act, an act often
repeated becomes a habit, a habit often repeated,
a character and a settled character molds the very
destiny of man.

Man is the master of his own destiny.

"The Voice of Babaji", Page 236
******************************************************
What man thinks, that he becomes

Upanishad
******************************************************
Common sense is so very extraordinary 
for being for so very uncommon.

Terry Boldt
******************************************************
To say what is real,
Must be exactly what we feel,
To speak of the truth,
And be open this way,
Is to say what you mean,
And mean what you say.

Pearl Boldt
******************************************************
"If you don't know, you cannot teach, except by faith.
And faith implies doubt. Doubt and the resulting
repression of doubt breed fanaticism and intolerance.
Worse, they breed ignorance pretending to infallibility,
which breeds charlatans and blind followers."

"Muddy Tracks", Frank DeMarco, page xxv
******************************************************
"for without time,no thought of anything is possible;
without space, no conception of anything is possible and
without causation no consideration of anything is possible. And
again, time space and causation generally appear inter-related
in our consciousness not dependent of one another.
So the mind lives, moves and has its existence in these
three notions, which are necessarily finite, owing to
their perceptional value and without which we cannot think,
conceive or imagine anything. Deprived of these three,
the constitution of the mind breaks down."

"The Voice of Babaji", Page 442-443
******************************************************
"The definition of and the mystery and meaning of faith,
will open like a flower, only while sitting in silence.
Faith in something greater than oneself is tantamount to
a veil being withdrawn from the depths and distances
glimmering within, and a feeling of eternal hunger for
peace and fullness, for all that the distracted world
of today denies. It is not possible to discover the Real
and abide in it, except by our own experience."

"The Voice of Babaji", Page 444
******************************************************
******************************************************