یوگیش کمار پنجوانی

Dean’s Honor List throughout my academic journey at IBA Karachi. Acadamic Projects Financial Modeling Jan 2021 – Jun 2021  Created Excel-based models, including a startup model, Berger Paints model, private equity feasibility model, and cashflow feasibility model, utilizing historical data spanning FY2016-2020  Selected metrics for value forecasting, executed variance analysis to assess the impact on key ratios like profitability, solvency, and liquidity, yielding valuable insights.  Applied diverse valuation techniques, including Discounted Cash Flow (DCF) and Dividend Discount models, to determine the company's fair value and generate investment recommendations (BUY/HOLD/SELL). Financial Risk Management Aug 2021 – Dec 2021  Developed three Excel models centered on market, credit, and liquidity risk, enabling an evaluation of potential business impacts when key variables undergo changes.  Conducted comprehensive risk assessment, encompassing log-based returns, mean returns, standard deviation, variance, Value at Risk (VAR), Conditional Value at Risk (CVAR), and GAP analysis, covering 10 companies and the KSE-100 index. This assessed risk tolerance for a $2 billion portfolio and expanded investments into additional asset classes, including currencies and commodities.  Utilized the '5 Cs of credit risk' methodology to assess the eligibility of clients for loans, creating a scoring system with weighted criteria for each 'C' and further refining the allocated weights. Security Analysis Aug 2021 – Dec 2021  Established a Mock Portfolio comprising 8 stocks with a total value of PKR 10 million, employing a buy-and-hold approach with equal allocation to each stock.  Closely tracked and documented price fluctuations within the portfolio to assess returns, gains, and losses, while also benchmarking its performance against the KSE-100 index.  Delivered a noteworthy 2% outperformance compared to the market, yielding profits of PKR 8,046.