Unless you specify how the interest decreases, this problem has an infinite number of solutions. Another way of saying that is
that it can not be solved.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
wrote in message ups.com...
| Hello all,
|
| I am in challenge with my boss if i can solve this .. so i want sone
| one to help me and then i will understand it and know how it works to
| expecdt in==any futuire questions from him in this matter.
|
| =================
| . If a company borrow 30,000,000 $ from a bank.
|
| . It will pay monthly to the bank 3,000,000 $
|
| . The period of the loan is 15 years.
|
| . By the end of the loan he will found that have paid 45,000,000 $.
|
| . The interest rate is not fixed but getting decrease every year.
|
| = So he want to know how the interest rate will be in the first,
| seconde and the third year ..until the year 15.
|
| =================
|
| So, i need toi know please how to do it .. i want to understand to be
| ready for future questions.
|
| Thanks very much,
|
| Bassem
|
|