Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
financial function ..please
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
financial function ..please
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 | | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
financial function ..please
Dear Niek,
Thanks very much for your reply, But if you please give me a sample if the interest rate is decrease .. so how i can solved or i mean how its work so if i meet him tomorrow and he give me data on how it may decrease so i can solve it while setting with him. Best Regards, Bassem Niek Otten wrote: 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 | | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
financial function ..please
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |