Types
of Securities |
|
The model includes five types of securities. |
|
• Convertible notes earn non-cash payments (termed dividends).
See Technical Notes below
for default conversion rules. |
|
• Preferred shares earn a dividend and can convert to common
stock. |
|
• Common stock |
|
• Warrants have an exercise price, a selling price, and exercise
conditions. See Technical Notes below
for default exercise rules. |
|
• Options have an exercise price, a selling price, and exercise
conditions. |
|
FinModel can easily change the number of series for each types
of security. (Such changes would present a major challenge if authoring were
performed using conventional spreadsheets). |
|
Major Computed Results |
|
The model computes: |
|
• the value and
share units of each type of security owned before and after each transaction
round. |
|
• the number of share units of each type purchased at each
transaction round. |
|
• the number of fully diluted common share units before and
after each conversion event. |
|
• the valuation of each type of security before and after each
transaction round, and the value of
the enterprise before and after
each transaction round. |
|
• the payout at liquidation to each type of security, accounting
for liquidation preferences of senior securities. |
|
Investment Rounds |
|
The model includes a number of investment rounds that you can
set, including 'Exit'. You can specify the number of rounds in your
customized template. |
|
Phases within Each Investment Round |
|
Each investment round has five phases that occur in this order,
and include these transactions. |
|
1. "Start Phase": Stock splits occur and dividends in
kind are paid at the start of each investment round. |
|
2. "New Sales Phase": Sell new securities (convertible
notes, preferred stock, warrants, options,
common stock) |
|
3. "Post Sales Phase": Record investments and share
units after sale of new securities. |
|
4. "Conversion Phase": Stakeholders can convert notes
and preferred shares and can exercise warrants and
options to obtain common stock. |
|
5.
"End Phase": Record security holdings, prices and values at the end
of the investment round. |
|
All five phases are assumed to occur on the date of the
investment round. |
|
You can edit this phase structure of a round in customized
templates. You can edit the phase structure using FinModel Authoring. This is
a fairly complex process, but it is much easier to do with FinModel Authoring
than with conventional spreadsheets. |
|
Investment and Return on Investment |
|
The model reports three measures of return on investment for
each series of each type of security. |
|
• Return multiples: the multiple of investment that is paid out |
|
• Present value of the cash flow for each series of each type of
security. The discount rates can differ across
series and types of securities to
reflect different risk profiles. |
|
• Internal rate of return for the cash flow from each type of
security |
|
The key results are collected on worksheets 'Investment',
'Shares', 'Valuation', and 'Payout'. |