Successfully built and refined a detailed LBO model for a mid-market private equity client, which proved instrumental in valuing a target company with an enterprise value of $350 million. The model's scenario analysis identified a 25% IRR upside under specific operational improvements, directly contributing to the client's decision to proceed with advanced due diligence. This involved integrating complex debt tranches and management projections under extremely tight deadlines, often requiring rapid iteration and deep Excel proficiency to ensure both accuracy and responsiveness to senior bankers' requests.
During my summer analyst role, I regularly constructed and refined complex financial models. I built a comprehensive DCF model for a public software company's strategic review, projecting cash flows across five distinct scenarios, which revealed a valuation range between $1.2 billion and $1.5 billion. This analysis, performed using advanced Excel functions, was presented in board materials and informed potential acquisition targets. Furthermore, I developed an accretion/dilution model for a proposed $750 million merger, assessing EPS impact over three years. This model, built from scratch, highlighted potential dilution risks and helped senior bankers advise the client on deal structure adjustments, ultimately strengthening their negotiating position in client discussions.
I am particularly drawn to Veridian Capital Advisors due to your distinctive expertise in guiding disruptive technology companies through complex M&A transactions. Your recent advisory role in the AeroTech Systems acquisition, specifically noted for its innovative financing structure, resonates deeply with my analytical rigor and passion for applying sophisticated modeling techniques to high-growth sectors. My ability to construct robust LBO and merger models, combined with my keen interest in market-disrupting technologies, aligns perfectly with Veridian's strategic focus and commitment to delivering bespoke solutions for visionary clients.
My experience at Evercore has thoroughly prepared me to hit the ground running as an Investment Banking Intern at Veridian Capital Advisors. I am confident that my strong analytical skills, advanced modeling capabilities, and diligent work ethic will make an immediate and tangible contribution to your team. I am eager to discuss how my qualifications align with Veridian Capital Advisors' objectives and welcome the opportunity for an interview to explore this exciting possibility further.
Best regards,
Sofia Martinez