Francisco Barrio Olivas, Finance Expert in Mexico City, Mexico
Francisco is available for hire
Hire Francisco

Francisco Barrio Olivas

Verified Expert  in Finance

Finance Expert

Location
Mexico City, Mexico
Toptal Member Since
February 24, 2021

Francisco began his investment banking career at Merrill Lynch, where he completed over $1 billion in M&A and financing deals. He then joined Advent International, one of the largest global private equity firms, where he evaluated over $3 billion in investment opportunities across different sectors. As a freelancer, Francisco has consulted for private equity funds and a number of startups providing support in business planning, financial modeling, capital raising, valuation, and structuring.

Career Highlights

Investment Associate
Advent International

Case Studies

Work Experience

Head of Financial Planning

2022 - PRESENT
Revolut
  • Built and managed the local finance department, playing an active role in hiring; implemented core infrastructure and designed key processes for accounting, financial planning, treasury, and financial reporting.
  • Directed and successfully secured three internal capitalization rounds: managed all aspects of Assets and Liability Committee approvals, including the preparation of investment materials and transaction structuring.
  • Developed a robust digital bank financial model, encompassing bottom-up forecasts across core payments, remittances, consumer credit, and wealth product lines, enabling successful regulatory license applications and funding of the Mexican business.
  • Managed a cross-functional team focused on developing the financial requirements of two regulatory license applications: achieved a record approval of a money transmitter license in less than one year.
Focus areas: Financial Planning & Analysis (FP&A), Business Planning, Forecasting, Financial Modeling, Accounting, Financial Reporting, Corporate Treasury, Treasury Management, Budgeting, Capital Budgeting, Fintech, Fintech Consultant, Subscriptions, CFO

Financial Consultant

2020 - PRESENT
Self-employed
  • Performed due diligence, financial modeling, valuation analyses, and transaction structuring for the acquisition of a $50 million solar energy platform on behalf of a US energy and infrastructure PE fund with $1+ billion AUM.
  • Supported an e-bike distribution startup with a successful seed fundraising of $1 million by developing a bottom-up operating and financial model, a base case valuation and transaction structure, and negotiations with shareholders.
  • Built a flexible LBO template model for an early-stage private equity fund. The model had a modular architecture and detailed leverage capabilities modeled through a robust debt waterfall and an earnout mechanism.
  • Developed a KPI dashboard (growth, origination costs, and profitability), a bottom-up operative model and projections that catalyzed annual savings of US$100,000 for a payroll broker.
  • Developed a monthly, 3-statement, financial and operating model for a brand aggregator with multiple revenue channels, including: online (.com, marketplaces, and social platforms) and traditional (retail and wholesale).
Focus areas: Fundraising, Business Consulting, Financial Modeling, Asset Valuation, Operating Models, Key Performance Indicators (KPIs), Finance, Financial Analysis, Forecasting, Fund Management, Mergers & Acquisitions (M&A), Leveraged Buyout (LBO), Investment Analysis, eCommerce, Pitch Decks, Credit Risk, Loans & Lending, Loans

Founder and CEO

2020 - 2021
Café Tero
  • Developed, launched, and operated a branded retail takeaway coffee shop in Mexico City. Executed all the steps in business planning and launch, including incorporation, product and brand development, and business and financial planning.
  • Led product and channel development for retail, B2B (sales to small supermarkets) eCommerce, and delivery platforms for a coffee shop concept in Mexico City.
  • Drove 3x growth over 12 months, despite opening in the midst of the COVID-19 pandemic. Reached operative breakeven and subsequently divested the business in less than 30 days.
  • Launched over a dozen value creation initiatives, including the development of new channels, a loyalty program, new products, and digital marketing initiatives to increase the recurrence and size of average sales.
  • Built a KPI dashboard and 3-statement operating model for financial management, fiscal reporting, and investment analysis.
Focus areas: Fundraising, Deal Sourcing, Industry Analysis, Deal Structuring, Three-statement Modeling, Financial Modeling, Investment Analysis, Investment Memoranda, Due Diligence, Business Planning, Consumer Products, eCommerce, Retail & Wholesale, Financial Forecasting, Revenue Analysis, Business Development, M&A (Buy-side), Forecasting, Business Models, Revenue & Expense Projections, Business to Business to Consumer (B2B2C), B2B2C, Financial Management, Food & Beverage

Investment Associate

2017 - 2020
Advent International
  • Originated, analyzed, and performed extensive buy-side diligence on an office-as-a-service company, including operating and commercial diligence, bottom-up financial modeling, and the preparation of investment committee materials.
  • Supported management of a banking portfolio company on all steps of its IPO process, including reviewing regulatory filings and marketing materials, coordinating advisors, and preparing pricing and valuation analyses and exit committee materials.
  • Prepared bottom-up operating and LBO models, performed commercial and quality of earnings diligence, and developed the investment thesis for several paper-packaging investment opportunities, totaling over $500 million in potential investment value.
  • Headed a series of proprietary industry mappings and sourcing efforts that resulted in several deal initiations, two due diligence processes, and the signing of two industry advisors.
  • Executed the initial steps of deal analysis for 20+ transactions, including developing initial presentation materials, investment thesis, operating financial and LBO models, valuation, corporate analysis, and offer letter and term sheet drafting.
Focus areas: Investment Analysis, Investment Memoranda, Industry Analysis, M&A (Buy-side), M&A (Sell-side), Value Creation, Financial Modeling, Financial Model Auditing, Comparable Company Analysis, Equity Valuation, Leveraged Buyout Modeling, Financing, Investment Thesis, Precedent Transaction Analysis, Due Diligence, Research Analysis, Business Development, M&A Modeling, Finance, Financial Analysis, Forecasting, Excel 2016, Microsoft Excel, Business Analysis, Investment Committee Advisory, Pitch Decks

Investment Banking Analyst

2014 - 2016
BofA Securities
  • Supported a successful $150 million sell-side M&A transaction for Mexico's second-largest pharmaceutical distributor through the full ownership of financial modeling and valuation analyses as well as aiding in the preparation of marketing materials.
  • Assisted the record-low pricing of Kimberly Clark de Mexico's $250 million bond issuance in 2014 and the subsequent $250 million bond issuance in 2015 by preparing industry analyses, roadshow materials, and credit benchmarks.
  • Owned the financial modeling, valuation analyses, management presentations in several live debts and M&A transactions, and pitches involving the analysis of industry research, preparation of financial models, and presentation materials.
  • Performed corporate and asset valuations and sensitivity analyses through DCF, LBO, comparable companies, precedent transactions, and sum-of-the-parts methodologies.
  • Developed teasers, confidential information memoranda, and management presentations for multiple transactions and prepared numerous decks and pitches for C-level executive discussions.
Focus areas: Industry Analysis, Financial Modeling, Discounted Cash Flow (DCF), Leveraged Buyout Modeling, Mergers & Acquisitions (M&A), Merger Modeling, Asset Valuation, Valuation, Pitch Presentations, Pitch Deck Consultant, Three-statement Modeling, Comparable Company Analysis, Precedent Transaction Analysis, Due Diligence, Investment Banking, Research Analysis, M&A Modeling, Finance, Financial Analysis, Microsoft Excel, Excel Expert
2009 - 2014

Bachelor of Commerce Degree in Finance

McGill University - Montreal, Quebec, Canada

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring