-Created pro forma financials to determine the ROI for potential new retail locations.

-Reported & analyzed key retail performance indicators, such as traffic, conversion, labor productivity, and profitability.

-Analyzed GM & EBIDTA performance for varying business units compared to LY, 2LY, and plan.

-Provided analytical support to the executive team, which in turn drove major investment decisions.

-Prepared both weekly & annual forecasts, as well as, prepared the annual budget.

-Created Excel macros that reduced payroll preparation by at least 50%.

-Managed & analyzed payroll for all 49 retail locations.

-Constructed excel formulas that reduced the preparation of monthly KPI reports by 20%

-Designed a retail pro forma model that projected EBITDA based on the quantity & timing of store openings.

-Examined the subscription market through extensive research and in person interviews.

-Created a robust forecasting tool that estimated cash flows of the subscription pools.

-Initiated a multilayered valuation of the firm using the market, private transaction, and discounted CF methods.