Oct 14, 2017

Interest Rate Swap Financial Model

The ability to enter all relevant assumptions about fixed and variable interest rates and see how the net present value (NPV) of each side changes becomes difficult to think about. Therefore, I have built a model to make things a bit easier to visualize.

Oct 1, 2017

5-Year Financial Model: Manufacturing with Customer Re-Purchase Logic

This model includes two logic strings I have not included before. The main benefit is more accurate cash flow planning and easily changing assumptions for the % of customers that re-purchase your product and for how many months in the future they will keep re-purchasing.

Sep 18, 2017

Template for Tracking Inventory at Multiple Locations

This is an excel build and it is different than the previous inventory management template I built in that you are now able to track various equipment / sku's across multiple locations instead of just at one location.

Sep 17, 2017

Automated Kiosk (Frozen Yogurt or Other) Financial Model

The craze of frozen yogurt or "froYo" hit pretty big in the past couple of years. It has died down somewhat, but the business model is interesting and there have been a few franchisors that popped up who specifically sell automated robotic like kiosks that you can invest in and put at various locations in your area.

Sep 9, 2017

Account Executive Driven Financial Model: 5-Year

Any business that drives its revenue by account executive (AE) quota production will benefit from this financial model. Instead of trying to tie revenue to a specific amount of customers or revenues per account, this drives everything right off of account executive revenue closed.

Aug 26, 2017

Jewelry / Retail Store Startup Financial Model

This is going to be the most pristine financial model I have done yet. The assumptions as it stands are for a jewelry store startup but you can easily change the wording in all the categories to represent any kind of retail business. It is a great way to build up a 5-year business case from scratch to ramping up full revenues.

Aug 13, 2017

Auto Repair and Tire Shop Financial Model

Well this is the industry I started my career in. Right out of college I went into a 10+ location auto repair & tire shop business. My main objectives dealt with financial analysis and tracking of performance metrics as well as financial statement maintenance. So, in light of that knowledge, my next piece of work I decided on was a financial model for Auto Repair and Tire Shops.

Jul 15, 2017

Time Tracker for Hourly Billing - Multiple Clients/Jobs in Excel

This is a very useful excel tool that I am going to be using myself. It will track my activity over time on a per client / job basis. It is something I had not tracked with much structure before (using notepad and pen/paper). This will make things much easier to manage going forward as well as give me another way to view performance rather than just tracking monthly income.

Jun 30, 2017

Website / Mobile App Financial Model with Recurring Revenue (5 Tiers + Free User Pool)

This is a highly robust financial model that will be useful for any business that has traffic and converts that traffic to users. Basically, anyone with an app or a website and a recurring revenue model.

Jun 20, 2017

P2P Investing: Financial Model

This is a growing industry and with that has given the average retail customer better access to such investing opportunities. I am talking about P2P lending platforms and P2B if you can find it. The idea is you invest in debt and make monthly returns. The facilitator is the platform and they will charge a fee for use.

Jun 8, 2017

Cleaning / Janitorial Services Financial Model

Thinking about getting into the cleaning and janitorial services industry and run your own crews? This financial model will help you plan out the revenues and expenses in a highly dynamic and user friendly way.

May 31, 2017

Quantity Demanded Vs. Actual: A Variance Model

This is a great tool for any excel user to use in order to show the historical amount of something that has been ordered by week, apply a growth % to it, and then see how that figure compares to your current figures over time as a % variance by total weekly quantity demanded and by product id.

May 8, 2017

Religious Organization Financial Model (5-Year)

Yes, this would be considered a non-profit, however such organizations require prudent financial models and planning as there are many operational / startup costs that happen and you need to know how long the organization will take to become sustainable as well as plan for various growth cases given attendances.

May 1, 2017

Equipment Rental Financial Model - 10 Year Projection

The equipment rental business is a cash flow business. You put cash out to get equipment, then you rent out that equipment to try and make the money back. There are a couple different ways to plan this out and I have put together a model that helps with such planning in a very dynamic and cash flow intensive way.

Apr 28, 2017

Car Wash Financial Model

So you want to get into the car washing business? Well it is probably more expensive than you thought, but assuming a lucrative location is acquired and no catastrophes happen it can be a viable business endeavor. In order for you to see what kind of scenarios will yield various returns / profits, this 5 year financial model has been built and tailored to the tunnel car wash business.

Apr 19, 2017

Dry Cleaning Financial Model & ROI Summary

The dry cleaning business has had a bunch of big names enter its space in the last year or so (as of 2017). So if you are looking to plan out the financial feasibility of such a project, this model has been built to accommodate your financial project needs all in one easy-to-use excel template.

Apr 15, 2017

SaaS Business Modeling - Customer Lifetime Value and CaC Payback

These are one of the two most difficult metrics in the SaaS planning and business modeling world. The excel template I have built here is a great tool for organizations to see how valuable their current customers are or how not valuable as well as get a more clear picture on their customer acquisition cost structures / MRR pricing and how it all inter-relates.

Apr 8, 2017

PPC Financial Model - Conversion % / CPC / Profit Feasibility

If you are looking at getting into the Internet advertising space, one of the business models that many people jump right into and fail at is PPC promotion. People fail at it for lack of planning and poor conversion %'s. I have put together a spreadsheet that helps plan out potential max CPC's you can pay and what kind of profits you are looking at with various scales.

Apr 4, 2017

Gantt Chart: Excel or Google Sheets with Man Hours or Revenue/Crew Style

This is the all-in-one template for any organization that has crews to manage and a sales pipeline to track. The database is simple user entry and from there everything populates dynamically and the visuals adjust accordingly.

Mar 23, 2017

Dynamic Salesmen Goal Tracking Model in Excel

I find that making models is increasingly important for general organization management. What I have gone and built today is a straight forward goal tracking template. The idea is to see how growth is changing on a monthly/quarterly/annual basis. The annual is included but I didn't talk much about it in the video.

Mar 7, 2017

Using Excel to Perform Survey Analysis

Excel is a great way to take responses from a survey and to complex statistical analysis. What I have shown in the video and in this excel template is the count formulas that are required to report on various sub-groups for a given question or multiple questions. There are a wide variety of ways to go about survey analysis, but this captures the fundamental mechanics of understanding your respondents answers.

Mar 4, 2017

Break-Even Financial Model

This is a great tool for any business or organization to use in order to see how much money they need to make in sales to break even. It will be effective and useful no matter what you are doing. The user interface is super easy and there are some nice charts to make things a bit more visual.

Feb 23, 2017

Cost per Unit Financial Model

For organizations or individuals that run a manufacturing or retail sales business, you may want to drill down to see how much each unit your are selling costs as a function of all your costs. This is a great way to forecast net profit and margins.

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.

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.