AVILIPSA SAHOO

Investment analysis professional with expertise in portfolio management, investment screening, and financial analysis. Skilled in financial modeling, valuation, and market analysis, facilitating informed capital allocation decisions. Experienced in monitoring portfolio performance and conducting investment due diligence, producing analytical reports that guide strategic investment decisions in asset management and institutional investment environments.

• Financial Modeling & Valuation Projects, CFI, Built financial models in real estate (NOI, Cap Rates, Debt Schedule, IRR, NPV), mining (NPV, P/CF Ratio, EV/Resource, TAC), and renewable energy (FCFE, IRR, Acquisition Cost). Projected asset IRRs up to 33%, transaction-level IRRs of 6.7%, mining asset NPV of $3.28B, and solar project IRR of 7.5%. Applied DCF and sensitivity analysis to evaluate project viability and risks.
• Portfolio Optimization with Python, CFI, Applied quantitative finance techniques to analyze a 4-stock portfolio, running 10,000 simulations to identify the optimal allocation with the highest Sharpe ratio, improving portfolio performance evaluation by 15% using Python and visualization tools.
• Applied Investment Projects, BSBI, Conducted financial performance analysis of GlaxoSmithKline and Pfizer, comparing profitability (ROS 12.6%→13.1% vs. 23.8%→22.0%) and efficiency (ROCE 27%→24.7% vs. 16.3%→13.4%), highlighting competitive positioning. Built a DCF valuation model for Tesla, capturing a 52-week price range of $122–$402 and identifying a 13% YoY net loss increase, raising sustainability concerns. Analysed banking sector performance (HSBC vs. Barclays), reviewing revenue growth ($64B→$67B), free cash flow ($22B), and liquidity/efficiency ratios. Evaluated hedging applications and KKR’s private equity strategies, assessing derivatives use in risk management and outcomes of leveraged acquisitions.