View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Assad Assad is offline
external usenet poster
 
Posts: 6
Default Fixed & Reducing Balance Loan Calculation.

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