Separate inputs from formulas
The workbook uses a color convention to distinguish hardcoded inputs, calculations, linked cells, and fields requiring refresh.
Flagship project · Excel
Equity Portfolio & ULTA Revenue Forecast
A self-directed finance project that combines portfolio tracking, performance benchmarking, dashboard reporting, and a driver-based public-company revenue forecast in one documented workbook.
Portfolio AnalysisExcelForecastingBenchmarking
01Portfolio trackerweights, returns, P&L, contribution
02DashboardKPIs, allocation, benchmark
03ULTA forecasthistoricals + editable assumptions
I built the workbook to practice the same workflow an analyst uses repeatedly: organize inputs, calculate performance, summarize the important KPIs, compare results against a benchmark, and document the assumptions behind a forward-looking forecast.
Inputsshares, cost basis, market prices, revenue history, forecast growth
Calculationsmarket value, portfolio weight, P&L, return, contribution, CAGR
Outputsdashboard KPIs, sector allocation, benchmark comparison, FY2027E revenue
The tracker records shares, cost per share, market price, cost value, market value, position weight, unrealized gain/loss, holding-period return, and contribution to total portfolio return for each security.
Illustrative workbook snapshot
Sector allocation
Allocation is calculated from the workbook’s May 2026 model snapshot. The workbook labels equity prices as placeholder values that should be refreshed before using performance outputs.
| Ticker | Company | Sector |
|---|---|---|
| AAPL | Apple | Information Technology |
| MSFT | Microsoft | Information Technology |
| NVDA | NVIDIA | Information Technology |
| JPM | JPMorgan Chase | Financials |
| JNJ | Johnson & Johnson | Health Care |
| AMZN | Amazon | Consumer Discretionary |
| ULTA | Ulta Beauty | Consumer Discretionary |
| XOM | Exxon Mobil | Energy |
| PG | Procter & Gamble | Consumer Staples |
| COST | Costco | Consumer Staples |
The dashboard pulls directly from the portfolio sheet to summarize market value, cost basis, unrealized P&L, holding count, portfolio return, and excess return versus the S&P 500. This keeps the analytical logic separate from the presentation layer.
Market ValueFormula-linked
Unrealized P&LFormula-linked
Portfolio ReturnFormula-linked
Alpha vs S&PFormula-linked
Performance values are intentionally not promoted here as “live” because the source workbook explicitly identifies its market-price cells as placeholders.
The revenue model uses historical Ulta Beauty net sales from FY2020A–FY2024A, then applies editable top-down growth assumptions of 4.5% for FY2025E, 5.0% for FY2026E, and 4.0% for FY2027E.
Net sales · $ billions
ULTA revenue history & forecast
FY2025E4.5%recovery assumption
FY2026E5.0%store growth + comps
FY2027E4.0%moderated growth
The workbook describes this as a top-down revenue forecast rather than a full three-statement model; no margin or cash-flow assumptions are included.
Benchmark with context
Portfolio performance is compared with the S&P 500 using a simple holding-period framework rather than overstating precision.
State the model boundary
Returns exclude dividends and fees, and the ULTA forecast is intentionally revenue-only rather than a full valuation model.
Project files
Review the underlying workbook.
The Excel file includes the formulas, assumptions, portfolio tracker, dashboard, and ULTA forecast shown in this case study.