Deepak Sharma

Education

• 

  Finoptions Institute of Financial Studies

  2021 - 2022

  Financial Modeling Finance

  This included creating a detailed overview report, gathering financial data from annual reports and online sources, and analyzing management discussions and peer reports. I constructed a Cash Flow Statement, Balance Sheet, and an Analytical Income Statement from raw revenue data. My analysis featured financial ratios, including profitability, solvency, efficiency, and liquidity, along with a DuPont ratio analysis and peer comparisons.I explored capital planning metrics such as NPV, IRR… Show more This included creating a detailed overview report, gathering financial data from annual reports and online sources, and analyzing management discussions and peer reports. I constructed a Cash Flow Statement, Balance Sheet, and an Analytical Income Statement from raw revenue data. My analysis featured financial ratios, including profitability, solvency, efficiency, and liquidity, along with a DuPont ratio analysis and peer comparisons.I explored capital planning metrics such as NPV, IRR, Payback period, and Discounted Payback period, along with Time Value of Money (TVM) concepts. For DCF valuation, I applied various methodologies including DDM, FCFF, and FCFE, and conducted business valuation research. My Excel skills expanded to include advanced referencing tools like VLOOKUP, HLOOKUP, INDEX-MATCH, and OFFSET, as well as text functions (LEFT, RIGHT, MID) and logical functions (IF, AND, OR). Additionally, I learned to create effective Pivot Tables and charts for data presentation. Show less

• 

  BM College of Management & Research

  2019 - 2021

  Master of Business Administration - MBA Finance, marketing
• 

  Devi Ahilya Vishwavidyalaya, Indore

  2016 - 2019

  Bachelor of Business Administration - BBA Finance