more-arw search

Q&A Forum

Does anyone know of an Excel model that computes the fair value of a preferred stock ratchet provision?

ASC 815 40 (aka EITF 07-05) requires that the anti-dilution provision for down round price ratchets be fair valued and recorded as a derivative liability. Is anyone aware of an Excel model or "add in" that can perform the necessary computations?

Answers

Mark Stokes
Title: CFO
Company: Private
(CFO, Private) |

Try this: https://www.proformative.com/og/resource/general-content/anti-dilution-calculations-full-ratchet-broad-based-weighted-average-mod. Both an excel model and the references behind it.

Kirk Sprunger
Title: CFO
Company: The Yuma Companies, Inc.
(CFO, The Yuma Companies, Inc.) |

I am also looking for a model to compute the fair value of a down round provision in a preferred stock provision. My understanding is that this is a monti carlo simulation model requiring the use of Crystal Ball or @risk add in software.

3884 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.