Modeling

In the “new normal,” how should business leaders ensure that their business is well-equipped to survive and then thrive? Scenario analysis is a handy tool: How are scenarios built and translated into financial projections?

Tesla shares are up 60% over the past 12 months—performing relatively well even with the impacts of the coronavirus on the broader stock market (S&P 500 down ~11% over the same period). We dissect the drivers and unpack what the market is building into TSLA’s valuation.

When a cash flow statement model doesn’t balance, it can cause immense frustration and wasted time. The root cause of this problem most commonly resides in models being built with inconsistent and contradictory data sources.

Looking to make your financial models more effective with better data visualization? Design principles can be effective tools in corporate decision-making.

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 outsize 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.

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.