Blockchain/ICO Forecasting and Analysis Financial Excel Model Template
Originally published: 30/01/2019 12:25
Last version published: 05/05/2021 08:44
Publication number: ELQ-11713-4
View all versions & Certificate

Blockchain/ICO Forecasting and Analysis Financial Excel Model Template

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

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 Best Practice includes
1 Excel Spreadsheet

Acquire business license for $99.00

Add to cart

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Anil Valbh(last updated: 01/09/2019 02:03)
  • Ivan Klykov(last updated: 04/02/2019 20:53)
    Perfect ICO valuation tool
    Excellent model. One of the most practically useful ICO and blockchain projects valuation tools. I recommend it for everyone, who is looking for the model that explains who does this industry actually works! Great job!

People using this Best Practice also downloaded


Discussion feed for Blockchain/ICO Forecasting And Analysis Financial Excel Model Template

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

  • Carl Pilgrim
    If an ICO is not being contemplated will this template work for other scenarios?
    arrow_drop_uparrow_drop_downReply reply
    • Alex Martyanov
      ICO is a possible way of attraction funds into a project. The main model goal is to allow to asses and compare of project expenses, cryptoeconomy functioning and token price so as to find the right cryptoeconomy parameters what makes everyone happy: staff and expenses get paid, customers get their products, investors get their returns. The particular technical way of attracting funds is not that relevant in the scope of this model.
      arrow_drop_uparrow_drop_downReply reply

5.0 / 5 (2 votes)

please wait...