+61(2) 9976 0909
[email protected]
Contact Us
Facebook
Twitter
LinkedIn
  • Home
  • Who We Are
  • Expertise
    • Financial Modelling
    • Training
  • Our Work
  • Testimonials
Resources Contact

Author: Theo West

Home Articles Posted by Theo West
9 posts, 0 comments

Using Python with Excel – Part Four

May 9, 2019No CommentsTheo West
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 Three

May 5, 2019No CommentsTheo West

Integrating Python within Excel. Python is used for performing data analysis procedures at the back-end while Microsoft Excel remains the front-end interface with the user.

Read More

Using Python with Excel – Part Two

April 29, 2019No CommentsTheo West
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

Using Python with Excel – Part One

April 10, 2019No CommentsTheo West

In this mini-series – Using Python with Excel – we aim to highlight how Excel can be enhanced by the programming language Python to solve big data or complex analytical challenges.

Read More
cashflow waterfall tutorial

Cashflow Waterfall

March 10, 2017No CommentsTheo West
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

March 10, 2017No CommentsTheo West
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

March 10, 2017No CommentsTheo West
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)

March 9, 2017No CommentsTheo West
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

March 8, 2017No CommentsTheo West
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

Sharpen your focus. Superior solutions from experienced modellers.

ABOUT US

  • Our Senior Team
  • What We Believe In
  • Blog
  • Resources
  • Contact

FOLLOW US

Facebook
Twitter
LinkedIn
RSS
Log InPrivacy PolicyTerms And Conditions
© 2016 Lentran Modelling Solutions Pty Ltd. ABN 66 615 474 523. Site By Design Fox