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.

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.

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.

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.