P&L Forecast with Historical Growth Rates

Overview This is a P&L modeling practice for a mid-sized D2C brand Acme Health & Wellness Inc. selling premium vitamins, protein powders, and functional beverages via e-commerce and select retail partners. Targeting health-conscious adults, Acme focuses on high-quality, science-backed products. Revenue has grown 6–7% annually, with gross margins stable at 55–56%—high due to its direct-to-consumer model. The company invests heavily in marketing and brand-building and maintains strong cash flow to support new products and selective retail expansion. This exercise guides you to forecast a P&L using three years of historical data, identify key drivers, calculate margins, and project the next three years, reinforcing a logical and consistent approach to financial modeling. Learning Goals Understand historical drivers: Identify key factors influencing revenue, costs, and expenses. Calculate growth assumptions: Compute average historical growth rates to use as assumptions for forecasting. Forecast financial performance: Apply these assumptions to project future revenue, COGS, operating expenses, and net income. Analyze key metrics: Practice calculating derived measures such as Gross Profit, EBITDA, EBIT, EBT, and Net Income. Key Concepts Revenue: Projecting sales based on historical trends and growth assumptions. Cost of Goods Sold (COGS): Estimating direct costs to produce goods or services. Operating Expenses: Forecasting overhead and administrative expenses as a percentage of revenue. Taxes: Applying a consistent tax rate to pre-tax earnings. Gross Profit: Revenue minus COGS, showing how efficiently the company produces its goods or services. EBITDA: Earnings before interest, taxes, depreciation, and amortization; a measure of operational profitability. Operating Income (EBIT): Earnings before interest and taxes, reflecting profitability after accounting for operating expenses and D&A. EBT: Earnings before taxes, showing profit after interest expenses but before taxes. Net Income: Final profit after all expenses and taxes, representing the company’s bottom line. Dividends: Forecast cash payouts to shareholders based on projected earnings and payout ratios. Balance Sheet Considerations: Track debt levels to calculate interest and support income statement assumptions. Historical Averages Method: Using average growth rates provides a simple yet reliable approach for forecasting stable businesses.

Practice P&L Forecast with Historical Growth Rates with interactive Excel modeling exercises in our Financial Statement Modeling module.

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