Lotte van Dijk
Financial Analyst | FP&A, Forecasting, Financial Modelling
- lotte.vandijk@example.com
- +1 555 0155
- Amsterdam, Netherlands
- linkedin.example.com/in/lotte-van-dijk
Professional summary
Financial analyst with seven years of FP&A experience in retail and logistics. Builds the budget, rolling forecast and monthly variance analysis for a €180 million omnichannel retailer, and works with commercial and operations leaders on pricing, store and investment decisions. Advanced Excel and SQL, with Power BI for reporting.
Work experience
Financial Analyst
Polderlicht Home BV, Amsterdam
Mar 2022 – Present
- Owned the annual budget and quarterly rolling forecast for €180 million of revenue across 34 stores and e-commerce, reducing full-year revenue forecast error from 6.2% to 2.4%
- Prepared monthly variance analysis of revenue, gross margin and operating costs against budget and forecast, with written commentary for the CFO and the board pack
- Built a three-statement model and DCF for a €9 million distribution centre investment (NPV €2.3 million, payback 4.1 years), which the board approved
- Developed a store-level profitability model that led to two store closures and five lease renegotiations, improving EBITDA by €1.1 million
- Replaced manual Excel consolidation with Power BI reports fed from the ERP through SQL, cutting board pack preparation from six days to three
Junior Financial Analyst
Oostkade Freight BV, Rotterdam
Sep 2019 – Feb 2022
- Analysed route and customer profitability for 220 accounts, identifying 18 contracts priced below cost; repricing added €640,000 of annual margin
- Produced the weekly 13-week cash flow forecast and tracked working capital, supporting a fall in days sales outstanding from 52 to 44
- Built driver-based cost models for fuel, fleet and labour with operations managers as inputs to the annual budget
- Prepared price-volume-mix analysis of revenue for the monthly management report
Skills
Planning and analysis: budgeting, rolling forecasts, variance analysis, price-volume-mix, scenario and sensitivity analysis
Modelling: three-statement models, DCF, NPV and IRR, driver-based models, unit economics
Tools: Excel (Power Query, INDEX-MATCH, data tables), SQL, Power BI, SAP S/4HANA, Anaplan
Reporting: board packs, KPI dashboards, management commentary
Education
MSc Finance
Amstelveld University, Netherlands
2018 – 2019
Thesis: working capital and profitability in European logistics firms
BSc Economics and Business Economics
Waalhaven University, Netherlands
2015 – 2018
Languages
- Dutch (native)
- English (fluent)
- German (conversational)