Modeling

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. This article delves 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.

One of the most important and challenging aspects of forecasting is handling the uncertainty inherent in examining the future. Every CEO, CFO, board member, investor, or investment committee member brings their own experience and approach to financial projections and uncertainty, influenced by different incentives. Oftentimes, comparing actual outcomes against projections underscores the need to explicitly recognize uncertainty. Monte Carlo simulations are an extremely effective tool for handling risks and probabilities, used for everything from constructing DCF valuations, valuing call options in M&A, and discussing risks with lenders to seeking financing and guiding the allocation of VC funding for startups. This article provides a step-by-step tutorial on using Monte Carlo simulations in practice.