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]

[TABLE="width: 637"]
<colgroup><col span="5"><col><col><col><col></colgroup><tbody>[TR]
[TD]Loan[/TD]
[TD]intrate[/TD]
[TD]term[/TD]
[TD]repayment[/TD]
[TD]actrepaid[/TD]
[TD]loanincrease[/TD]
[TD]intcharged[/TD]
[TD]outstanding[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100000[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]16100[/TD]
[TD]0[/TD]
[TD]9750[/TD]
[TD]93650[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]93650[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]16100[/TD]
[TD]0[/TD]
[TD]9130.875[/TD]
[TD]86680.875[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]86680.88[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]16100[/TD]
[TD]0[/TD]
[TD]8451.385[/TD]
[TD]79032.26031[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]79032.26[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]16100[/TD]
[TD]0[/TD]
[TD]7705.645[/TD]
[TD]70637.90569[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]70637.91[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]16100[/TD]
[TD]0[/TD]
[TD]6887.196[/TD]
[TD]61425.1015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]61425.1[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]16100[/TD]
[TD]0[/TD]
[TD]5988.947[/TD]
[TD]51314.04889[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]51314.05[/TD]
[TD]9.75[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]17000[/TD]
[TD]5000[/TD]
[TD]5003.12[/TD]
[TD]44317.16866[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44317.17[/TD]
[TD]10.15[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]17870[/TD]
[TD]0[/TD]
[TD]4498.193[/TD]
[TD]30945.36128[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30945.36[/TD]
[TD]10.15[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]17870[/TD]
[TD]0[/TD]
[TD]3140.954[/TD]
[TD]16216.31545[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16216.32[/TD]
[TD]10.15[/TD]
[TD]10[/TD]
[TD]16100[/TD]
[TD]17870[/TD]
[TD]0[/TD]
[TD]1645.956[/TD]
[TD]-7.728531448[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]