Modeling

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.

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.

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

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

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.

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.

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.

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.

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.