Small Business Model Series Entry #6 – Number Crunching Time
While I wait on family and friends to send me information on the location of ATM’s, I decided it is time to do some preliminary number crunching. My initial introduction to this illustrated a very good return. I’m really interested in determining if I can make some real money or will this be nothing more than an exercise in frustration.
To do this I have to make some reasonable assumptions. First off the national average of transaction activity is 6 per day per machine. The average withdrawal is $60 but I’m going to use $80. For the sake of the fee issue, I decided that I would use a number slightly less than some transaction fees I have read on the internet. Most that I read about are $3 to $4 for a transaction; therefore I have decided to use $2.50.
The first step is to calculate the initial cash out for a machine to have it ready to go. Next, let’s run some daily activity calculations and then monthly calculations. From this, we’ll deduct normal expenses and then determine the final margin. From this margin I’ll subtract some costs associated with my capital investment, that is, the amount of money I’m currently earning for the cash in the bank.
Step One – Initial Capital Costs to Get a Machine Ready
Based on research, it will cost around $2,310 for a new basic model ATM. It will also cost around $327 to ship it to my house. I have to buy some software to use with the machine which is a further $492 (additional licenses for the same software runs around $208 per machine).
Some soft costs with installing the machine include installation costs, the bolts and accessories will run around $67. Add in printer ink and paper for the receipt side of the equation of $37 and you end up with total machine costs on the first day of $3,233.
Now I have to set up a phone line, the monthly cost is $29.14 total all inclusive. The initial connection fee is $45 plus phone wires of $18.91. To connect my machine to the outside world will run another $63.91 (not including the monthly phone line cost).
Since this is a new site, I figure I’ll load the machine with $5,000 of cash. I can monitor the activity from night to night and if I need to, I’ll load more later. My total investment to have the machine ready on Day One is:
Cost of Machine $3,233
Phone Connection 64
Initial Cash 5,000
Initial Start Costs $8,297
I have forty thousand in my bank account. This means I could realistically start out with four sites and still have over $6,000 to reload machines. Since I believe that these machines will start out poorly and take time, I will start to get back my cash fast enough to have plenty of cash to reload on demand.
Step Two – Daily/Monthly Transaction Activity
For this exercise I am going to use a transaction fee of $2.50 and an $80 withdrawal from my machine. Each site will have 5 transactions per day on average. My understanding is that Fridays are the best day of the week because most folks are paid on Friday.
Thus, the formula looks like this:
4 Machines times 5 transactions times $2.50 equals $50.00 per day
4 sites * 5 transfers * 2.50 = $50.00
Weekly: 7 Days * $50/Day = $350.00 per week
Monthly: 30 Days * $50/Day = $1,500 per month
If a machine dispenses $80 per transaction and has 5 transactions per day, it will dispense $400 per day. Since there is $5,000 in the machine, it will take 12.5 days to dispense all the money. A weekly refill is adequate to meet the goal of not allowing the machine to run out of money.
Each machine will make me ($1,500 divided by four) = $375.00 on 150 transactions per machine per month.
I have no clue if this is good or bad. Let’s do some more math.
Step Three – Monthly Costs
From above, each machine will generate $375. From this I will have to deduct commission fees to the site owner, which is $1.00 each. I will also have to deduct the communication fee of $29.14 (see above phone itemization). I’m assuming paper and ink is insignificant. How much does the machine make for me:
Commission (150.00) $1 per transaction * 5 per Day * 30 Days
Gross Margin/ATM $195.86
Since I’ll be filling the machine each week, I figure about 20 minutes of driving and loading time per machine per week. Each machine will take about 1.5 hours (I’m being conservative here) per month. Mileage costs at around 15 miles per week per machine at the current rate of 56.5 cents per mile equals $36 per machine per month.
I have $159.86 per machine per month to cover my costs of capital and my labor time of 1.5 hours.
Step Four – Return of Capital & Time Compensation
The machine will easily get by on $5,000 because I’m changing out the cash each week. The cash should easily go for a week without any issue based on the above. If it goes faster, I’m making more money! What is the cost of my capital for $5,000 per month? I am currently receiving about 2.7% return on my money per year base on various investment options. Thus, 2.7% equals $11.25 per month per machine. Since I value my time at $70 per hour, and I’m taking 1.5 hours per machine per month, I should pay myself $105.00 per month per machine. I net:
Gross Margin from the ATM $159.86
My labor fee (105.00)
Cost of Capital (11.25)
Actual Net Profit per Machine $43.61
Hey not bad! This looks good. I calculated based on 4 transactions per day and I end up losing $1.39. Try to figure this on your own using the above formula, don’t forget the commission is now calculated on 120 transactions (4/day * 30). My breakeven point is somewhere between 4 and 5 transactions per day.
I decided to have a little fun and see what would happen if I averaged eight transactions per day (I’m dreaming). I end up netting $178.61 per machine. This is after all the commission, communication, transportation, and my labor costs. So there is obviously a value to have a high transaction spot for an ATM. I charted this out as follows:
# of Transactions/Day Net Per Month
One transaction per day equates to an additional $45.00 per month on an ATM. This makes sense because each transaction generates $2.50 less the $1.00 for the commission or $1.50 per transaction. One a day equals 30 per month or $45.00 value increase.
This looks like a good business to get into after all. This reinvigorates me to get going on this because this is the value per machine. I have paid myself for my time and I make some money per month per machine. I want to set an ATM tomorrow to get going. But I need to get my information gathered on the locations. I need to chart this. No sense in having a machine sit somewhere and have a low transaction activity.
Entry #6 – Number Crunching Time Invested Time: 3.50 Hrs. Cumulative Time: 28.25 Hrs.
This entry is part of a series of entries exemplifying the steps an entrepreneur takes from starting a business to selling the operation. It is a step by step process addressing the multitude of business concepts every small business owner must face. This is a 6 year example from Day 1 to the day the owner receives a check for selling his business. Read this series as if it you were experiencing all of the trials, tribulations and joy of owning and operating a business.
Do you want to learn how to get returns like this?
Then learn about Value Investing. Value investing in the simplest of terms means to buy low and sell high. Value investing is defined as a systematic process of buying high quality stock at an undervalued market price quantified by intrinsic value and justified via financial analysis; then selling the stock in a timely manner upon market price recovery.
There are four key principles used with value investing. Each is required. They are:
- Risk Reduction – Buy only high quality stocks;
- Intrinsic Value – The underlying assets and operations are of good quality and performance;
- Financial Analysis – Use core financial information, business ratios and key performance indicators to create a high level of confidence that recovery is just a matter of time;
- Patience – Allow time to work for the investor.
If you are interested in learning more, go to the Membership Program page under Value Investing section in the header above.
Join the value investing club and learn about value investing and how you can easily acquire similar results with your investment fund. Upon joining, you’ll receive the book Value Investing with Business Ratios, a reference guide used with all the decision models you build. Each member goes through three distinct phases:
- Education – Introduction to value investing along with terminology used are explained. Key principles of value investing are covered via a series of lessons and tutorials.
- Development – Members are taught how pools of investments are developed by first learning about financial metrics and how to read financial statements. The member then uses existing models to grasp the core understanding of developing buy/sell triggers for high quality stocks.
- Sophistication – Most members reach this phase of understanding after about six months. Many members create their own pools of investments and share with others their knowledge. Members are introduced to more sophisticated types of investments and how to use them to reduce risk and improve, via leverage, overall returns for their value investment pools.
Each week, you receive an e-mail with a full update on the pools. Follow along as the Investment Fund grows. Start investing with confidence from what you learn. Create your own fund and over time, accumulate wealth. Joining entitles you to the following:
- Lessons about value investing and the principles involved;
- Free webinars from the author following up the lessons;
- Charts, graphs, tutorials, templates and resources to use when you create your own pool;
- Access to existing pools and their respective data models along with buy/sell triggers;
- Follow along with the investment fund and its weekly updates;
- White papers addressing financial principles and proper interpretation methods; AND
- Some simple good advice.