About ModelShop

what's the idea?

Artboard 1@0.5x.png

The process is simple:

1. Choose a high quality financial model template in Excel

2. Download it

3. Adapt it to meet your needs

Our models are:

  • best-practice, professionally built, bankable and transparent

  • made with serious functionality, and simple formulae

With our ready-made template Excel models you will get to destination quicker, and it will cost you less.

We call it ModelShop.

Show me the ModelShop models that are available

ModelShop models are not

  • NOT free giveaways with a price attached

  • NOT pretend models

  • NOT light-touch

  • NOT one-sheet overviews

  • NOT over-priced

Show me the ModelShop models that are available

ModelShop models are

  • Real-life financial models

  • Excel financial models that answer precise existing business needs

  • Build to best-practice standards

  • Transparent, with simple formulae

  • Built by professionals

  • With clear separation between inputs, calculations and outputs

  • Bankable - i.e. they can be used to raise finance or investment

  • Detailed company or portion of company appraisals

  • Tried-and-tested

  • A serious attempt to answer the need for professional template models

  • Correctly-priced

  • Born of long financial modelling experience of answering specific commercial questions

Show me the ModelShop models that are available

Modelshop guarantee?

Lazuli Solutions guarantees that ModelShop models will provide a nearly-complete answer to the commercial questions you have.

If this is not the case we will do all we can to make sure that this is the case.

We only require you to agree that what we add to your model is then fully available to everybody else.

Show me the ModelShop models that are available

What is our mission?

Our mission is to provide template Excel models for specific commercial situations.

how does it work?

ModelShop models come in base template format for your industry, already populated by dummy numbers.   The models are ready to go, depending on your requirements.

Included in the price is:

  1. the template Excel model, and

  2. Lazuli Solutions Excel Add-In with useful functionality, and

  3. a copy of our book “See-Through Modelling” which explains all the content in detail

Show me the ModelShop models that are available

 

Why are Modelshop Models good?

You will spend no time creating the basic infrastructure of your model.

You will spend all your time concentrating on how your business works.

ModelShop models marries three important realities that reflect current trends in business and society:

  1. Firstly, you get a ready-made solution

  2. Secondly, you get to use tried-and-tested Excel

  3. Thirdly, the model is written in standardised format so it’s easy to understand

Show me the ModelShop models that are available

 

How ready are Modelshop Models?

ModelShop models are pragmatic solutions to precise commercial situations. As such, we believe they are ready-to-use. We also accept that they may need some work to take you to summit. That is why our ModelShop models are appropriately priced.

ModelShop models get you to base camp, fast. At base camp you have all you require to make your successful ascent to summit.

Show me the ModelShop models that are available

 

What do you get by starting with a Modelshop base?

abc-trek.jpg

Let's use the mountaineering analogy and start at 'base camp'.

At base camp the team is all present, as is all the equipment.  What is missing is the final plan for the ascent to the summit and who will carry it off.   

The final plan depends on local climactic conditions, the physical and mental well being of each the team members and other information not previously available from the local Sherpas.

But being at base camp feels good after months, if not years, of planning.

So, what do you get at modelling base camp?

  • You get a structure that suits your industry

  • You get loads of example code that you can reuse

  • You get a whole raft of basic infrastructure to which you can add your own

  • You get a system that works

  • You jump start your ascent to the summit using proven technology and tools

  • You get calculations full of numbers so that you can clearly see how the calculations work

  • You get a guide for your ascent from base camp

  • You get a sounding board to better plan your ascent

  • You get a system that is based on the Excel that you already know

  • You get a standardised system

  • You get a tried and tested system

  • You get a system that is recognised in the market

  • You get simple straightforward formulae

  • You get a book that describes and classifies each of the manipulations

  • You get live labelling

  • You get a tried and tested sensitivity analysis tool

  • You get compiled central checks and a method for adding your own

  • You get a simple way to compare your changed outputs to those before you made a change

  • You get the choice on how to proceed to the summit

  • You get a fair price

  • You get to use the Made Model in whatever way you wish

  • You get to adopt a working strategy for ascent to the summit

So, how would we describe a ModelShop model from base camp?

  • Tried and tested

  • Limited in scope

  • Simple

  • Modular

  • Excel

  • Standardised

  • Transparent

  • Clear

  • Organised

  • Structured

  • Updatable

  • Maintainable

  • Customisable

  • Focused

  • Comes with inputs

Show me the ModelShop models that are available

 

Pricing

We think the price of our ModelShop models should be low. This is about offering a new type of product for a new breed of financial modellers.

What makes it interesting is that you will have plenty of budget left for the completion of the model.   If you finish it yourself then you can save the residual budget for other purposes. You may find that the model works straight off.

Lazuli Solutions can also offer help to plan how to finish your model.   See below What are we starting with? for further detail on what the offer includes.

Show me the ModelShop models that are available

 

What do you Get?

ModelShop Base models come with Model, Guide, Add-In and Book.

  1. Model - This is an Excel model that is already working with dummy numbers.

  2. Guide - a bespoke guide to making your base model achieve what you want from it.

  3. Add-In - this is a Lazuli Solutions Excel add-in that gives you powerful functionality for working in your ModelShop model (*).

  4. Book - A copy of See-Through Modelling which is the book written by Dominic Robertson and describing all the theory about the base model, but also the methods to complete your model (*).

* please get in touch here to claim your copy of “See-Through Modelling” and the “Lazuli Solutions Excel Add-In”

Show me the ModelShop models that are available

 

What do i have to do to finish the model?

To finalise your model from base camp you need to do two things.   In order:

  1. Work out which outputs/results are missing and add them in

  2. Add your business inputs to the model

Show me the ModelShop models that are available

 

The model comes with inputs

What does this mean?   How useful is this?

This is extremely useful as it constitutes a worked example.

Worked examples are the fastest way of learning. They mean that up front you don’t have to understand each line of code. You can jump straight to what goes in and what comes out.

Then later you can easily understand the lines of code in between.

Show me the ModelShop models that are available

Frequently asked questions

What is the best way of creating a model for my business?

There are three ways:

  1. Building the model yourself

  2. Commission a model

  3. ModelShop models

The 'best way' depends on your individual circumstances.   For most people, and given all the time and money, we think that starting at base camp and then working out a plan for the ascent is actually the most valuable and instructive method.

The mountaineering analogy works here.   For most people doing it all alone is not possible.  Being flown to the summit is fun but a limited experience.   So planning with proper guides from base camp is the best option.

We do think that you have to get your hands dirty somehow to develop that intuitive understanding.   But why re-invent the wheel?

Show me the ModelShop models that are available

How should you make your model bespoke?

To make the model work for you just follow our simple advice.

When learning something new, particularly something that involves numbers, the fastest way is to look at a worked example. That’s why the model comes full of dummy numbers.

If you want to reuse an existing component then follow the Create, Make space, Paint process. If you want to use a component that you have created then similarly follow the same process.

Show me the ModelShop models that are available

What about auditing a ModelShop model?

The process for model auditing is most often required by lenders prior to authorising a loan of substantial size. Often this process costs more than the model itself so should only be considered necessary if required by lenders.

Show me the ModelShop models that are available

How bankable are the ModelShop models?

ModelShop models are bankable. This means you can use the models to negotiate with a bank about a potential loan. The models can form the basis for your commercial relationship with the bank and can be exchanged with this in mind.

Show me the ModelShop models that are available

What about adding my own logic to the model?

That is absolutely fine and we can give you free advice on how to do this. Just get in touch with us.

Show me the ModelShop models that are available

What utilities come with the model?

A Lazuli Solutions Excel add-in with useful functionality and a copy of our book called “See-Through Modelling” is available after purchase of the model, by getting touch here.

Show me the ModelShop models that are available

What are the benefits of a ModelShop model?

The first big-time benefit of a ModelShop model is that you don't have to build the basic model infrastructure.   Instead you have a working, tried-and-tested system.   This means you can concentrate on how to make it work for your business.

Show me the ModelShop models that are available