Tutorials Archives

Balance Sheet Projections Guide

Imagine that we are tasked with building a 3-statement statement model for Apple. Based on analyst research and management guidance, we have completed the company’s income sta ...

→

Guide to Forecasting the Income Statement

Forecasting the income statement is a key part of building a 3-statement model because it drives much of the balance sheet and cash flow statement forecasts. In this guide, we ...

→

Modeling Stock Based Compensation (SBC Expense)

Q: I was just told that it is common in the software industry to exclude stock-based compensation (SBC) expense from earnings per share (EPS), effectively treating it as a non ...

→

Accretion/Dilution M&A Model (Part 1)

Note: you can find a more recent version of this lesson by clicking here. This article is part one of a two-part series. Click here for part two. One of the core models inves ...

→

Quick Lesson: Cash Flow Statement, Part 1

In this video, we'll build a cash flow statement model given an income statement and balance sheet in Excel. The accounting here is a simplified presentation of how the three ...

→

What's New