Equity Schedule - Microsoft

Overview This Shareholders' Equity Schedule shows how Microsoft's total shareholders' equity changes over time and provides a framework for forecasting the ending equity balance. The schedule rolls forward Beginning Equity using net income, stock-based compensation, common stock issuance, share repurchases, dividends, OCI, and other equity activities. The model also includes an Accumulated Other Comprehensive Income (AOCI) Schedule to track the relationship between OCI and changes in AOCI. Historical trends are used to establish forecast assumptions for SBC, share repurchases, dividends, net income, and OCI. The projected Ending Equity represents the total shareholders' equity that can be linked to the Balance Sheet. Learning Goals Build a Shareholders' Equity Roll-Forward from beginning to ending equity. Understand how net income, SBC, stock issuance, share repurchases, dividends, and OCI affect total equity. Build an AOCI Schedule and understand how OCI affects accumulated equity. Use historical trends to develop assumptions for forecast equity movements. Link Ending Equity to Total Shareholders' Equity on the Balance Sheet.

Practice Equity Schedule - Microsoft with interactive Excel modeling exercises in our Practice building supporting schedules for 3-statement modeling. module.

This hands-on modeling exercise helps you master Equity Schedule - Microsoft through real-world Excel practice and financial modeling techniques.