Balance Sheet Forecast - Apple

Overview In this exercise, you’ll project Apple’s Balance Sheet for 2019–2021 using historical data, schedules, and P&L projections. You will practice integrating cash flow, PP&E, revolver, and retained earnings schedules into your forecast. This exercise develops real-world financial modeling skills for forecasting assets, liabilities, and equity. While analysts often create 5-year projections in professional practice, this exercise uses JPMorgan estimates through 2021, resulting in a 3-year projection—a common approach for simplified exercises and public company analysis. Learning Goals Forecast Cash & Cash Equivalents using the Cash Flow Statement projections. Project Working Capital Accounts including Accounts Receivable, Inventory, Other Assets, Accounts Payable, Deferred Revenue, and Other Liabilities using Income Statement projections and growth assumptions. Forecast PP&E through the Property, Plant & Equipment schedule and model Commercial Paper/Revolver using the Revolver schedule. Calculate Common Stock and Retained Earnings with reference to the Retained Earnings schedule. Ensure Total Assets = Total Liabilities + Total Equity by completing the balance sheet and checking the balance identity. Key Concepts Current Assets: Includes cash, accounts receivable, inventory, and other short-term assets. Non-Current Assets: Assets like PP&E and long-term investments used for long-term operations. Current Liabilities: Obligations due within one year, including accounts payable, deferred revenue, and short-term debt. Non-Current Liabilities: Long-term debt and obligations extending beyond one year. Retained Earnings: Accumulated profits not distributed as dividends, updated using the Retained Earnings schedule. Share Repurchases: Reductions in equity used to return capital to shareholders. Stockholders' Equity: Sum of common stock, retained earnings, and other equity components. Balance Sheet Identity: Ensures Total Assets = Total Liabilities + Total Equity.

Practice Balance Sheet Forecast - Apple with interactive Excel modeling exercises in our Financial Statement Modeling module.

This hands-on modeling exercise helps you master Balance Sheet Forecast - Apple through real-world Excel practice and financial modeling techniques.