Loan amount spreading in months columns after putting the number of installments automatic

Dear Sir,
I have a problem, I have the total Loan amount in one column, if I enter no. of installments in another column, the loan amount should spread into the months columns. Kindly help me. I have attached a sample file for your reference please.
Regards,
Murali.

Hello sir,
Thank You its working.
Regards,
Murali

Dear Mr. Dave,
Thank you very much its working. But I have one more problem. See in the same thread instead of no. of installments if i enter monthly amount deductible directly the monthly columns should spread till the loan exhaust. please give me solution for this also.
Regards,
Murali