Asset Management, Banking, Bitcoin, Cryptocurrency, Financial Model, Financial Services, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Break-Even, Cash Flow Analysis, Cash Flow Projections, Dashboard, DCF Model, Discount Rate, Excel, Financial Analysis, Financial Debt, Financial Model, Financial Modeling, Financial Projections, Financial Ratios, Investment Multiple, NPV (Net Present Value), Pricing, Pro-Forma, Return on Invested Capital (ROIC), Return on Investment (ROI), Scenario Analysis, Sensitivity Analysis, Valuation, Venture Capital

Overview

A cutting-edge crypto token valuation model designed to provide comprehensive insights and analytics for investors, traders, and enthusiasts in the dynamic world of cryptocurrency. Our model employs a robust combination of traditional financial fundamental analysis to assess the intrinsic value of tokens within the crypto space. This model particularly focuses on borrow/lend crypto protocol token valuations via P/S and DCF methodologies.

Structure

Protocol Asset Table

Input the current asset listing of the protocol as of the current or retroactive date of valuation. These values include, the assets listed for collateral, the stability fee, the collateral ratio, the max borrow limit and the remaining available borrow per asset.
Please note, these values per the model are presented in a hard code form, however, there are certain ways to set up a webscraper which the user will have to implement on their own depending on the protocol selected

PS Ratio

This tab values the token under a base, bear and bull scenario via a P/S multiple methodology. This allows an investor to compare various protocols on an “apples-to-apples” basis. The user can compare the 30d average to the 1 Year Forward
Input assumptions include:
- Fully Diluted Market Cap on 1 Year Basis
- Weighted Average Annual Stability Fee
- Average Stability to Liquidation Ratio
- Average Total Value Locked
- Average Borrow to Total Value Locked Ratio

DCFs

This tab allows the user to value the protocol on a discount cash flow valuation methodology. This is also split between an analysis of a base, bear and bull scenario.
Input assumptions include:
- Current Token Price
- Tokens Outstanding
- Max Issuable or Potential Tokens (Fully Diluted)
- Average Stability Fee
- Stability Fee to Liquidation Fee Ratio
- Borrow to Total Value Locked Ratio
- Discount Rate
- Terminal Growth Rate
- Annual Growth Rate for 5 Year Projections

Please don’t hesitate to reach out directly with any questions or potential customizations you may require ahead of purchasing.

File Type: .xlsm (No Macros are used)

Reviews

Purchase of Sheet

By Indranil Roy Chowdhury on January 15, 2025 at 10:34 (Verified Purchase)

The purchase of the document has been very smooth no problem at all.
The document itself , I believe could have used a few more parameters to price the coin .

best regards
Indranil

Thank you for your feedback.

866 of 1664 people found this review helpful.

You must log in to submit a review.