Retained Earnings Schedule

Note: This is a simplified modeling exercise for practice only — not a real-world case study. Overview Microsoft is one of the world's largest technology companies, with businesses spanning cloud computing, software, personal computing, and other technology services. Like other public companies, Microsoft retains a portion of its earnings to reinvest in the business while distributing a portion to shareholders through dividends. A Retained Earnings Schedule tracks how a company's retained earnings change over time based on Net Income and Dividends. In this practice, you will use historical dividend payout ratios to project dividends and roll retained earnings forward for the projected years. Learning Goals Understand how Net Income and Dividends affect Retained Earnings. Learn how the dividend payout ratio can be used to project future dividends. Apply the Retained Earnings roll-forward to calculate ending retained earnings for projected years.

Practice Retained Earnings 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 Retained Earnings Schedule through real-world Excel practice and financial modeling techniques.