Free Excel models on valuing complex debt

BVWireIssue #221-1
February 3, 2021

fair value for financial reporting
fair value, debt valuation

During a recent BVR webinar, several case studies were presented on valuing complex debt instruments. The presenters offered to the audience an Excel file that contained the models used for the three case studies: (1) simple convertible debt using the DCF/yield method for the debt component and the Black-Scholes model for the option component; (2) convertible debt using a lattice model approach; and (3) valuation of warrants. If you would like a copy of the Excel file, send an email to info@bvresources.com with the words “Excel for complex debt” in the subject line, and we will be happy to get it to you. Ideally, you should listen to the case studies that the models relate to, and you can access a recording of the webinar if you click here (free to BVR Training Passport Pro holders; otherwise, it must be purchased). The webinar, Navigation Through the Maze in Complex Debt Instruments Valuation, was presented by Mark Zyla (Zyla Valuation Advisors), Rajesh C. Khairajani (KNAV), and Faisal Lakhani (KNAV).
Please let us know if you have any comments about this article or enhancements you would like to see.