In: Accounting
This amortisation schedule is based on monthly amortisation of loan
--------------------------------------------------------------------------------------------------------------------
For yearly amortisation in PMT function take rate = 12% & nper = 5 period i.e. 5 year
Table will contain only 5 periods