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...
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:...
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...
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...
