Investment Analyst
Current• PnL Modeling: Revamped the investment model by introducing line items such as levered IRR, unlevered IRR, recurring EBITDA, and revenue recognition for make the model more comprehensive and increase usability across diverse teams• Automated Data Extraction: Developed an automated data extraction proves for deal valuations using Advanced Excel functions, eliminating 100% manual data entry for valuation and reducing 30% time spent by investment team on each deal• Data Management and Board Review: Consolidated and managed data of the finance department for Monthly Board Review, providing value generated by each team using metrics like time taken, revenue generated, and number of unwanted iterations• Deal Valuation: Performed deal valuation and negotiation resulting in a successful pivotal partnership with government, increasing firm’s top line and Return on Invested Capital (ROIC)