Instruction: Create a model that projects future financial performance based on variable input parameters. Include assumptions for revenue growth, cost percentage changes, and capital expenditure. Ensure the model is dynamic, allowing the user to easily modify assumptions and immediately see the impact on the forecast.
Context: This question assesses the candidate's ability to build complex, dynamic financial models in Excel, a key skill for strategic decision-making and financial planning in tech companies. The candidate must demonstrate proficiency in using advanced Excel features such as data validation, named ranges, and functions like SUMIFS, OFFSET, and INDEX/MATCH.