Under the provisions of Accounting Standards Codification 815-40 (ASC 815-40, formerly EITF 07-05), for anti-dilution clauses involving price ratchets in down rounds, companies must measure them at fair value as derivative liabilities and recognize them in the financial statements. This requirement poses computational challenges in practice.

Currently, we are seeking a tool capable of performing such complex calculations. Specifically, does anyone know of or have experience with an Excel model or "add-in" that can conveniently complete the aforementioned fair value calculation? The model or tool should be able to handle variables in ratchet provisions, such as conversion price adjustments, changes in the number of shares issued, and parameters like market volatility.

If you have relevant experience or resources, please feel free to share. We are particularly interested in proven, ready-made solutions that comply with ASC 815-40 measurement requirements, to enhance the accuracy and efficiency of financial reporting.