Percent of Sales Forecasting - in Excel.

  Go to the Atom Finance (Links to an external site.) website and select a company of your choice to evaluate. Using the financial data tab, transfer the information from the income statement for at least two years to a new Excel workbook. Use the attached document as an example. Calculate the Percent of Sales Forecast for the subsequent year in column B of your spreadsheet. Submit the spreadsheet. Submit a 1-2-page summary of your findings. Include the definition and purpose of using the percent of sales forecasting method. Also include ideas regarding other important statistical calculations or forecasts that would help with decision making.