10-Year Multi-Asset Comparative Study
ProblemRetail investors rarely get a rigorous, like-for-like comparison of equity, gold, and an active fund across a full market cycle.
ApproachCleaned the data with Hampel filtering, then computed CAGR, rolling returns, Sharpe, beta, correlation and maximum drawdown — plus SIP vs lumpsum outcomes and lognormal scenarios to 2034.
ResultA 14-sheet decision workbook and Power BI dashboard quantifying the risk-adjusted trade-offs; scenario modeling flagged gold breaking above its 90th-percentile projection band.
- Advanced Excel
- Power BI
- Risk & Return Analytics