View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jayanath2021@gmail.com is offline
external usenet poster
 
Posts: 1
Default Fixed & Reducing Balance Loan Calculation.

On Sunday, November 11, 2007 12:21:00 PM UTC+5:30, Assad wrote:
Hi.

Could anyone, please guide me following two questions.

Loan Calculation For

Fixed Annual Interest Rate
Reducing Balance Annual Interest Rate

Prinicipale Amount : 800,000
Profit Rate: 5.9 % Per Anum
Years: 20

Advise formula for both type of calculation, to know installment per month
or per year basis.

Regards.

Assad