|
|
|
Learn the Business of I-28 Portlandsterdam University |
Financial Income Analysis of I-28 By Mike Mullins Revised March 13, 2009 Download a Copy of This Document In PDF Format Here Download a Copy of the Excel Spread Sheet Here New Signature Sheet Here - Download and Sign the I-28 Petition.
In most cases we will present facts from known sources. In these cases we will footnote the source. In other cases there will be variables. On the attached spreadsheet these variables are located below the worksheet and highlighted in green. All of the adjoining worksheet above the variable is contingent on the variable. If you change the green variable, the worksheet above will use your new changes to calculate results. Note that you cannot change any of the data from this document. You can change the spread sheet. The spread sheet is locked down with formulas. You may only change items in green and cannot change formulas or modify sheets. This is done so that you may use your own variables to see results. You may safely change things without screwing up the calculations so go ahead and have fun. When changing something in green, be aware that it may affect many other sheets and charts. In the following writing we will discuss the impact as well as how we calculated each variable. Categories that we will discuss are Cardholders, Dispensaries, and Production. Further study was done to incorporate the consumption and production rates to assist in calculating revenue. The study takes in a 10 year period beginning in 2010, the date the proposed act would begin. Each year of the 10 is represented for number of cardholders, calculated on the present growth rate as determined by the population of cardholders for the last 10 years[1]. An important part of this study is the Summary document and excel spreadsheet. Please keep these handy as a reference while reading this document. Each section below describes a page of the excel document. For the most part we will take you through as it was created, which also makes the most logical approach. Cardholder History (History Growth Rate) The growth rate is determined by the population of cardholders for the last 10 years[2] Percentage of growth from each year is calculated. The average is calculated using all 10 years to a single percentage. Only patient cardholders were used for this study. Caregivers and PRG was not included. This percentage will not be used as the variable for the Cardholder Revenue percentage of growth. At this writing we use a 20% growth rate factor which is more conservative than the numbers provided (53 over 10 years and 32 percent over 5) by DHS[2]. Note that had we used the 32%
historical value, the gross revenue would double to 2 billion
dollars. According to the Oregon Pain Management Commission over
9%, or currently over 300,000 Oregonians are dealing with severe
pain. It is conceivable therefore that the program will incur a
population of over 150,000 patients in the next 12 years.
To view a study using the 32% Growth Rate Above Click Here
Cardholder Revenue (Card) Here we will determine the revenue generated by the cardholders. Only patient cardholders were used for this study. Caregivers and PRG was not included. In the following scenario there are two variables; Growth Percentage and Licensing Fee. The Growth Percentage variable comes from the History Growth Rate sheet. We did not use a historical percentage growth factor as the variable. Using a straight 20 percent allows a conservative approach. We calculated out 10 years using the percentage of growth. We did not adjust upward for cost of living, increase in licensing, or additional growth rates. The licensing fee variable was calculated by the revenue as reported by DHS[3] divided by the number of current cardholders for the same period of time. This allowed us to get a fairly accurate average number to use. Here are the results:
Consumption It is important to know the consumption rate when calculating production and dispensary quotas. There are two variables used for Consumption; Ounce and Cost. The assumption is made that the average patient will consume two ounces of medicine per month. This, simply put, is an 24 ounces per year. Reasoning: It is well known that the two ounces per month is a standard amongst many providers. This however is not a true case. The argument can be made in either direction and there is no recommended amount to use as a medicine. Each individual and each case differs. Some use much less and many use much more. Most patients we talk to cannot survive with only two ounces per month. For the sake of knowing that this unit of measure is easy to verify, we have used it. According to a British survey by the Independent Drug Monitoring Unit[4], "regular" users average 2 oz of cannabis per month or about 2 grams per day (a gram yields one or two joints). To determine Cost we used the $40.00 per eighth ounce figure. This appears at this time to be the best market value that would be used in our area. This figure is at the low end of the scale and we hope this is not a true reflection of what will be. According to National Studies[5], “the total value of the domestic marijuana market can be estimated on the basis of its current retail price. Depending on quality, retail price of a single gram (one or two joints) ranges around $10 - $15 ($280 - $420/ounce) for domestic bud, or as low as $5-7 for Mexican grass. For comparison, the prevailing price on the quasi-legal Dutch market is $6/gram. In a legal market, prices could be expected to fall. If they fell to current Dutch prices, the retail value of the current market would be less. However, this decrease would be at least partly offset by an increase in consumption”. Studies have shown that in areas where marijuana has been legalized, prices have dropped 30 percent. We fully expect the price to be much lower than that which we use in this study. This factor should be set by open competition and not pre determined by any authority.
The calculations are done in both ounces and pounds. Here are the results.
Production and Dispensaries In General This area required the most work. To calculate this we used two differing methods then compared the two methods we used against each other. We then took the matching results to use in this report. Dispensaries To calculate the revenue of dispensaries, we used the number of dispensaries from Consumption with the combined revenue of licensing and tax, based on gross sales. Gross sales were figured at an average annual rate of $50,000 per dispensary. In our second revision we matched this figure by calculating consumption and production requirements to meet the determined consumption rate. Both methods cross referenced with the same results. Here we use the Consumption Quota for Dispensary Gross Sales. This variable comes from Dispensary Gross Sales figures on the Production sheet. The Gross Sales Variable of 50k is not used. The only variable change on this sheet is the number of Dispensaries which will change License fees. You must change the Dispensary Gross Sales from the Production sheet. Licensing is set at the $2000 dollar annual cost. Tax is figured at 10% gross revenue of dispensary. There was no provision made for business licensing, employment and other taxes. Here are the results.
Production To figure production revenue we first calculated production rates. This allows us to calculate the number of producers required for the consumption rate. We used this method to match and cross reference both our Dispensary and Production revenues. Production Yields First I configured the annual production rate for a single producer. This is based on the 24 plant limit, each plant producing 5 ounces, 4 cycles per year. The assumption is that the indoor plant will produce at best 5 ounces, four times per year, matching an outdoor plant at approximately one pound per year. Thus 5 ounces was used as the variable. Once the production yield was calculated we used this result against the annual consumption rate in ounces. Ounces were calculated at $320 each for Dispensary and $150 each for producers. Here is the result.
In view of not every patient using the dispensary services, we have calculated only a small percent for production licensing. It is also expected that there will be wholesale pricing when discussing sales of goods from the producer to a dispensary. This has been taken into account in the calculations through reduction of the ounce price to 150 per unit.. In the following chart, we simply calculate the revenue by taking the number of producers times the combined licensing fee and 10% tax on gross sales. Here is the result.
The Results (Master) The final results show the combined income of card holders, dispensaries and producers. Here is the result.
Looking at just the first year, we can see that the addition of I-28 will be significant financial revenue for the State.
Additional Federal and State Taxes In addition to the new taxes are the standard taxes of running a business. We calculated a 30% Federal and State tax on Gross Income from Dispensaries. We also included the number of employees that will be required to run these dispensaries. Note that this does not include local city license and taxes. Here is the results.
Summary The summary of this work is found on the I-28 document attached to this study.
DHS Financial Report [1] Based on 10 years [2] DHS OMMP Statistics 10/1/08 [3] DHS Financial Statement September 12, 2008 [4] M. Atha and S. Blanchard, "Self-reported drug consumption patterns and attitudes towards drugs among 1333 regular cannabis users," Published by the Independent Drug Monitoring Unit 1997. Cited in Leslie Iversen, The Science of Marijuana, Oxford Press. 2000, pp. 217-9. [5] California NORML Report by Dale Gieringer, Ph.D. - Updated Feb. 2009
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Send mail to
ActTrack@gro4me.com with
questions or comments about this web site.
|