hi! I am new comer to forum and I think you will help me to develop my knowledge.
My first issue to be resolved is that, I gave a 5,000,000 loan to someone and he will repay weekly installment of 500,000 and within 2 and half month loan will be fully recovered. so please tell me if the annual interest rate is 8% how can i calculate interest on residual value basis by using MS Exel?

Thank you,