Shares Outstanding Calculator (UNLOCKED)
  • Shares Outstanding Calculator (UNLOCKED)
Originally published: 09/08/2019 18:06
Publication number: ELQ-65056-1
View all versions & Certificate
certified

Shares Outstanding Calculator (UNLOCKED)

An Excel model to compute the actual and weighted shares of the outstanding accrued in the various options pools.

Description
NOTE: A free DEMO version of this model can be found at:
https://www.eloquens.com/tool/GYeDTgpY/startups/cap-tables/fully-diluted-shares-outstanding-excel-model-template-demo

● Calculate F-D shares outstanding
● For Quarterly or Annual reporting
● Tracks unlimited # of share blocks

This model contains the following elements:
● Estimates average number of fully-diluted shares outstanding for a publicly-held corporation
● Tracks for both Quarterly and Annual reporting
● Quarterly Options, Repurchases, Employee purchases, and Share Price are factored into dilution/accretion algorithm

This model contains calculations for Actual and Weighted shares outstanding accrued to the option pool, repurchase pool, and shares reserved for Employee Stock Purchase Plans.

It also allows the user to enter current share price as well as a subjective, educated guess as to the premium or discount at which the stock is currently priced, and outputs a corresponding number of Shares to be Used for EPS calculations for Quarterly Reporting, and a Fiscal Year average weighted properly.

As with all models at ExcelModels, this workbook contains separate tabs containing integrated financial statements: Income Statement, Balance Sheet, and Cash Flow Statement. All checks and balances are in-place, highlighting areas (such as a negative cash balance) where the user needs to adjust assumptions elsewhere.

This template contains clearly-labeled input cells. All other cells are locked for calculation, labeling, or other use. This focuses the user on the Key Assumptions they have control over, and prompts an accurate forecast.

We also provide model customization and build-out on an hourly or project basis. Please contact us for more information. Thanks.

This business tool includes
1 Excel file

Acquire business license for $29.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • No review yet!

More tools from ExcelModels

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Shares Outstanding Calculator (UNLOCKED)?

The user community and author are here to help. Go ahead!

please wait...