Modeling

Showing 1-9 of 13 results
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 ChevronRevenue & Growth

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. This article delves into this and provides a brief tutorial.

20 minute readContinue Reading
FinanceIcon ChevronRevenue & Growth

Getting to the Greeks: The Comprehensive Guide to Option Pricing

by S. Nathan Krishnan

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 ChevronRevenue & Growth

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 ChevronRevenue & Growth

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 ChevronRevenue & Growth

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
FinanceIcon ChevronRevenue & Growth

Forecaster’s Toolbox: How to Perform Monte Carlo Simulations

by Stefan Thelin

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.

22 minute readContinue Reading

Join the Toptal® community.