Compounding Rate of Interest

N Prakash

Active Member
Joined
Nov 7, 2003
Messages
404
Hi,

I have a loan amount of Rs.100000/- @ 10%, term of loan is 36 months with 12 months repayment holiday. During the repayment holiday the interest has to be deferred and based on the option of the customer I want to calculate simple rate of interest or compound rate of interest and arrive EMI amount or Fixed principal amount on the accumulated amount. Any simple formula. I am using a cumbersome procedure of generating a schedule separately and arrriving the total amount.

Any help to simplify the procedure.

Regards,
Prakash.
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Chitosunday

Well-known Member
Joined
Jul 14, 2003
Messages
1,017
Friend, i think it is better if you give the answer on simple and compound interest. Computation of interest is now so sophisticated that there is so many versions per country. My thought is if there is a 12 months holiday , then you must get the future value of that amount on its 12 month which will give you your revised present value. The other 24 months then is your revised period. You can now use the function pmt()
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,665
Members
412,481
Latest member
nhantam
Top