For UPS and FedEx 2016-2018 yrs to model

This module describes methods commonly used to forecast financial statements. The module shows how to forecast a complete set of financial statements (for one or more years). The module concludes with a parsimonious forecast of select balance sheet and income statement metrics. A project can include both types of forecasts. We can use the full set of financial statements to analyze the company’s near-term future performance and position. We can then use the parsimonious forecast for longer-term forecasts as inputs for valuation models that estimate the company’s stock price. Importantly, use a spreadsheet for the forecasting process. The SEC website has “interactive data” for annual reports—these are spreadsheet-like arrays that can be copied into a spreadsheet. Also, many companies include on their investor relations page an Excel version of their financial statements. Define as many cells as possible with formulas, and reference income statement totals to the related balance sheet accounts. To balance the balance sheet, define the cash account to be equal to the difference between forecasted assets and liabilities plus stockholders’ equity.


  1. Model Assumptions and Inputs

    . The assumptions we use critically impact forecasted numbers. Be as thorough as possible in research and analysis in determining model inputs. The most critical assumption is ales growth. Before we begin, adjust any fiscal years to take care of the “13th week” (or 53rd week) problem. Then, use all the reported years’ sales numbers to compute historical growth numbers. Observe any trends. If the company reports segment sales, compute growth of each segment and compare it with total sales growth. We should forecast each segment separately if growth differs by segment. Read the company’s MD&A, the footnotes, and any guidance the company voluntarily provides. Obtain an industry report and, determine a consensus about sales expectations and the cost environment. As discussed in the chapter, we assume most costs (including COGS and SGA) will not deviate from their historical percentages unless there is evidence to suggest otherwise. Again, scour the footnotes. In the end, use sound judgment and remember that forecasted numbers are subjective.