• Register
Search Questions / Answers

Welcome to AccountantAnswer Forum, where you can ask questions and receive answers. Although you need not be a member to ask questions or provide answers, we invite you to register an account and be a member of our community for mutual help. You can register with your email or with facebook login in few seconds

Get AccountantAnswer App


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.
in IFRS 16 - Leases by

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.