Modelling Tools

Effective way to test financial viability of new business ideas

Not sure which Model is for you? Ask our Model Wizard

Return to Models' Index > Overview

Quick RE Development Model

Quick Real Estate (RE) Development Model performs back-of-the-envelope funding and returns calculation for a new real estate development. By entering few parameters on-line you can download an Excel model or tool which based on your inputs spreads cash flows and calculates peak funding / break-even and expected returns for a new real estate project. It is free and you can re-run your inputs off-line as many times as you like. To gain access to more functionality including debt leverage and taxes calculations (as described below) you may consider purchasing full version for a modest fee.


£19.95

Read more

Our Quick RE Development Model allows you to -


Model Preview
  • Choose your own calendar start and stop dates for the project (monthly, quarterly or annually)
     
  • Input total footage of your project, acquisition (land), planning and construction costs required (the model will spread cash costs over user determined timeline)
     
  • Assume gross to net footage area and sale value for completed property; the model will automatically spread sale proceeds over user determined timeline
  • Assume amount of debt financing available (LTV) to fund acquisition, planning and construction phases (full version only), the model will automatically calculate drawdown and repayment schedules
     
  • Perform IRR, required funding, break-even and payback calculations
     
  • Compare pre- and post- tax cash flows and returns (paid version only)
     
  • Differentiate inflation factors for individual revenue and cost items (full version only), the model will automatically adjust key real terms input variable for user defined inflation factors for each forecast period

Additional inputs can be manipulated in both free and purchased versions of the Model in Excel as shown in Preview. Note that yellow fields represent inputs easily changeable in the purchased Excel file, without you needing to know how to code in Excel. Please refer to the Model's Manual to further details For further details regarding functionality of Free vs. Full versions.

Сlose

Preview Manual FAQ

Quick IRR Model

Quick IRR Model performs back-of-the-envelope IRR calculation for a new project. By entering few parameters on-line you can download an Excel model or tool which based on your inputs spreads cash flows and calculates peak funding / break-even and expected returns for your new idea. It’s free and you can re-run your inputs off-line as many times as you like. To gain access to more functionality (as described below) you may consider purchasing full version for a modest fee.


£19.95

Read more

Our Quick IRR Model allows you to -

Model Preview
  • Choose your own calendar start and stop dates for the project (monthly, quarterly or annually)
     
  • Assume time and investments required pre-launch as well as the launch costs
     
  • Drive business’s revenue by assuming customer acquisition / retention variables and average revenue per customer
     
  • Calculate margins and venture’s cash profile over time by assuming direct margins and overhead costs
     
  • Introduce exit (sale) value assumptions to yield IRR on going concern basis
     
  • Perform IRR, required funding, break-even and payback calculations
     
  • Differentiate investment terms and returns for founders vs. financial investors (paid version only)
     
  • Compare pre- and post- tax cash flows and returns (paid version only)
     
  • Differentiate inflation factors for individual revenue and cost items (paid version only)

Additional inputs can be set in the purchased version of the Model in Excel as shown in Example. Note that yellow fields represent inputs easily changeable or manipulated in the purchased Excel file, without you needing to know how to code in Excel.

Сlose

Preview Manual FAQ

Black Scholes Option Calculator

In applied finance, Black Scholes option calculator is one of those things that everyone knows what the inputs are but unlikely to remember the formula itself. Unless you trade options on daily basis, the calculator is rarely used. However, when it is needed a mad scramble to find one online begins. So we thought it would be helpful to add it to our Tools library. Presented without any further comment -

free Black Scholes option calculator.

DCF Calculator

We thought it would be helpful to add to our Tools library a compact file of DCF calculate. This file is an independent free extract from our standard models. The calculation of DCF is explained in all manuals of our models, so it presented without any further comment -

free DCF calculator.

Core Models Add-ons

Our Core Models - no matter how flexible - can not address every modelling need. To broaden functionality of our Core Models we came up with an idea of free Add-ons (requires registration). Each Add-on is a little Excel spreadsheet with new code overlayed over our Base Model's template with detailed instructions how to copy-paste new code into a working copy of a model in minutes. Current collection of add-ons includes modules for CapEx working capital management, Pro Forma capital structure modelling, Property Tax calculation and various examples of composite revenue assumptions.

Other Options

If you need more modelling horsepower try Models in our Main Library.

If you require a full turn-key modelling solution, please submit your request for a Bespoke Model.