XTR : Amortization Schedule

Hi,

Can anyone advise if there is any way available to generate Amortization Schedule .

E.g. Business expects to generate a Loan Amortization schedule for a Principal of 1000 , Duration 12 Months , Period Monthly , Interest Rate of 10% .

Where it should show like :

Interest rate : 10%

Term : 12 months

loan amount : 1000

Month	Payment	Interest	Principal	Balance(out)
1	87.92	8.33	79.59	920.41
2	87.92	7.67	80.25	840.16
3	87.92	7	80.92	759.24
4	87.92	6.33	81.59	677.65
5	87.92	5.65	82.27	595.38
6	87.92	4.96	82.96	512.42
7	87.92	4.27	83.65	428.77
8	87.92	3.57	84.35	344.42
9	87.92	2.87	85.05	259.37
10	87.92	2.16	85.76	173.62
11	87.92	1.45	86.47	87.14
12	87.92	0.73	87.19	0

Requesting kind help and guidance on the same.

Thanks,

Soumya