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.