Monthly cash flow forecast model. Needs to work off of monthly historic GL numbers for BS and IS. Numbers will be provided in Excel. Historic numbers from 2015 to April 2017 forecast monthly through Dec 2018 and annually for 3 additional years. Need to provide for typical assumptions/levers Sales Growth, COGS%, Labor Cost % (or labor $ / case) Overhead %, etc
G&A expenses off of current Jan-April 2017 actual with lever for inflation assumption.
BS driven by Inventory Days, A/R days outstanding, A/P days outstanding, historic fixed assets, etc.
The biggest challenge will be to forecast sales and COGS based on historic sales per customer per SKU. Data will be provided in excel format and needs to be incorporated into model.
You may work off of current model (WAY TOO COMPLICATED in it's current form) or you may create a model from scratch (or another existing)
Previous modeling experience required. I will need to see examples of other models created with references