Dec 31, 2016

Financial Model for Salesmen Bonus/Effects in Excel

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 21, 2016

Data Analysis with Least Squares Regression Line

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.

Dec 16, 2016

Accounts Receivable and Payable Excel Template

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.

Dec 12, 2016

Risk Assessment Excel Template

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.

Nov 30, 2016

KPI Dashboard: By Product/Service Type, Client Type, and More

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.

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.

Oct 2, 2016

Using Pivot Tables and Summaries with Quickbooks Export

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.

Sep 24, 2016

Excel Inventory Management Template/Tracking Tool

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

Budget Vs. Actual Excel Template (monthly)

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.

Sep 11, 2016

Excel Template for EBITDA Multiple Valuation Method

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.

Sep 3, 2016

Excel Template for Vacation Budgeting (Budget Buster)

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.

Excel Automatic Database Creation with Input Card (Includes Conditional Drop-down Menu)

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.

Aug 27, 2016

Joint Venture Real Estate Model: Including IRR Hurdles/Equity Splits/More

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.

Aug 25, 2016

Explaining Gordon Growth Model for Valuation (Excel Template)

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.

Aug 24, 2016

5-Year SaaS Startup Model in Excel: Includes CAC Payback and Valuation

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.

Aug 23, 2016

Amortization Schedule Excel Template: Includes Loans, Bonds, Interest Summary

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.

Aug 22, 2016

Best Excel Scheduling Template

If you want a really clean and easy way to get all the time tables of your various business activities organized or plan out when employees have to do things, this excel scheduling template/model is great for all kinds of such uses.

Excel Models: New Service Line

What is going on everyone?! So I am going to start really putting the hammer into the value you can get from 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.