Hi, I'm building a model to capture and plan leases against the IFRS16 standard. I use a numbered list and have a form to capture start date, end date, initial payments, fixed payments and discount rate. The output is a report by lease showing Interest, Depreciation, Lease Liability. We need the function to modify the leases from a point in time - all calculations up to the modification date remain static, then the new calculations take over. There could be multiple modifications. My first thought is to have a child list (also numbered) and module to capture the "New" inputs like New End Date, New Discount Rate, Impairment Value. I have built this and a copy of the calculation module based on the new inputs (for the child). The problem I'm having is combining the results of the Parent and child leases into one based on their modification dates. Has anyone built a model for IFRS16, and can offer some tips on how to build the modifications function? thanks in advance Josh
... View more