Feb 15, 2017

Billable Hours Performance Tracking for your Firm

The idea here is to create somewhat of an environment of competition in your firm as well as accountability tracking among your consultants / employees. This excel template is very easy to use, has no macros to worry about, and offers straight forward analysis within a 52-week time-frame.

Feb 10, 2017

Excel to Find Correlation Between Two Things

Well things are just staying super busy, but I am trying to find a good couple hours this morning to get content out so today we are going to talk about the excel function "correl". It is a great function that can be useful to anyone trying to determine if there is some kind of relationship between two things.

Feb 2, 2017

January 2017 Review: Lifetime Highs

I do these monthly income reports for a few reasons. It gets me focused on the numbers rather than a specific situation. It is good for a freelancer because growth is always the direction you are facing. Having said that, the numbers were good for January as I have made more this month than ever before.

Jan 26, 2017

Can You Make Money with a Food Truck?

*Note, cash flow returns have been updated to account for financing / operational cash flow differences and you will now have a leverage return % and non-leveraged return. Note if you set financing at 0% these returns would be the same.

I have been struggling to think of a new financial model to do. That is why I have been silent on this front for a few weeks here in January. Today there was a decent gap in time so I went for it and created this clean 10 year cash flow model for a food truck.

Jan 7, 2017

Mobile Home Park Financial Model

Turns out that it pays to run a mobile home park / community. There are a lot of reason to buy an existing community rather than build your own, but if you really have a vision than go for it. The cap rates on these things are healthy for those looking to exit, but still offer buyers plenty of room to make a return on their investment. Overall, it is a very interesting prospect for those willing to dive in.

Jan 1, 2017

How to Love Working and December 2016 Review

So yes this month I did hit a new high in my financial consulting endeavors. It has taken many years out of college to get here, but the point is that it is possible. You will see the numbers in the video, but now that my numbers are starting to back up my ideas, I want to focus more on that part of this whole thing.

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.