Question

5. Mr. X borrowed a loan of Rs. 50,00,000 for a period of 5 years to be repaid in equated half yearly instalment at an interest rate of 12% per annum.Prepare a loan repayment schedule showing payments. Generalize the sheet to incorporate any changes in year, amount, rate or periodicity. You are required to write down the formulas in the appropriate cells.

Answer 1

Answer:

see the attachment........