Venugopal Jaiswal

MBA Finance fresher with strong analytical and financial modeling skills, complemented by internship experience in investment banking. Built multi-sheet financial models, developed debt amortization schedules and performed Project/Equity IRR analysis to evaluate capital structures and investment returns. Conducted scenario analysis, vendor negotiations and operational assessments through P&L, Balance Sheet and Cash Flow models. Certified in Investment Banking (J.P. Morgan Chase Forage), Excel and Power BI, with hands-on expertise in DCF valuation, dashboard automation and financial data visualization.

JP Morgan Chase Investment Banking Job Simulation (Forage)-

• Identified ideal M&A target based on an assessment of strategic & financial criteria.
• Constructed a DCF model for valuation of the M&A target.
• Created a 2-pager for the client containing a company profile & summary of the auction process.

Power BI (The Prime step)-

• Learned to design interactive dashboards to visualize key metrics (revenue growth and profitability).
• Learned to reduce manual reporting time by 40% through automation of data visualization.

Microsoft Excel (The Prime step)-

• Utilized advanced Excel functions including PivotTables, XLOOKUP and VLOOKUP to analyze large financial datasets and extract actionable insights.
• Used conditional formatting in Excel to identify and highlight duplicate entries, ensuring data accuracy and consistency.

• Represented and won 3rd prize at State Level Badminton Tournament organized by Madhya Pradesh Education Department along with various other open tournaments.
• Volunteered in free eye checkup camp organized by Prakash Smriti Seva Sansthan visited by 500+ people