Nov 30, 2016

KPI Dashboard: Full Invoice/Product Analysis + Annual Charts

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

Insurance Pricing Help: Actuary Model in Excel

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.

Nov 19, 2016

3 Statement Financial Model for eCommerce

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

Nov 9, 2016

Financial Model for Apple Orchard

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.

Nov 7, 2016

Financial Model for Open-Pit Mining Operation

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.

Nov 2, 2016

October 2016 Monthly Review - New Highs

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.

Oct 26, 2016

Sales Pipeline Tracking Model: CRM for Excel

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.

Oct 23, 2016

Financial Model: Excel Template for Calculating Money Judgments and the Like

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.

Oct 14, 2016

Excel Searchable Drop-Down Menus and More Drop-Down Fun

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.

Oct 7, 2016

Position Tracker for Traders: Excel Template

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.