in IFRS 16 - Leases by
How to use the nominal monthly interst rate so that debt on BS reduces from NPV to 0 within the period used in the first place? (IFRS16)

- monthly payments (-20 000 a month for 5 years)
- nominal value at t=0 not used

Structure on my Excel files at the moment:
1) NPV of the lease payments calculated with annual r= 5,1%
 NPV at the beginning of the year (-20 000/(1,051)^(month/12)) --> NPV at t=0

2) NPV - debt instalment (-20000 - r*NPV) = debt at beginning of month 2 --- and so on.

Debt at the end of year 6 should be 0. r= 1,051^(1/12) makes it happen but I must use higher monthly interest rate.

What should I change? Thanks in advance.

Please log in or register to answer this question.

Welcome to AccountantAnswer Forum, where you can ask questions and receive answers on Accounting-related questions.

Get AccountantAnswer App