Loan mortgage table

[apgmin]

Can anyone please make a loan mortgage table for maximum 10 years @ 9.75% interest p.a. calculated monthly

Actually there are a lot of templates for this. But I need the following features

1. there should be provision for extra loan repayment by the borrower in any month possible

2. Similarly there should be provision for adding additional amount to the loan also in any month.

ie. the borrower can repay some extra amount in any month in additional to the emi and also in some months he can ask for additional loan

 

[oldbrewer]

Loan	intrate	term	repayment	actrepaid	loanincrease	intcharged	outstanding
100000	9.75	10	16100	16100	0	9750	93650
93650	9.75	10	16100	16100	0	9130.875	86680.875
86680.88	9.75	10	16100	16100	0	8451.385	79032.26031
79032.26	9.75	10	16100	16100	0	7705.645	70637.90569
70637.91	9.75	10	16100	16100	0	6887.196	61425.1015
61425.1	9.75	10	16100	16100	0	5988.947	51314.04889
51314.05	9.75	10	16100	17000	5000	5003.12	44317.16866
44317.17	10.15	10	16100	17870	0	4498.193	30945.36128
30945.36	10.15	10	16100	17870	0	3140.954	16216.31545
16216.32	10.15	10	16100	17870	0	1645.956	-7.728531448

<colgroup><col span="5"><col><col><col><col></colgroup><tbody>
</tbody>