| ||Capital Management for Excel (by ModelSheet) is a powerful Excel template enabling to analyze and evaluate the financial impact of different capital financing strategies for a company. The Excel template can be first customized online and once downloaded provides flexible input parameters to suit the nature and dynamics of the company.|
Capital Management for Excel analyzes the dynamics of different financing sources through a series of investment financing rounds.
The Excel template allows the analysis five types of securities:
- Common shares.
- Convertible notes earn non cash payments (dividends in the template) with the most senior payment preference rights in liquidation and can convert to common stock.
- Preferred stock earns non cash payments (dividends in the template) with payment preference rights in liquidation and can convert to common stock.
- Options which have an exercise price to convert to common stock, a selling price, and infinite term.
- Warrants which are options that are issued and guaranteed by the company.
The number of financing issues can be set for each type of security with each having its own prices and terms.
The number of financing rounds can be defined with dates and names with each one having five phases:
- Start Phase - Stock splits occur and dividends are paid at the start of each round. The value of the company at this point is used to determine the prices of securities during the financing round.
- New Sales Phase - Sell new securities (convertible notes, preferred stock, warrants, options or common stock)
- Post Sales Phase - Records capital and share units after the sale of new securities.
- Conversion Phase - Stakeholders can convert notes and preferred shares and can exercise warrants and options to obtain common stock.
- End Phase - Records security holdings, prices and values at the end of the financing round.
Capital Management for Excel produces the following analytical outputs.
- The number of share units of each issue for each type of security purchased in each financing round.
- The value and share units of each issue for each type of security owned before and after each financing round.
- The number of fully diluted common share units before and after each conversion event.
- The valuation of the enterprise before and after each financing round.
- The payout at liquidation to the original holders of each issue for each type of security after adjusting for any conversions of convertible notes and preferred shares and exercises of warrants and options.
- The payout at liquidation to each issue for each type of security accounting for liquidation preferences of senior securities. Tracking of liquidation preferences and valuation scenarios enable the capital management template to accurately analyze a wide range of financial outcomes.
Both the number of valuation scenarios and number of investment scenarios can be specified.
|Download Capital Management Reference
|For iTunes & iOS Device