Nov 19, 2017

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.

Nov 17, 2017

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.

Oct 28, 2017

Used Car Dealership Financial Model

Lots of guys and even gals are interesting in starting a business to sell used cars. It is a dream of many, but before you go wild, it is really important to hammer down the financial projections. Planning for various sales goals, startup costs, and being prepared is going to give you the best chance to succeed in the long run.

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.