Ratios needed for a 'Percent of Sales Forecast' method Prepare a five-year ProForma Income statement

1. Create an Excel file that includes the last 5 years of income statements and balance sheets. You have a number of potential data sources some of which I describe below: Mergent Online (best source) You can get data from Reuters or Yahoo! finance Company’s Website - Financial information is usually provided under “Investor Relations” .

2. Estimate the ratios needed for a “Percent of Sales Forecast” method Prepare a five-year Pro Forma Income statements and Balance sheets . Please make sure that you create a separate worksheet where you input your assumptions for the forecast such as sales growth rate, etc.).