Note: This is a simplified modeling exercise for practice only — not a real-world case study. Overview Salesforce is a leading cloud-based software company that provides customer relationship management and enterprise software solutions. Like many large technology companies, Salesforce uses stock-based compensation (SBC) as part of its employee compensation, making SBC an important component of its operating expenses and shareholders' equity. A Stock-Based Compensation Schedule forecasts SBC expense and tracks its impact across the financial statements. In this practice, you will project future SBC expense based on its relationship with revenue, then roll forward Additional Paid-in Capital (APIC) using SBC and other APIC activities. Learning Goals Understand how SBC Expense flows through the Income Statement and is added back as a non-cash expense on the Cash Flow Statement. Learn how SBC as a percentage of Revenue can be used to project future stock-based compensation expense. Understand how SBC contributes to APIC and apply the APIC roll-forward to calculate ending APIC. Link the resulting APIC balance back to the Equity section of the Balance Sheet.
Practice Stock-Based Compensation Schedule with interactive Excel modeling exercises in our Practice building supporting schedules for 3-statement modeling. module.
This hands-on modeling exercise helps you master Stock-Based Compensation Schedule through real-world Excel practice and financial modeling techniques.
Loading Excel interface...