← All projects

Project 04 Planned

IND-AS 116 Lease Calculator

Lease accounting under IND-AS 116 is repetitive and error-prone — exactly the kind of thing that should be computed, not typed.


For: Technical accounting and audit · Planned — Month 4.

The problem


Lease accounting under IND-AS 116 is mechanical but easy to get wrong: the ROU asset, the liability unwind, the monthly entries. The work rewards precision and punishes fatigue.

What it does


Enter the lease terms — start, end, rent, escalation, incremental borrowing rate — and get back the ROU asset, the full lease-liability schedule, the monthly journal entries, and a clean Excel download.

  • Tested against three textbook examples
  • Excel output matches the format auditors expect
  • Handles escalation clauses and break options

Design choices


Tested against three textbook examples with matching outputs; every liability schedule closes to zero, with interest and principal tying to each payment. The Excel is laid out the way an auditor expects to receive it, not the way a developer finds convenient.

Only someone who has worked an audit knows why that format matters — which is rather the point of building it.

Stack


PythonStreamlitopenpyxl

Built and demonstrated on synthetic data only.