+61(2) 9976 0909
contact@lentransolutions.com
Contact Us
LinkedIn
Resources Contact

Resource Centre

Improving industry modelling standards

At LMS we are committed advocates for improved industry modelling standards. Financial modelling is an unregulated industry and, as such, too often bad practices and ideas are passed around and proliferate. By providing free and regularly updated resources focused on best practice modelling solutions and guidance from our very experienced team, we hope to do our part to mitigate these poor modelling practices.

The Resource Centre has:

  • worked Excel examples and accompanying guidance for download
  • financial modelling tools and guidance on Excel add-ins, and
  • industry articles
All
Articles
Tutorials

Using Python with Excel – Part Four

Excel and Python for Financial Modelling: Installation Guide Building powerful models with Microsoft Excel and Python This article provides an installation guide for running Python through Excel. This is achieved via xlwings, which is a Python library and Excel add-in....
Read More

Using Python with Excel – Part Two

Using Python with Excel for Powerful Financial Modelling Solutions A practical guide to Python This article provides an overview on how we at Lentran Modelling Solutions use Python in conjunction with Excel in our financial models. Excel's strengths are its...
Read More
cashflow waterfall tutorial

Cashflow Waterfall

The aim of this tutorial is to provide an understanding of what the Cashflow Waterfall is and how to set it up correctly in a financial model. The tutorial will also focus on the cashflow available for debt service (CFADS)....
Read More
NPV & IRR tutorial

Net Present Value & Internal Rate of Return

The aim of this tutorial is to illustrate modelling approaches in calculating the Net Present Value (NPV) and Internal Rate of Return (IRR). The intended audience are those preparing valuation models who seek to evaluate the returns and profitability of...
Read More
multi-asset modelling

Multi-asset modelling

The aim of this multi-asset modelling tutorial is to illustrate how a financial model can be built to accommodate multiple assets or business divisions in a structured way that ensures modelling consistency between assets / divisions and efficiency in model...
Read More
Phantom links image

Phantom Links (External Links)

The aim of this tutorial is to illustrate a step-by-step solution to identifying and, if required, removing external links / phantom links in a received workbook. What's this tutorial all about? Here’s the scenario – you receive an Excel file...
Read More
Project Finance Ratios Tutorial

Project Finance Ratios

The aim of this tutorial is to illustrate what the most common project finance debt ratios found in loan documentation and term sheets are and how to set them up correctly in a financial model. The intended audience are those...
Read More
Load More

Sharpen your focus. Superior solutions from experienced modellers.