Modeling

Showing 1-9 of 14 results
FinanceIcon ChevronInvestors & Funding

Complex But Integral: An Overview of Real Estate Waterfalls

by Aaleem Jiwa

Waterfalls are an integral part of real estate investment terms, dictating the hierarchy of how cash is distributed to investors and the transaction’s sponsors. When structured correctly – with aligned incentives – they ensure that the deal is set up to achieve outsized success.

7 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Google Apps Script Tutorial for Mastering Macros

by Stefan Thelin

Google Apps Script may appear familiar to those with knowledge of Microsoft’s Visual Basic for Applications (VBA) language. However, Google’s coding offers more integrations and the ability to harness workflows seamlessly across spreadsheets, documents, and presentations.

11 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Why You Should Move to Google Sheets

by Stefan Thelin

Google Sheets offers a more collaborative and expansive approach towards spreadsheet management for finance professionals.

9 minute readContinue Reading
FinanceIcon ChevronInvestors & Funding

Paying It Forward: Understanding Leveraged Buyouts

by Martin Kemeny

Leveraged buyouts are among the most mythical, and highly-touted transactions on Wall Street. Yet, their success is predicated on successful comprehension of a business’ potential and negotiating the right terms for a deal

14 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Python and Finance – Power Up Your Spreadsheets

by Stefan Thelin

The Python language has the functionality to consign many a VBA-filled spreadsheet, held together with sticky tape, to the recycle bin. Its ease of use and suitability for iterative development lends well to finance-based workflows. We delve into this and provides a brief tutorial.

20 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Getting to the Greeks: The Comprehensive Guide to Option Pricing

by Nathan Krishnan S

Stock options are widely used in public and private markets, both as malleable trading tools and for employee compensation. Yet many do not understand the components behind how they are priced. This guide discusses what drives the behavior of call and put options and how they can be deployed within portfolio management.

15 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Exploring Excel's Get & Transform Functionality

by Ellen Su

Hidden in Excel and Power BI is a powerful data analysis pack named Get and Transform (previously known as Power Query). It is an ETL pack for cleaning and sorting raw data from a range of input sources, such as CSV and text files. This tutorial demonstrates how Get & Transform can help the data analyst both save time and uncover more insight.

10 minute readContinue Reading
FinanceIcon ChevronInvestors & Funding

Justifying Investments with the Capital Budgeting Process

by David Bradshaw

For a business manager, choosing what to invest in should not be an exercise of instinct. With capital budgeting methods, managers can appraise various projects simultaneously, with the end result indicating which one will have the highest impact on company value.

11 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Real Estate Valuation Using Regression Analysis – A Tutorial

by Daniel Barr, CFA, CAIA

Traditional approaches to valuing real estate can lean towards the qualitative side, relying more on intuition over sound rationale. Linear regression analysis, however, can offer a robust model for using past transactions in an area, to provide better guidance on property valuations.

21 minute readContinue Reading

Join the Toptal® community.