Stop Guessing: Automated Excel Tracker Delivers Dynamic Stock Performance & 1-Year Benchmarking
I designed and engineered a dynamic Stock Portfolio Tracker in Microsoft Excel, moving beyond manual data entry and static reports. This tool uses proprietary Excel functions to instantly pull near real-time prices and precise historical data, allowing for immediate Year-over-Year (YoY) performance benchmarking on any stock you enter.
2
2
37
Corporate Finance: Capital Budgeting & Investment Appraisal Model (NPV/IRR)
Completed a 10-year Capital Budgeting model for strategic investment appraisal. This model is built for decision-makers who need clear GO/NO-GO guidance.
Key Features:
1. Dynamic Scenario Analysis: Instantly switch between Bull, Base, and Bear cases.
2. Core Metrics: Calculates NPV (positive: $11.56M), IRR (14.87%), and Payback Period.
3. Full FCF: Models Terminal Value (Salvage) and Net Working Capital recovery.
Result: Provides a robust framework for assessing project risk and financial viability.
Need a data-driven framework for your next CapEx decision or corporate project evaluation? Let's connect.
1
37
Portfolio Optimization: Maximizing Sharpe Ratio using Monte Carlo Simulation and Solver
Just wrapped a rigorous asset allocation model for a portfolio of six stocks using Monte Carlo Simulation and solver.
Problem Statement: How to find the most efficient allocation for an institutional-grade portfolio.
Solution: Identified the Max-Sharpe Portfolio with an Expected Annual Return of 25.95% and Volatility of 16.90% (Sharpe 1.29) using Monte Carlo Simulation.
Need a data-driven strategy for wealth management or asset allocation? Let's build your next optimal portfolio.
1
43
Is Salesforce a Buy? My latest equity research model suggests yes. Utilizing a blend of DCF and Comparable Company Analysis, I derived a Price Target of $414, indicating significant upside. The model includes a full 5-year forecast and detailed Ratios & KPIs to track historical and projected performance. If you need clarity on your investment or business valuation, let's talk. All assumptions are centralized and transparent