The goal of this model is to allow owners/managers to develop a model that they want to use in order to incentivize their salesmen with a bonus based on hitting quarterly sales numbers. It allows for the user to put in all assumptions related to the sales/revenue generated by the salesmen, what sales hurdles they have to beat to get a certain bonus, and all the costs related to their activity/maintaining their accounts.
Dec 31, 2016
Dec 21, 2016
This is one of the primary ways that you can analyze raw data correlation and by using the least squares model, it makes the data much cleaner and allows the user to plug in their own range of inputs in order to see what the output set looks like based on the raw input/output (x/y) values of your raw information.
at 2:23 PM
Dec 16, 2016
This is an Accounting template to deal with the tracking of what money you are owed and what money you owe out. It's pretty simple, but when you go to build an excel template that is able to handle all of this in a user friend way, there are some complexities that come up and so a clean structure is key.
at 11:26 PM
Dec 12, 2016
I have been super busy and was unable to build a financial model here for the past two weeks. However, to get back into the swing of things today I developed a risk assessment excel template. It's not the most complex piece of work, but still would provide a good way for managers/executives to quickly see where their opportunities are and how risky they are.
Dec 5, 2016
Man it sucks being sick. I have had a fairly strong month of work for November, relatively speaking. It is looking like I will have some decent financial positioning for the house purchase at the first of the year, and there does seem to be some progress coming from the passive income areas at a fundamental level.
at 10:10 PM
Nov 30, 2016
This is a highly dynamic and useful way to track the performance of your salesmen / reps and invoices over time. There are a lot of in-depth analytics/visuals put into this KPI dashboard to make it as insightful as possible for the user as well as easy to enter data and use.
Nov 24, 2016
One of the biggest sellers for a business is if they offer insurance on a given product or service. The hard part is figuring out how much you should charge each customer in order to cover your tail end. That is what the following excel actuary model is going to do based on a few inputs.
at 7:56 PM
Nov 19, 2016
This is one of the most common types of financial models needed for all kinds of uses. I have made this one to tailor to an eCommerce scenario. There have been a lot of nice integrations for visual and ease of use. That is the beauty of excel. Note the source for this was SBA.gov.
at 6:00 PM
Nov 9, 2016
This was another fun model that I went for. It is looking at the feasibility of an apple orchard. At first it looked pretty easy. However, the complications with the excel logic that needed to go into making this thing useful to prospective apple orchard investors/developers was intense. Little did I know there is a lot of things to consider and a good amount of varying sources on costs/revenues when looking into growing your own fruit bearing trees.
at 7:01 PM
Nov 7, 2016
I wanted to get a bit more specific in the financial models that I have been producing in excel. So, one of the most applicable fields I could find that truly makes good use of the things you can setup in a model is trying to project out the finances of an open-pit mining operation. There are many assumptions that can be given dynamic uses in order to better allow the user to to sensitivity analysis.
at 2:46 PM
Nov 2, 2016
As you know, I do a monthly review of all income earnings online. The majority of it is as a freelance financial consultant, but some of it is passive income/semi-passive income. So I will try to give you a brief overview of what the month was like.
at 8:48 AM
Oct 26, 2016
Many organizations look to paid SaaS companies to use when managing their sales pipeline and/or CRM systems. This does cost a monthly fee and sometimes ends up not being used properly or not used at all because of the user interface problems. So, I have made an alternative solution that works in excel.
at 10:05 PM
Oct 23, 2016
I was working on this project for a client this week and it turned into one of the most complex financial models I have ever had to put together. It isn't that big or involve that many assumptions (such as a real estate model) but the logic to make it work this well was up there in difficulty.
at 6:02 PM
Oct 14, 2016
One of the most used, but most under-utilized tools in excel would be data validation lists. G sheets has solved one of the issues I am going over by automatically allowing users to search a drop-down list by simply starting to type in a given word, however if you wanted to do this in excel, it is not as easy as checking a box.
at 9:06 PM
Oct 7, 2016
One of the most desired excel templates that any trader or institution can make use of is a way to track positions over time as well as have some kind of universal analysis on these positions. What I have done in this template is given a universally useful way for any kind of trader to track their performance and perform standard deviation analysis on their activity.
at 11:51 AM
Oct 2, 2016
Many people use Quickbooks as a way to track their business activity. This becomes a valuable way to analyze business health and key metrics because of the granularity this Accounting software has. As such, I have put together a template/rough guide as to one way you may want to use it in order to track your sales rep performance.
at 1:08 PM
Oct 1, 2016
Welcome to another monthly review. So as you may know or not know, one of the things that helps me track where I am and help others see what kinds of things are available out there, is a review of all the things that have gone on to effect my earnings for the past month.
at 11:04 AM
Sep 24, 2016
Businesses, and small businesses especially, often have a messy inventory tracking system or none at all. Sometimes estimations are used that may or may not be accurate. This is an important asset that should be kept track of for a multitude of reasons. As such, the following excel template has been built for your convenience.
Sep 13, 2016
I have seen a lot of messy budget vs. actual excel sheets. So, I decided to build a nice model that does this kind of comparison tracking over time in the cleanest way possible. You will be able to compare all/any business lines that you wish no matter if it is revenue/expenses/what have you.
at 1:20 PM
Sep 11, 2016
I tried to take the most important aspects of a valuation that uses EBITDA multiple as its method to reach a given enterprise value. In doing so, the result has been this excel template. The idea here was to make something that the user could easily use as a plug in play once they have their own financial statements.
at 9:43 AM
Sep 3, 2016
I decided to give this excel model a fun name. It is the budget buster and the main use of this is to make vacation budgeting simple and visual. You can see where all your expenses sit as well as plan based on assigning %'s to each expense category.
at 11:00 PM
This is a fun tool that can be applied to all kinds of business situations. The basic premise is that you can use data from an input card and automatically pull specific fields from that data over to a clean database. Then, from the database it can be analyzed in many ways.
at 5:02 PM
Sep 1, 2016
Well I am really not in the mood to write right now, but will try to provide some value to you and insight on what my month was like. The reason why I should my online earnings each month is to motivate myself as well as give others some ideas on what is possible to do out there if you are working by yourself and have little or no starting budget for anything.
at 3:31 PM
Aug 31, 2016
I wanted to get a bit off track of all the excel models and trading for a bit with this. Creating wealth was one of the reasons I built this financial blog in the first place back in 2011 as I went into my final semester of college.
at 4:50 PM
Aug 30, 2016
Ok, not sure how to do this, but I have received a payment from a person for the trading course and the e-mail they have paid with is not allowing me to send anything to it. There is no other way to try to contact them so I am making a post about it hoping they will see. The payment was made around 2:30am EST.
at 5:03 AM
Aug 27, 2016
This is an fully functioning financial model for joint venture or individual cash flow analysis of a real estate deal. The power of excel is truly amazing. I have included two of my past excel templates within this real estate model. One of the previous templates you know as the amortization schedule. The other is not for sale, but is a fully functional depreciation schedule model with mid-month/quarter/year conventions, bonus depreciation, and all types of depreciation methods.
at 11:05 PM
Aug 25, 2016
This is a pretty interesting way to value cash flow that a unit produced and has implemented some very basic financial formulas in order to come to a number. Valuation is a very tricky thing and lots of things can go into trying to value cash flows.
at 10:01 AM
Aug 24, 2016
Understanding and making use of SaaS startup models in excel or google sheets can be difficult and end up wasting a bunch of time. For this reason, I have tried to make a template that has very clear assumptions for subscribers, revenue, costs, and financing.
at 2:02 PM
Aug 23, 2016
This excel sheet was designed to be versatile enough to show an amortization schedule for various loans and include the function of allowing for varying payment amounts and a variable interest rate over time. The other side of this model shows a bond schedule.
at 4:57 PM
This was a model that was initially built for a certain builder of a children's product that was sold across many specialty stores. The idea behind it is to be able to have super granular reporting that involved product cost changes through time and different % discounts through time and by store.
at 9:36 AM
Aug 22, 2016
What is going on everyone?! So I am going to start really putting the hammer into the value you can get from smarthelping.com and in order to do that my content is going to make a bit of a shift from forex trading to excel models and builds that help businesses with decision making, data cleaning/manipulation, visualization, and cash flow analysis.
at 7:14 AM
Aug 11, 2016
Super busy, but that is good thing. I am trying to get more time to write about my forex stuff as you have seen in the daily youtube videos.
at 7:32 PM
Aug 1, 2016
Welcome to another income report where I go over all my sources of money from various online endeavors and actually show the bank/source proof. This month was a little slower than last, but still very strong as far as time spend on money earned.
at 12:00 PM
Jul 22, 2016
Well it has been a pretty slow and uneventful week, but there was probably one big victory this week. I had one of my only days where I didn't meet the 3.5% daily profit target and closed out a trade that was about half-way there. This was pretty meaningful for my own trading style.
Jul 8, 2016
It's Friday at the beginning of the month and that means non-farm payroll (NFP). It came out this morning at 8:30am and the initial move in the first few minutes reversed nicely. I was able to scalp it for a quick gain and was stopped out with about 1% profit on balance.
at 9:14 AM
Jul 2, 2016
It's another month and as you know my tracking of online income has been going on since January of 2016. It helps me track what I am doing and what my numbers are. It's vital that anyone who has performance based income sources to do this as it keeps you on your game and understanding where you to to work more/where you are succeeding.
Jul 1, 2016
Well it's the first day of July. That means time for another income report for the month of June. However, the focus right at the moment is the last trading week as you have seen if you watch the smarthelping youtube channel. I have been scalping very short time-frame trades trying to catch runners and make a daily % goal and compound that.
at 10:40 AM
Jun 27, 2016
Well there has sure been a lot of workup over the new scalping thing on youtube. So, I want to be clear about what I am doing if I have not already been. Be aware the my trading balance is very very low and it's low for a reason. This kind of risk is not meant for a large portion of your net worth. However, it's fun to do and a good skill to perfect as long as you are not too emotionally tied.
at 2:14 PM
Jun 24, 2016
Well, I ended up legging long the gbp/jpy after what I though was the end of the Brexit move. Little did I know there was going to be another 1,000 pips in the gbp/jpy. This nearly took me out, but it has forced me to go back to the scalping system that I used to do. The reason I had stopped it was because the draw downs were too big. However, I think I can manage it if I stay more disciplined about how I grow it.
at 8:27 AM
Jun 19, 2016
Well, as you saw in the video this past Friday, I had put on some risk by legging out of the triangular arbitrage based setup that I had on from the previous week and that was primarily centered around being long the usd/jpy, gbp/jpy, and eur/jpy ahead of the Brexit announcement that happens this week. Luckily for me, as you will see in the video today, those pairs all opened higher by quite a bit right at 5pm est.. I was on my phone when the market opened and when I saw the equity in my account go to the 280's (up about 16% from Friday alone) I closed everything out right then and there.
at 10:15 PM
Jun 13, 2016
Welcome to a new week and a big week. We have the Fed Funds Rate and FOMC meeting on Wednesday. What that means is there will likely be some movement in the entire world market, including U.S. stocks and currencies. As you know my game is the currencies so that is where my focus will be.
Jun 6, 2016
As you will see in the trading video for forex, I had kept my initial 8-sided position on through the weekend and into today hoping for a 2% move up from the initial equity level of $242.50. I got it this afternoon and took that thing off like a thief in the night. Happy to finally get some new currency pairs going and still coming away with a profit on that last round.
at 2:59 PM
Jun 3, 2016
Well after about a month of working my most recent triangular hedged position, it became time for (for me anyway) to leg 25% of my position. I did it in the way of removing my cad/jpy profit of over 500 pips and adding a 0.01 gbp/usd long position. This was done ahead of NFP as you will see in the video live.
at 11:36 AM
Jun 2, 2016
The point of this is to help give people ideas on how to make extra money by using the Internet. I have been at it for a good 6 years and have finally started to make progress. This is not something that works over night and your success will be based on how well you manage your time and how well you work the right way. It will also take some luck.
at 12:43 PM
May 27, 2016
May 20, 2016
Happy Friday traders and I hope your week was strong. For me, as you may have been watching, has been up and down about $10 in the last 15 or so trading days. This is the slower part of the forex strategy that my account is using. There is some really bright takeaways from this.
at 3:07 PM
May 13, 2016
There is a lot of buzz and talk of quant trader or quantitative traders, but what does it actually mean and is this type of thing available for the average person to do. Firstly, quantitative trading can mean a few different things. What I will cover is what can be replicated by anybody and it involves the forex market.
at 2:10 PM
May 10, 2016
What a fun day. So after adding the e/g and e/a cross hedges and keeping the usd/jpy going, the equity has finally come back to nearly a break even on the initial position I started last week. Today was also the first day I had an actual standard deviation and bell curve measuring my equity change.
at 7:48 PM
May 9, 2016
Ok so where to start. I have been busy this weekend figuring out the best way to explain/demonstrate what it's like to trade the forex triangular hedging strategy in terms of statistical analysis. So, that is where I will start and then move to the trade activities of today as I did take off the bottom quad I have had on for a week.
at 12:32 PM
May 6, 2016
May 4, 2016
May 1, 2016
Well it's a new month and that means a new review of my financial picture. It has been exciting and my schedule is getting busier as the financial consulting work grows. As far as making money online goes, it has been a tough go for me over the past 5 years, but now things has just started to click.
at 2:45 PM
Apr 27, 2016
Well it was one of the best trading days I have ever had. I am not talking about the size of the profits, but in the way they were attained. This was a clean 4 day trade using the synthetic triangular hedges and I was able to pull in 2.5%. There was little stress and the profit came heading into FOMC so that means after taking this position off I was able to wait a few hours and get another position on to play the Fed number.
at 8:09 PM
Apr 22, 2016
Ok, well it was a really great end to the week after a very slow start and a small loss last week in the forex account. As you know I stayed in the gbp/cad and gbp/jpy cross synthetic hedges even though there was no profit at all last week and into Tuesday this week. I finally cracked though...
at 9:53 AM
Apr 16, 2016
Apr 8, 2016
Well the week was pretty slow until Thursday. This hedge I had on from last Friday was in the gbp/usd and I have not used this very much since starting the 8 sided forex hedging (using triangular arbitrage structures). So there was pretty much no movement so I ended up taking some risk Thursday night as I went to flip my positions around.
at 3:57 PM
Apr 2, 2016
Ok, it's April 1, 2016 so I went through and did all my earnings for March. As you know I am trying to help other people find ways to apply work theory so they can gain freedom in their own life and become happier doing what they live to do. This month my passive income from website earnings was flat, financial consulting work was up huge, and trading course sales were slightly up.
at 12:01 AM
Apr 1, 2016
It was a really nice end to the week. I got lucky with NFP as I took some risk going into the number. As you know I am willing to accept some risk if I get into it the right way. The only reason I am accepting this kind of exposure and not holding the entire 8 position hedge on at once is because I still am trying to trade myself up to enough capital to have all 12 on at once.
at 9:47 PM
Mar 25, 2016
Mar 18, 2016
Welcome to the end of the week and we had some gigantic forex moves after FOMC this week. The gbp/usd moved up 400 pips (I had no exposure there) and the usd/cad, eur/usd, nzd/usd, and usd/jpy all swung around 200-300 pips. This is when you have opportunity and I was actually on the wrong side of the move in the synthetic hedge. However, I turned it into a profit to close out the week...
Mar 16, 2016
Well it was a definite win on the FOMC statement. Fed basically saying they are scared to heighten rates (get those mortgages locked in!) and with this everyone is jumping back into the market as SPX skies to new heights. With the trading strategy I am using in forex, it ended up allowing me to take of some profits in the synthetic cross hedging positions and get a new one on to play the rest of the move.
Mar 11, 2016
Ok, this is a good opportunity for somebody to raise a good amount of starting capital for their trading endeavors. Tallinex (the ECN forex broker I am partnered with) is doing a trading competition that starts this Sunday March 13, 2016. They are giving away a total of $10,000.
Well, it was a damn fight to the end with my attempt to get back to $180. As you know earlier in the week I was within $5 at one point of getting to that target. I just need that much capital in order to have a slight amount of free margin and still use the synthetic forex hedges with two sets. (I really want to do 3 sets, but that will take quite a bit more profits.
at 1:10 PM
Mar 7, 2016
Well for all of those that have been following along closely for the past few months, you know I have been trying to get my forex account up to the minimum level needed to do the synthetic triangular hedges in at least 2 separate sets of forex pairs (meaning 8 total positions long and short).
at 12:16 PM
Mar 3, 2016
Well as you may have known from following the youtube trading videos, I have been legged out long gbp/usd and eur/usd for about a week and a half. This was part of my continued attempt to raise the capital in my account to a point that was able to do flat hedges between 8 currencies at once (including the crosses).
at 6:44 PM
Mar 2, 2016
MetaTrader 4 has long been accepted as the best trading platform around. However, it has not always been accessible to everyone. Since it is not available as a web application, you need to download the software. But the software was developed for Windows computers. Clients of brokers running Mac OS X have faced a lot of frustration, as a native MetaTrader 4 for Mac has been hard to find. Traders have resorted to installing parallel software to run MT4 on their Mac.
at 3:09 AM
Mar 1, 2016
Feb 23, 2016
Well looking at my 7 total positions, nothing has moved much over 40 pips with 2 forex pairs that have moved about 100 pips. This means not a lot of activity on my positions and most of it centers around the usd/cad, which has stood still after selling off a lot.
at 3:53 PM
Feb 22, 2016
Have you been asking for more flexibility in your trading accounts? Admiral Markets has answered the calls of many of its users. You can now use PayPal to deposit funds into your live trading account at Admiral Markets.
at 6:38 PM
Feb 16, 2016
There is one simple thing that any forex strategy or system implementation has to be cognitive of when being used. It's something that spans across any market and applies to anybody that is trading anything no matter if it is forex, options, futures, or people running a business.
at 12:51 PM
Feb 11, 2016
Alright, now that I have some time this evening to gather my thoughts, let's checkout what is happening. For options, no max profits have been hit. For forex, I still have the cad/jpy, usd/jpy, aud/usd and aud/cad position on. Also note I will be out Friday and back Sunday night to go over whatever happens tomorrow.
at 8:03 PM
Feb 10, 2016
Well late in the night and early this morning I figured out another way that the triangular arbitrage forex structure can be used to grind profits out of the currency markets. The new technique uses the same exact trade structure that I have been doing ever since the strategy was developed, however the enhancement are great as of late.
at 4:07 PM
Feb 9, 2016
It's Tuesday and the markets are pretty flat in the U.S. However, overnight there was some pretty big moves going on within the forex markets and I took some risk as opportunity presented itself. It got me back to my profit % target that I had from last week and then right after the move was over my dual triangular hedges were put right back on.
at 2:21 PM
Feb 5, 2016
Well the market is down big....huge. After failing to bounce. Obviously, my arbitrage spx/spy options style is 100% neutral until the market hits a max profit on one of these positions. So basically the short puts are getting close, but not there yet.
at 3:11 PM
Feb 3, 2016
Feb 1, 2016
Well it was an exciting day in forex and a so-so day in options as the U.S. market just kind of drifted higher (putting the spx debit spreads near max profit (80%). The biggest news is my final big aggressive and highly risky trade in the gbp/usd and nzd/usd that was pure directional to try and get my balance back to a point that allows for more complex strategies was taken off for about $10 of profit.
at 3:04 PM
Jan 30, 2016
Well, I was out on Friday, but it was a fun time on my mobile trading thing for Oanda. I ended up closing the cad/jpy hedge with a $5 profit on 0.01 for each leg. After the Bank of Japan decided to go negative on interest rates the usd/jpy flew up 200 pips and that is where I took the profits. I then reversed the pair and now it's just close to break even, but the key is that it does move enough to make profits and only a few hundred pips is needed.
at 5:05 PM
Jan 28, 2016
Jan 27, 2016
Traded through the FOMC number today. Nobody expected rates to change and they didn't. It will be another 6 weeks for the next rate announcement. Markets didn't move much going into the data release. Afterwards the market sold off all of its gains and basically all the option spreads I had on for the pair strategy didn't move much.
at 3:10 PM
Jan 26, 2016
Hey traders. It's Tuesday January 26, 2016 and later this week there is information coming out of the Fed that will likely cause the markets to break out of their dullness that they have been in. As for my forex position I got a little weighted on one of my legs within the triangular hedge between the eur/usd and aud/usd.
at 1:28 PM
Jan 22, 2016
Well it only took one week to figure out if this is worth doing or not. To me, the strategy that I am testing has no benefit to using weekly options over monthly options. The weekly's have more price volatility, which means more fill risk.
at 4:48 PM
Jan 20, 2016
Man, I know it's late today, but it was a great day with a lot going on. On the spy/spx pair options trading strategy, I had the put debit spreads in the SPX index options fill as the market crashed on the opening bell. I was then able to fill the opposing side for a tad better price as the market rallied back up a bit. This created about a $150 profit as I am trading minimum lot size for the strategy (1 spx to 5 spy).
at 11:47 PM
Jan 19, 2016
Today was good and bad. Let's go with the good first. I got filled on the weekly options for spx/spy pair trades with thinkorswim. So now I can start tracking how that moves on a weekly basis and this should improve the activity a trader has with the overall strategy and create more profits because you can now have monthly options on as well as weekly (this helps work around the dividend risk also for each quarter).
at 6:15 PM
Jan 12, 2016
Ok, well as you will see mid-way through today's video, I had to adjust my options pair trading strategy to account for the lack of liquidity in OEX options. They just don't trade so what the plan is going to have to be is to get into much more liquid underlying assets. The only thing that makes sense is to pair up the SPX with the SPY.
at 12:20 PM
Jan 7, 2016
Well the market is down big again today, but to the future trader, moves like this shouldn't matter except in the fact that it effect volatility and options pricing. For my forex positions, they really are not correlated much with the move in equities so it just doesn't matter at all to me. So I will tell you some thing that have gone on this week and how I am trading myself.
at 6:22 PM
Jan 4, 2016
If you have been watching how I trade, the directional price action of currencies and indices don't matter. It does matter a little bit in the way I manage risk in forex, but for options it really doesn't matter. The only thing that matters is how well are option credit and debit spreads on the SPX/OEX filling at the mid-price and is there any edge.