Emiliano Contreras

Manage AR portfolios and collections across large datasets, using advanced Excel to track aging, overdue balances and payment
behavior. Identify discrepancies and collection opportunities, analyze data to recommend solutions, and coordinate with customers
and Finance to resolve issues and prioritize at-risk accounts.

Manage AR portfolios and collections across large datasets, using advanced Excel to track aging, overdue balances and payment behavior. Identify discrepancies and collection opportunities, analyze data to recommend solutions, and coordinate with customers and Finance to resolve issues.

Developed a financial and market optimization proposal to mitigate the impact of NOM-051 labeling restrictions, integrating sales forecasting, impact valuation, and data-driven visualization tools, resulting in a winning solution.

Supported invoice processing, payment tracking and customer collections. Gained experience in bank reconciliations, aging reports
and payment tracking, ensuring transactions were processed accurately and followed up until resolution.

Supported invoice processing, payment tracking and customer collections. Gained experience in bank reconciliations, aging reports and payment tracking, ensuring transactions were processed accurately and followed up until resolution.

Analyzed Cox Energy's acquisition and financing capacity through a $100M USD investment proposal. Evaluated WACC, operating margin, and merger scenarios projecting a 15-16-year payback and +41% net income growth.

Performed a full valuation and capital structure optimization using DCF and sensitivity analysis. Calculated a WACC of 11.7% and determined an optimal leverage ratio of 20% debt / 80% equity, supporting sustainable growth.

Designed and optimized a balanced $1M MXN portfolio for a moderate-risk profile, achieving a 15.38% annual return and a Sharpe ratio of 0.59. Applied diversification across equity and fixed-income ETFs, reducing downside risk and outperforming the CAPM benchmark.

Pursuing a degree in Financial Administration (LAF) at Tecnológico de Monterrey.

Completed a study period at Universidad Rey Juan Carlos in Madrid, Spain from January to June 2024.

Completed a certification in Cash Flow Management.

Activities and societies: Investment Analysis - Actinver Financing Analysis - Grupo Aeroportuario del Pacífico (GAPB) Corporate financing through investment banking Kellanova Challenge (Winner – Entropy Project)

Completed a certification in Financial Analysis of Organizations.

Completed certifications in Understanding Financial Markets and Portfolio and Risk Management.

Completed a certification in Portfolio and Risk Management.

Completed a certification in Investment Evaluation.

Earned the Bloomberg ESG Certificate.