ModelShop financial modelling templates.

For finance professionals and analysts to solve specific problems in their models.

ModelShop offers a full array of ready-made financial modelling templates.

For downloadable templates click here >>

 

In detail

There are six different types of ModelShop template:

  • Business - accounting and finance templates

  • Modelling - how to organise, track and check your models

  • Knowledge - Excel, setup, review, productivity and VBA templates

  • Chart - useful chart templates

  • Full models - infrastructure, property and media templates

  • Specs - one sheet model specification templates

ModelShop templates provide the user with a fast way to gain modelling skills, finance knowledge, and tried-and-tested methods with ready-made solutions, including whole models for a variety of sectors.

All templates include a worked example, so they are easy to understand, and insert into your models.

Modelling questions

Here are some of the questions that ModelShop templates answer:

  • How do I build financial statements without getting into a balance sheet mess?

  • How do I model dividends efficiently?

  • How do I model indexation efficiently?

  • How do I model accounting depreciation with additions?

  • How do I build an interface between two models?

  • How do I avoid circular references?

  • How do I sculpt debt repayments?

  • What is the most efficient way to model VAT?

  • How should I structure the inputs in a model?

  • How to best carry out sensitivities without adding unnecessary complications?

  • How to add complete model checks to a model?

  • How do I get the most out of a cash flow waterfall?

  • How should I design operating costs?

  • How do I model tax depreciation?

  • What should I include on a profitability dashboard?

… and many more – go to ModelShop to find out.

Modelling answers

Here are some of the results of some of the ModelShop templates:

  • Build financial statements without ever losing control of the balance sheet

  • Build dividends declared and dividends paid in an efficient way

  • Build indexation that stands the test of time

  • Build accounting depreciation that doesn’t require ‘that horrible triangle’

  • Interface two models in an efficient and pragmatic way

  • Choose between three solutions to circular references

  • Sculpt debt repayments to get the most investor return for the given cash flows

  • Model VAT accurately with no extra complications to the cash flows

  • Structure the inputs in a flexible and logical way

  • Carry out multiple repeatable sensitivities all within the same model file and keep it simple

  • Make sure the model has secure, and functional error checks

  • Build a cash flow waterfall fit for purpose, and discover some new purposes

  • Build efficient operating costs that can withstand expansion over time

  • Build succinct and functional tax depreciation schedules

  • Build and organise the important elements on a profitability dashboard

… and many more – go to ModelShop to find out.

How does it work?

Browse ModelShop to find the solutions you are interested in. Simply buy and download the template.

Then use the template to learn how it works and replicate it in your model or insert the template sheet into your model and link it in.

Each template includes all you need:

1.       Logic flow

2.      Theory and method

3.      List of new inputs

4.      List of existing inputs for you to link into your model

5.      A worked example in Excel

If you have any questions, please don’t hesitate to get in touch.

Approach

All our templates are written in Excel and Word.  The Excel templates are coded in the FAST modelling language, for clarity and transparency.

All our templates are all tried-and-tested, and have been chosen to represent the most ‘elegant’ solution to each problem – this means a template that is both highly effective and simple.

Our clients

ModelShop templates have been used across many different industries, including infrastructure, private equity, media, telecoms, transport, energy and renewables, technology and property.

They have been used in numerous transactions and for successful investments for debt and equity funding, so are fully ‘bancable’.

They are the result of more than two decades of experience in financial modelling in the City of London with big four consultancy and investment banking, for blue-chip clients in the UK, Europe, Middle East and the US.

clients.png

Guarantee

If you can find a more elegant solution to the problem, Lazuli Solutions will refund you the cost.

Price

ModelShop templates vary in cost and some are ‘free’ – click here to find out >>