I asked myself: "How far can I push Excel?" This is the result.
Started as an Excel practice project.
Ended up building a 10-sheet Corporate Intelligence & Investment Command System for Apple (AAPL) featuring:
π Financial Statements (10 years of data)
π° DCF Valuation + 1,000 Monte Carlo Simulations
π Portfolio Analytics (Beta, Sharpe Ratio, Benchmarking)
π¬ Scenario & Sensitivity Analysis
π€ VBA Automation + One-Click PDF Reports
π Interactive Galaxy Command Center
Built with Power Query, VBA, Dynamic Arrays, and a lot of curiosity.
Would love feedback from the Excel and finance community!
GitHub: https://github.com/speedyhok
Posted Jun 8, 2026, 4:40 PM UTC
10