Financial Model for a Pawn Shop: 5 Year Forecast

If you want to start your own pawn shop or multiple pawn shops, it is important to plan out your margins, what you expect to sell, and the value of the things you are expecting to sell relative to their costs. This model allows you to plan out a 5-year projection of all those things so that you can see cash requirements and sales goals that your shop would need to hit in order to generate certain cash flows.

Google Sheets Use Case: Pipeline and/or Work in Process Management

This is one of the most helpful things that google sheets can be used for. It works by way of some conditional formatting and use of the today(), days, and networkdays functions. I have used this with a few clients and there are all kinds of variations you can get with it. I am making the base template version available for free.

Financial Tracking and Reporting Automation with Google Sheets

This was designed to be a general template / instructional guide on how to easily track financial performance over time with the input of 3 columns of data over time. Automated visuals are also included. The strengths of this model is in the timing controls and visuals.

LaaS - Lending as a Service Platform: Startup Financial Model (10 Year)

The cashless lending marketplace has become a huge hit all around the world these days. People love not going through banks and investors like to be able to put their money to work in platforms that facilitate peer2peer lending. So, I have put together a financial model that helps anyone looking to start a LaaS (lending as a service) platform plan out their first years in business and run some sensitivities.

Recycling Business - 10 Year Financial Model

If you were looking to improve the environment and also make a living at the same time, you could end up running a recycling business. It will take some sort of initial investment and to plan out what the possible returns could look like, this financial model was built. It can go for less than 10 years as well, with a variable exit month.

Google Sheets Automated Tracking and Reporting with a Database

I run into a lot of clients that need database management within google sheets. Primarily because it is free to use and multiple users are able to get in and work on the document at once. Also, you can keep certain tabs / ranges protected from any e-mails you want. Also, g sheets has some really powerful formulas and scripts that provide additionally functionality that excel just doesn't have.

10 Year Financial Model for Hair Salon / Barbershop

This type of business model presented a lot of reasons for needing a nice way to account for all the moving parts. Often times, a salon is going to have multiple revenue streams and multiple items in each revenue stream. Also, you may not want all of them to start at once. This financial model has accounted for all of those things.

Financial Model for a Gym/Fitness Center Startup

When you plan on starting any business, it is really important to plan. A financial model is really useful in this case because there are so many moving parts in business cash flows. Specifically, a gym or fitness center is going to require a heavy investment and probably involve financing as well as a runway for ramping up. This excel template will forecast for up to 10 years and allow for an exit in any of those months.

IRR Based Investment Comparison Model in Excel

This IRR template was designed for CFO's or anyone that is reviewing projects that have an initial investment cost and projected future cash flows. The goal was a super simple user input interface and easy analysis that is automated per the assumptions entered. You can project out for up to 20 years.

Simplified Inventory Management Tool in Excel (in/out)

I have built more complex and advanced inventory tracking tools and templates for a single location as well as multiple locations in the past. The single location was more about determining cost of goods sold and looking at the accounting / financial impact of inventory movement. The multiple locations version looked more at simply the unit movements to and from the main warehouse to various locations and inter-movements to and from all locations and the warehouse.