Blockchain/ICO Forecasting and Analysis Financial Excel Model Template

This ICO model allows you to analyse and create financial projections for cryptocurrencies and blockchains.

by Alex Martyanov
Professional Private Practice - Financial ModelingFollow 42

1 review423 views|3 comments|Bookmark

Description
This Initial Coin Offering (ICO) model is the complete Excel template for analysing, forecasting and understanding the cryptocurrency market. The model determines the right numerical parameters for smart contracts so as to have an effective crypto economy and attractive tokens for investors.

If you want to educate yourself on the fundamental operations behind any cryptocurrency, or even launch your own, this tool will provide the means to do so.

The ICO model has several aims:

Build high level projections for crypto economy and ecosystem
- Amount of different operations and transactions in USD and tokens
- Number of users of utility tokens
- Size of crypto economy in tokens and USD

Valuate expected token price at different years and stages of projects
- By using equation of exchange (Chris Burniske approach)
- By using growth approach

Find a break-even point for an ICO team - right balance between ICO investments and future revenues from one side and expenses on development of ecosystem and attraction of ecosystem users from the other side

Has flexible setup for pre-ICO and ICO stages
- Distribution of tokens between team, investors, advisors, bounty
- Different prices and discount at pre-ICO/ICO stages
- Hold period for pre-ICO/ICO investors

Track ICO team expenses and a burn rate

Scenario analysis for base/best/worst cases

Has a detailed first 12 months analysis and 5 years projections

All outputs are in table and chart form ready for inserting into a WP

This ICO module, Tokens module, and valuation module suits almost any crypto/ICO projects. If you want to stay ahead of the game and learn to forecast the rises and falls of the value of a cryptocurrency, this Excel template will help you.

This business tool includes
1 Excel Spreadsheet