• 046 04/24/2016

    The Business Development video series on this website uses real data to build a financial model for ASM, which effectively makes the series a startup financial model tutorial. When I launched this website in July of 2013, my professional experience analyzing companies was limited to large public or private businesses. I did not have any prior exposure to startups, but that started to change rapidly as I began contemplating this project. Since ASM went live, I have found myself interacting with entrepreneurs and VC investors more frequently. It's been a terrific experience to gain this new perspective.

    To share the story I am including information detailing the process of building an online following. I still recall uploading the first videos and Excel templates thinking that the website would take off immediately. I was terribly wrong as you can see by the first year of Google Analytics data captured in the image below.

    ASM Google Analytics Year One


    In the first year I had a total of ~8,000 visits, which was, needless to say, frustrating. But today the website generates that much traffic in a month, and has developed a user base across the globe. The image that follows, also taken from Google Analytics, shows how ASM's reach has expanded.


    ASM Google Analytics Geo View


    How did we pull it off? The videos provide some of the resources and strategies employed. This is not the focus of the material, but I believe it helps to have context. The time required to gain traction online is relevant as you look to the future and start to develop financial projections.

    I also believe it is telling that the first financial models I developed for ASM were not at all useful. My approach was off, and at the time I didn’t really know what my objective was. Beyond providing financial modeling instruction, there was no business plan. This was new territory, and I point out why the first models were not useful in an introductory video.

    By the time I started developing useful models for this video series I had 43 months of expense data to work with. The video-driven instruction will demonstrate how this data was collected and organized. As an example, the data is first provided in the format visible below:


    ASM Startup Expenses


    With the information labeled on the appropriate worksheets, the video instruction continues by explaining how formulas can be used to organize and track the data by period and expense category:


    ASM Startup Expenses


    The objective, of course, is to establish a revenue model that will cover the cost of maintaining ASimpleModel.com, and permit investing greater resources into generating more content and developing better technology. In March of 2016 we relaunched the website with this objective in mind. Whereas the old website simply provided the means to share content, the new website incorporated the following features:

    Membership Profiles

    Quizzing Platform

    Content Paywall

    The decision to incorporate a quizzing platform was influenced by several texts I had read on the science of effective learning practices. Retrieving knowledge from memory is essential to the learning process (click HERE for more information about the science of learning), and my hope was that by charging primarily for quizzing it would be possible to keep a lot of the instructional content available free of charge. But putting some content behind the paywall also encourages users to explore the quizzing platform, so for the time being as new content is added to the website it will be placed behind the paywall. We are, however, attempting to keep prices low and currently charge $3 per month (cancel anytime). It’s slightly cheaper if you subscribe to the annual plan, and the website benefits substantially from this plan over the monthly plan (the video series explains why).

    What’s exciting about this is that we can start incorporating a revenue model in our financial projections. I hope you will find it sufficiently intriguing and subscribe to learn more about this process. This video series is essentially a live entrepreneurial experiment. Whether it succeeds or fails you will get to witness it via the financial models and video instruction uploaded. It should be interesting.

     

 



 



  • 044 04/09/2016 Excel: =IRR() vs. =XIRR() (continued...)

    I thought it would be worthwhile to provide a follow up to my original post on this topic. In my conversations with business owners this discrepancy gets a lot of attention on account of the critical role these figures can play in a transaction (as my previous post explains).


    If you have not read the previous post I would suggest doing that now before proceeding with the material below. You can find it here: Excel: =XIRR vs =IRR

    The objective with this post is to demonstrate with the video that follows precisely what causes these differences. One thing to keep in mind as you watch is that the =XIRR() formula annualizes the IRR, whereas the =IRR() formula will return the rate of return for the period (month, quarter, year, etc.). In other words, if you measure the IRR for one month using the =IRR() formula the function will return the IRR for that month. The same exercise with the =XIRR() formula will return the annualized IRR. If this has not yet perfectly settled, don't worry, it is explained at 3:20 in the video below.
     
     
    The Excel template is available HERE.

    Click HERE to have posts like this one sent directly to your inbox.

 




 



Models are:
 
A) really boring
B) pretty sweet
C) super important
D) somewhat easy
E) kind of hard
F) fun
G) all of the above

 

 


*Answers a, b, c, d, e, f and g are all correct.