r/excelβ€’
shadyhok

I asked myself: "How far can I push Excel?" This is the result.

Discussion

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
Loading comments…