How to calculate the monthly repayment based for each and every asset type (highlighted in yellow ? The age of asset is based on months. And the Interest Rate and Term of Loan (months) data is highlighted in yellow.
Attached is the excel file.
Thanx
Bookmarks