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.