MSc Economics and Finance student at Charles University in Prague. My projects cover financial modelling, valuation and portfolio analysis.
Ferrari credit application
Credit application for a hypothetical €1.1bn term loan to Ferrari N.V., with an integrated three-statement Excel model that tests the loan's effect on leverage and debt service.
Markowitz portfolio optimizer
Mean-variance optimization in Excel and VBA, with Monte Carlo simulation, the efficient frontier and the tangency portfolio.
Charter
Standardized Charting. Reads an Excel model and writes native, formula-linked charts back into the workbook, so every exhibit updates when the numbers change. Code written with the help of Claude.
- Kofola ČeskoSlovensko model: an Excel financial model of Kofola (PSE: KOFOL)
- Master's thesis: are today's AI and tech valuations justified? A reverse DCF on leading AI and tech companies