Leases IFRS 16 Schedule in Microsoft Excel with monthly payments.
Functions and formulas used
Datedif(StartDate,EndDate,"m")
Eomonth(StartDate,interval)
Present Value = Value (1 + Interest ) ^ period
Incremental Borrowing Rate is the rate at which lender lend money to lease
Regards,
Kashif
IFRS 16Microsoft ExcelAmortization Schedule
0 Comments