P&L Forecast - Apple

Overview In this exercise, you'll step into the shoes of a financial analyst at Apple, building a Profit & Loss (P&L) projection using historical financial data from 2019 to 2021. Set against the backdrop of Apple's iPhone 11 and iPhone 12 product cycles, continued growth in Services, and the business disruptions and shifts in consumer demand during the COVID-19 pandemic, this exercise challenges you to analyze historical performance and develop forward-looking financial projections based on period-appropriate assumptions. Using historical growth rates, margins, interest assumptions, and depreciation schedules, you'll forecast revenue, costs, operating expenses, taxes, interest, and D&A, tracing their impact through EBITDA, EBIT, EBT, and Net Income. You'll also build supporting interest and D&A schedules and link them to the Income Statement, developing a practical understanding of how a public company's financial statements translate into an integrated financial model. Learning Goals Forecast key P&L line items: Project Revenue, Cost of Revenue, Gross Profit, R&D, SG&A, and Taxes using historical financial performance and appropriate growth and margin assumptions. Model interest expense and income: Build an Interest Schedule and link it to the Income Statement to forecast financing costs, interest income, and their impact on earnings. Build depreciation & amortization schedules: Forecast D&A for property, plant, and equipment (PP&E) and intangible assets, and link the results to the Income Statement. Calculate key profitability metrics: Derive EBITDA, EBIT, EBT, and Net Income to understand how operating performance and financing costs flow through to bottom-line profitability. Connect supporting schedules to the P&L: Understand how capital expenditures, asset balances, interest rates, and cash and debt positions influence financial projections. Analyze historical performance in context: Evaluate Apple's revenue growth, profitability, and expense trends during 2019–2021, considering product launches, Services growth, and the effects of the pandemic. Key Concepts Revenue: Forecasting sales using historical growth rates and assumptions informed by Apple's product cycles and Services business. Cost of Revenue: Estimating the direct costs associated with Apple's products and services. Gross Profit: Revenue less Cost of Revenue, providing insight into Apple's product mix and gross margin performance. R&D and SG&A: Forecasting research and development and selling, general, and administrative expenses using historical trends and revenue-based assumptions. EBITDA: Earnings before interest, taxes, depreciation, and amortization, used to evaluate operating profitability before these items. Operating Income (EBIT): Profit after operating expenses, including operating depreciation and amortization, but before interest and taxes. EBT: Earnings before taxes, reflecting profitability after interest and other applicable non-operating items. Net Income: Bottom-line profit after expenses, non-operating items, and taxes. Depreciation & Amortization (D&A): Forecasting the allocation of depreciable and amortizable asset costs over time and linking the resulting expense to the P&L. Interest Schedule: Forecasting interest expense on debt and interest income on cash and investments, with appropriate links to the Income Statement.

Practice P&L Forecast - Apple with interactive Excel modeling exercises in our Financial Statement Modeling module.

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