Analysis
Valuation of a Vienna D2C Cosmetics Startup
Overview
What this challenge is about.
You are a junior financial analyst at a boutique valuation firm. GlowVienna has provided you with historical financial data (revenue, expenses, customer counts) for the past three years and industry benchmarks. You must build a three-statement financial model (income statement, balance sheet, cash flow) in Excel, project free cash flows for five years, and compute terminal value using the perpetuity growth method. Additionally, you need to identify 3-5 comparable public companies in the beauty/cosmetics space and calculate relevant multiples (EV/Revenue, EV/EBITDA). The final deliverable is a one-page executive summary with a recommended valuation range and key assumptions. Success means your model is dynamic, logically consistent, and clearly shows the impact of changing growth rates and discount rates.
The Brief
What you'll do, and what you'll demonstrate.
Determine the pre-money valuation of GlowBerlin for its Series A round using DCF and comparable company analysis.
Earning criteria — what you'll demonstrate
- Build an integrated three-statement financial model in Excel
- Apply DCF valuation methodology with terminal value calculation
- Perform comparable company analysis using market multiples
- Conduct sensitivity analysis to assess valuation drivers
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.