ProjectionHub’s 'Bitcoin for Small Businesses' financial model allows you to enter in historical financial information and use that as a baseline to forecast the future as well as forecasting the acquisition and future value of Bitcoin:

• Current cash balance
• A/R, Inventory, and A/P balances
• Existing fixed assets and future assets to be purchased
• Projected future fixed asset purchases
• Existing loans and planned future loans
• Up to 5 years of historic revenue data by different revenue source categories
• Predicted revenue by different revenue sources for the next 5 years
• Ability to add in current year revenue by month
• Projected Expenses & COGS can be based on historical actuals or new estimated monthly expenses
• Opening Bitcoin balance
• Percentage of operating cash converted to BTC

Then, the template will generate:

• 5 Year Income Statement Annual Summary
• 5 Year Income Statement Monthly Breakdown
• 5 year Cash Flow Statement Annual Summary
• 5 year Cash Flow Statement Monthly Breakdown
• 5 Year Projected Balance Sheet Annual Summary
• 5 Year Projected Balance Sheet Monthly Breakdown
• Valuation Estimate (3 different methods) (including Bitcoin value)

The At-A-Glance tab serves up a comprehensive financial snapshot. Visualize your data with key financial ratios, startup cost estimations, and break-even points. Infographics, charts, and summaries will enhance your presentations, making them compelling for stakeholders, lenders, or investors.

Tables, charts, graphs and dashboards include:

• Profit and loss summary
• Break down of annual Bitcoin acquisition and performance
• Use of expansion funds
• Key industry financial ratios ​​
• Cash flow from operations graph
• 5 years of monthly and annual profit and loss, cash flow and balance sheet forecasts

The valuation tab will automatically calculate an estimated valuation using 3 different methods plus the performance of your Bitcoin holdings!

When projecting revenue for an existing business expansion, it makes sense to start with the historical financials.  Our template gives you the ability to create a base to project off of using your historical financials.  You can input up to 5 years of historical data including monthly detail for the current year.  From there you can select how you would like to project revenue for each revenue line item.  Your revenue forecasting options include:

• Annualize current year revenue
• An Average of previous years
• Manually set a base monthly revenue projection moving forward
• Custom revenue categories

Once you have a base monthly revenue calculated, you can increase or decrease each revenue line by a percentage or manually forecast revenue based upon your businesses planned expansion.

Similar to the revenue forecast, you will be able to establish a base level of expenses and costs of goods sold (COGS) for each expense based on historical data or manual entry based on entirely custom expense categories. From there you can increase or decrease expense line items by a percentage, or forecast expense line items as a percentage of revenue so you can scale your expenses as you expand the business.

In the general assumptions tab, you will input important details such as your existing fixed assets, current assets, and loans. Then you will also be able to add any fixed assets to be purchased as well as any future loans or additional investments. The template will then automatically build your financial statements including your balance sheet which will always balance.

There are also 2 separate tabs, one for inputting the estimated bear, base, and bull case of BTC value including ARR reduction each year as well as the steady state of ARR. The other tab includes a whole host of Bitcoin assumptions for you to dial in your plans for acquisition of BTC and building value.