Summer Intern
- Understood growth modelling, and driving forces for domestic and international markets in flooring sector- Developed model to project the Profit & Loss metrics based on extrinsic factors, and internal decisions- Modelled future Capital Expenditure based on projected units sold & production equipment specifications- Modelled future OCF, FCF, FCFE, FCFF, to predict capital requirement, NPV, & valuation using DCF method- Implemented dynamic modelling, enabling changes to product portfolio, and served market segmentations- Implemented data slicing for output metrics, enabling analysis of smaller segments of the entire company- Worked around Pivot Tables limitations, using Power Query for data ingestion and model calculations - Improved usability by eliminating tedious & time-consuming data operations required using VBA scripts- Provides ability to model effect of changes in financial strategy within ~3 hours.