what's the idea?
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.
ModelShop models are not …
NOT free giveaways with a price attached
NOT pretend models
NOT one-sheet overviews
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
A serious attempt to answer the need for professional template models
Born of long financial modelling experience of answering specific commercial questions
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.
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:
the template Excel model, and
Lazuli Solutions Excel Add-In with useful functionality, and
a copy of our book “See-Through Modelling” which explains all the content in detail
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:
Firstly, you get a ready-made solution
Secondly, you get to use tried-and-tested Excel
Thirdly, the model is written in standardised format so it’s easy to understand
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.
What do you get by starting with a Modelshop base?
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
Comes with inputs
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.
What do you Get?
ModelShop Base models come with Model, Guide, Add-In and Book.
Model - This is an Excel model that is already working with dummy numbers.
Guide - a bespoke guide to making your base model achieve what you want from it.
Add-In - this is a Lazuli Solutions Excel add-in that gives you powerful functionality for working in your ModelShop model (*).
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”
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:
Work out which outputs/results are missing and add them in
Add your business inputs to the model
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.
Frequently asked questions
What is the best way of creating a model for my business?
There are three ways:
Building the model yourself
Commission a model
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?
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.
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.
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.
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.
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.
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.