Question

5. Mr. X borrowed a loan of Rs. 50.00,000 for a period of 5 years to be repaid inequated hall
yearly instalment at an interest rate of 12% per annum Prepare a loan repayment schedule
showing payments. Generalize the shoot to incorporate any changes in year, amount, rate
periodicity. You are required to write down the formules in the appropriate cells
1
с
D
E
1
2
B
5000000
12%
РА
Years
3
4
5
?
Loan amount
Rate of
interest
Time
Effective rate
of interest
Total
Instalments
Instalment
Payment No.
?
5
6
7
2
Opening
balance
Interest
Instalment
Closing
balance
?
?
-
2 ?
?
2
2
2
8
9
10
11
12
2
3
4
5
?
2
2
2 ?
?
2
2
2
?

Answer 1

Answer:

?????????????????????????#$%&-[>]£gggggggg

hhhhhhhhhhh