Simple Balance Sheet Forecast

Overview GourmetHarvest Inc. is a growing specialty food and beverage company, known for its premium packaged foods, artisanal snacks, organic teas, and craft beverages. The company prides itself on high-quality ingredients, unique flavors, and sustainable sourcing, appealing to food enthusiasts and health-conscious consumers alike. In this exercise, you'll build a simplified five-year Balance Sheet projection for GourmetHarvest, using three years of historical Balance Sheet and Income Statement data. By analyzing key working capital metrics—Days Sales Outstanding (DSO), Days Payables Outstanding (DPO), and Days Inventory Outstanding (DIO)—along with historical averages and P&L forecasts, you'll estimate future balances for Accounts Receivable, Inventory, Accounts Payable, and other assets and liabilities. Learning Goals Understand working capital metrics: Learn how DSO, DPO, and DIO impact the Balance Sheet and cash conversion cycle. Calculate historical averages: Compute average DSO, DPO, DIO, and other asset/liability ratios. Forecast Balance Sheet accounts: Use historical averages and P&L projections to estimate Accounts Receivable, Inventory, Other Assets, Accounts Payable, and Other Liabilities. Link P&L to Balance Sheet: Understand how revenue, COGS, and other P&L items flow into asset and liability projections. Key Concepts DSO (Days Sales Outstanding): Predict accounts receivable by measuring the average time to collect payment after a sale. DPO (Days Payables Outstanding): Predict accounts payable by measuring the average time a company takes to pay its suppliers. DIO (Days Inventory Outstanding): Predict inventory by measuring the average time inventory is held before being sold. Other Assets & Liabilities (% of Revenue): Use historical ratios to forecast miscellaneous accounts not directly tied to working capital. Balance Sheet Forecasting: Integrates P&L projections with working capital metrics to estimate future asset and liability balances.

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

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