Instructions_x000D_
- _x000D_
- Please use this Excel workbook that includes actual financial data from The Gap, Inc. for the years 1987 – 1991, to create a 5-10 year financial forecast for the company (The Gap).
- Also, please write a narrative (no more than one page long, the shorter the better) justifying how and why you conducted the projections as you did.
- This assignment will be worth 25 points.
_x000D_
_x000D_
_x000D_
_x000D_
Logistics_x000D_
_x000D_
The first tab/worksheet in the Excel Workbook contains the actual financial. Please use those to create projections. Please project as much as you think you would need to conduct a valuation of the company, but do not actually conduct a valuation. I suggest that you at least project income statement and balance sheet items while also creating a CAPEX and depreciation schedule._x000D_
_x000D_
_x000D_
_x000D_
To help you out and get you started, I have include €œProFormas€, €œRatios€, and €œAssumptions€ tabs/worksheets in the Excel Workbook. While these tabs do not include formulas, they should provide a framework on how to proceed, what to project, and what to calculate._x000D_
_x000D_
_x000D_
_x000D_
The submission will consist of:_x000D_
- _x000D_
- Excel Workbook
- Narrative (Preferably in a separate document)
_x000D_
_x000D_
_x000D_
_x000D_
_x000D_
_x000D_
_x000D_
Good luck, and have fun!_x000D_
_x000D_
_x000D_
_x000D_
Click Order now to have a similar paper completed for you by our team of Experts.