![Complex Capital Allocation Model (with Macros)](https://file.eloquens.com/media/thumb/0/89/89534_1_384.png)
Originally published: 16/04/2021 08:29
Publication number: ELQ-54848-1
View all versions & Certificate
Publication number: ELQ-54848-1
View all versions & Certificate
![Eloquens believes smart knowledge should be shared, for the benefit of all in the global community. Our platform records and certifies publication dates to help authors protect their IP and reputation. Users can safely discover talented authors and pick great original contents. certified](https://static.eloquens.com/common/img/certified/certified-64.png)
Complex Capital Allocation Model (with Macros)
Complex Capital Allocation / Backsolve Model (with Macros)
complex capital structurescomplex capital allocationbusiness valuationoption pricing methodcurrent value methodbacksolve methodblack-scholesprivate equityventure capitalstart-ups
Description
This model is an extremely valuable tool for financial analysts, business valuators, private equity investors, auditors and other financial professionals who are working with a business that has a complex capital structure.
Using only standardized inputs, this model allocates business value across multiple classes of stock with different economic rights / preferences under the Option Pricing (Black-Scholes) and Current Value Methods. This model can also determine the implied value of a business with a complex capital structure given a recent capital raise (i.e., business valuation under the Backsolve Method).
Capabilities include complex capital allocation across a maximum of 40 different classes of stock or derivative instruments. Preferred stock, common stock, options and / or warrants can all be considered within this model.
All of the most common (and some of the less common) economic rights/preferences are included in this model:
1. Preferred stock features include liquidation preferences, cumulative preferred dividends, participation rights, participation caps and conversion rights. For each class of preferred stock, five separate liquidation preferences can be entered, each with its own individual liquidation multiplier (in order to account for senior as well as any additional junior liquidation preferences). Separate conversion ratios can also be entered for preferred stock conversion rights and participation rights.
2. Option / Warrant features including conversion ratio and strike (exercise) price
Manual overrides are also available for many input fields.
This model is an extremely valuable tool for financial analysts, business valuators, private equity investors, auditors and other financial professionals who are working with a business that has a complex capital structure.
Using only standardized inputs, this model allocates business value across multiple classes of stock with different economic rights / preferences under the Option Pricing (Black-Scholes) and Current Value Methods. This model can also determine the implied value of a business with a complex capital structure given a recent capital raise (i.e., business valuation under the Backsolve Method).
Capabilities include complex capital allocation across a maximum of 40 different classes of stock or derivative instruments. Preferred stock, common stock, options and / or warrants can all be considered within this model.
All of the most common (and some of the less common) economic rights/preferences are included in this model:
1. Preferred stock features include liquidation preferences, cumulative preferred dividends, participation rights, participation caps and conversion rights. For each class of preferred stock, five separate liquidation preferences can be entered, each with its own individual liquidation multiplier (in order to account for senior as well as any additional junior liquidation preferences). Separate conversion ratios can also be entered for preferred stock conversion rights and participation rights.
2. Option / Warrant features including conversion ratio and strike (exercise) price
Manual overrides are also available for many input fields.
This Best Practice includes
1 Excel Workbook (with Macros)