Rohit Gupta Email & Phone Number

Palm Beach Gardens, FL, US

New York City Metropolitan Area

Charleston, South Carolina, United States

• Designed financial models to analyze ten multifamily development projects with a combined value of over $400m, supporting the team to design the optimal capital structure and ROI analysis
• Synthesized investment committee pitchbooks incorporating demographic, economic, and tax implications of the project
• Redesigned the underwriting model template, allowing team to increase productivity by 25% while boosting accuracy

Gurgaon, India

• Worked on deal sourcing, screening, financial modeling, and due diligence of real estate acquisition deals
• Analyzed the economic feasibility of developing multifamily residential complex projects with a combined value of over $600m for a London-based real estate development management company
• Analyzed debt investment opportunities for a Switzerland-based $330m real estate debt fund. Structured senior & mezzanine loans of $25m - $60m for each deal based on the required covenants
• Prepared debt investment information memorandums covering market research, risks & mitigation analysis, and borrower background which enabled investment committee to make the final decision on debt deals worth $25m.
• Collaborated with four-member multinational team to analyze cash flow of a real estate restructuring deal worth $3.5b, the biggest single asset real estate deal in Europe’s real estate history
• Helped a client in the acquisition and management (budgeting and reporting) of a German retail portfolio worth $14m

Gurgaon, India

• Created financial models and information memorandums for various real estate transactions for Oxane’s clients.
• Collaborated with the European arm of a San Francisco-based real estate private equity firm, and created asset valuation models to decide bid price on properties worth $50m - $1.2b. Synthesized pitch books to raise.
• Revamped a financial modeling template that helped reduce time to analyze investment opportunities from four hours per deal to less than one hour per deal

Mumbai Area, India

• TresVista is a financial services firm that supports its clients across geographies, asset classes, and sizes. TresVista has worked with 1,000+ clients in over 40 countries since its inception in 2006.
• Worked with New York-based family fund focused on investing in public companies in the USA and China
• Prepared stock valuation models using DCF, DDM, public comparables, and transaction comparables for companies across E-commerce, oil & gas, manufacturing, and real estate sectors
• Responsible for keeping client updated on activity in portfolio companies after earnings calls and quarterly results

Master Of Business Administration - Mba

Bachelor Of Engineering - Be + Master Of Science - Msc, Electrical And Electronics Engineering + Biological Sciences