Retail DCF Cash-Flow Forecast

I’m working through a corporate‐finance assignment that requires a full Discounted Cash Flow model for a retail company, and the sticking point is building a solid cash-flow forecast. I already understand the mechanics of discounting, but I need an experienced finance professional who can help me translate retail-specific drivers—sales per square foot, inventory turns, gross margin trends, seasonality, and working-capital swings—into a reliable five- to seven-year projection.

Here’s what I expect:
• A clean, Excel-based forecast module that plugs into my existing DCF template.
• Clear, sourced assumptions for revenue growth, cost structure, capex, and net working capital that make sense for the retail space.
• A brief walk-through (recorded or live) so I can follow the logic and defend the numbers in class.

The final file should be formula-driven, easy to audit, and flexible enough for sensitivity tests. If you’ve built retail DCFs before and can turn this around quickly, let’s get started.