Patrick Ocampo

D365 Finance uses "NPV" to calculate the present value of lease payments. The "NPV" calculation assumes the interval between the payments is the always the same, for certain leases such as property leases this is not the case. "XNPV" allows the present value calculation to be more accurate and calculate to exact days. As an example, the rental payments for property leases are typically defined in fixed "rent" days such as 25th December, 25th March, 24th June and 29th September. The system has the ability to setup the fixed "rent" payment days however the present value of the lease payments are not accurate, resulting in a variance with the value of the lease contract when using the XNPV calculation vs NPV. The variance grows exponentially as the value of the lease contract increases. Please add the option for the system to calculate the present value of lease payments using XNPV instead of NPV.