Bitcoin, Cryptocurrency, Financial Model, Financial Services |
Cash Flow Analysis, Cash Flow Projections, Dashboard, DCF Model, Excel, Forecasting, NPV (Net Present Value), Sensitivity Analysis |
The main purpose of this model is to compare when you may want to switch from in-house mining to cloud mining based on various assumptions.
This would change based on your assumptions about the future of Bitcoin (BTC) price as well as the difficulty % compounding increase.
Various NPV’s will populate in the ‘Summary’ based on how you structure the in-house/cloud assumptions together. The NPV represents both of them over the course of 27 months.
The in-house mining light yellow tab allows you to enter all your assumptions about buying mining equipment and the expected running costs of that as well as the current difficulty factor.
Then there is the light yellow cloud assumptions tab, where you build a scenario for starting cloud assumptions after mining for a certain amount of time.
The idea is that you mine in-house, and then at some point in the future, you switch to selling mining futures contracts where customers pay up-front for a pre-determined amount of time, and they earn any BTC rewards during that contract based on the amount of Th/s they initially buy.
In cloud mining, you have maintenance costs and up-front costs. This assumes you have a supplier that you purchase from rather than selling your own mining rewards. So, you are basically a middle-man in this situation.
One simple scenario you can do is model out if you buy equipment, mine for the next 8 months, and then switch over to cloud mining in month 9.
You will have 3 different contracts that you can measure an NPV from. Assuming you do 100% 12-month contracts, 18-month or 24 months. Based on your inputs, the in-house mining revenue will stop, and the cloud revenue will start and go until the contract length is up.
Everything is then measured in NPV per up to 5 different price predictions of BTC and per 3 different contract offering assumptions.
In general, customers would buy mining contracts (e.g., Bitcoin) to get future rewards if they thought the price of BTC was going up, and a middle-man would want to facilitate this based on their thinking that the price of BTC is going to do down. This creates a market.
Charts have been added to show NPV based on all the various scenarios, but it is assumed that you will be able to fully sell as much Th/s as you would have been mining.
Similar Products
Other customers were also interested in...
Crypto Trading Platform – 5 Year Financial Model
Financial Model presenting an advanced 5-year financial plan of a Crypto Trading Platform allowing c... Read more
The Bitcoin Farm Model – Economics
The primary purpose of this model is to assess the feasibility of a Bitcoin farm by taking into acco... Read more
Multi-Member Investment Fund Portfolio and Distrib...
A fund management tool to track many positions over time as well as distributions to up to 20 member... Read more
Investment Metrics to Compare Multiple Stocks / Cr...
A general set of models that come with explainers on how you derive various financial ratios from a ... Read more
Lending Platform Financial Model (LaaS)
Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (... Read more
SaaS Financial Model Bundle
This is a bundle of Financial Model Templates for SaaS businesses and their related sectors such as ... Read more
Lending Model Startup Forecast: 10-Year Scaling &#...
This is a full 10-year startup lending business financial model, including a 3-statement model. Accu... Read more
Pawn Shop / Broker 5 Year Financial Model
Video Tutorial: https://www.youtube.com/watch?v=3mZFMB4z0Qc The model have revenue a... Read more
Real Estate Brokerage Economic Analysis
Create up to a 10 year financial forecast for a real estate brokerage operator. Includes three way m... Read more
Loan Tape Analysis / KPI Dashboard
A framework that makes it easy to drop in your loan data and automatically generate analytical insig... Read more
You must log in to submit a review.