Participants start with a blank Excel worksheet and learn an efficient way to input historical data from a pdf document. The financial statements of the case company are then analyzed, and the latest historical data is cleaned and prepared for the forecasting process. Ratios are calculated and assumptions for each line item in the financial statements are created. The full forecast model is then built. The forecasting techniques for several different items are examined separately, using dedicated Excel files, before being adapted for the case company.