Kim S.

Creation of the integrated financial model for a public transport tender in North Rhine-Westphalia (volume approx. €130 million) for bid pricing, incorporating all commercially and contractually relevant parameters (operating costs, personnel ramp-up, vehicle financing, investment planning, contract mechanics, and revenue risks). Commercial review of contract and tender documents regarding commercial risks and calculation relevance. Execution of economic and risk analyses, derivation of strategic recommendations, and support of the technical project management during the bidding phase. Close collaboration with involved departments to ensure realistic and robust model assumptions, as well as their technical leadership within the sub-project.

Tools & SystemsExcel, PowerPoint

Focus AreasFinancial Modeling, Bid/Pricing Model, Tender Calculation, Investment Controlling, Risk and Scenario Analyses, Contract Analysis, Business Planning, Public Transport Tenders, HGB (German GAAP), skills=[{id=Financial Modeling, type=GLOBAL, name=Financial Modeling}, {id=Ausschreibungen, type=GLOBAL, name=Tenders}, {id=Pricing strategy, type=GLOBAL, name=Pricing strategy}, {id=Project Finance, type=GLOBAL, name=Project Finance}, {id=Business Planning, type=GLOBAL, name=Business Planning}]

Creation of the integrated financial model for a public transport tender in Baden-Württemberg and Bavaria (volume approx. €1.4–1.6 billion) for bid pricing. Commercial review of contract and tender documents regarding commercial risks and calculation relevance. Execution of economic and risk analyses, derivation of strategic recommendations, and support of the technical project management during the bidding phase. Close collaboration with involved departments to ensure realistic and robust model assumptions, as well as their technical leadership within the sub-project.

Tools & SystemsExcel, PowerPoint

Focus AreasFinancial Modeling, Bid/Pricing Model, Tender Calculation, Investment Controlling, Risk and Scenario Analyses, Contract Analysis, Business Planning, Public Transport Tenders, HGB (German GAAP), IFRS

Development of an integrated, multi-year financial model over the remaining term of existing concession agreements to support strategic investor communication within a sell-side process. The model served as a central instrument for the financial due diligence of potential investors and integrated operational, financial, and contract-specific parameters. Additionally, responsible for the creation and validation of addendum calculations and new pricing for ongoing concession agreements, considering updated assumptions. Close coordination with departments (e.g., Operations, Technology, Procurement, HR) to ensure consistency and plausibility of the underlying plan values.

Tools & SystemsExcel, PowerPoint

Focus AreasFinancial Modeling, Bid/Pricing Models, Three-statement/Forecast Model, Contract Addenda, Investor Relations, HGB (German GAAP), skills=[{id=Financial Modeling, type=GLOBAL, name=Financial Modeling}, {id=Pricing strategy, type=GLOBAL, name=Pricing strategy}, {id=Valuation, type=GLOBAL, name=Valuation}, {id=Investor documents, type=GLOBAL, name=Investor documents}, {id=Financial Planning & Analysis (FP&A), type=GLOBAL, name=Financial Planning & Analysis (FP&A))}]