Publication
How to Prepare a Cash Flow Statement Model That Actually Balances
https://www.toptal.com/finance/cash-flow-consultants/how-to-prepare-cash-flow-statement
Pierre-Alexandre is available for hire
Hire Pierre-AlexandrePierre-Alexandre Heurtebize
Verified Expert in Finance
Finance Expert
Location
Nantes, France
Toptal Member Since
January 9, 2020
Pierre is a corporate finance, PE, and FP&A expert with extensive experience in complex financial modeling, translating entrepreneurs' ideas into robust business plans, and leading in-depth financial due diligence. He has specialized in the SaaS industry since 2019 and has contributed to over 60 transactions across Europe, Australia, and the US—mainly in the retail, SaaS, and technology spaces. Pierre helps entrepreneurs, CEOs, and CFOs make investment decisions through sound data analysis.
Career Highlights
Investment Associate
ForPurposeCo
Investment Associate
Isatis Capital (formerly BNPP Private Equity)
Education Highlights
MBA
Essec Business School
Certification Highlights
Certification AMF
Autorité des Marchés Financiers (Financial Market Authority)
Full-stack Data Science
Jedha Bootcamp
Case Studies
Industry Expertise
Other Expertise
Work Experience
Partner, SaaS Investment and M&A Transaction Services
2019 - PRESENT
Horizen Capital
- Ran a full M&A process for a $5 million ARR SaaS business in France. Built all financial reports and analyses for the process, sourced potential buyers, assisted in negotiating and reviewing LOIs, and handled financial due diligence advisors.
- Built the full forecast financial model for a healthcare insurance startup which subsequently raised more than $12 million.
- Authored the top one most visited channel for my Excel models and best practices on Eloquens.com with over 1,300 users. Models include price-volume mix analysis, inventory tracking, financial due diligence analysis, forecast, and cap table.
- Sourced and executed SaaS deals, serving as an M&A and Investment director at HoriZen Capital, investing in companies generating between $500,000 and $5 million in revenue.
- Managed relationships with target company CEOs, conducted financial analysis, built model valuation, and advised on negotiations and deal structuring.
- Worked on a discounted cash flow valuation model for a solar panel company looking to raise a seed round of several million dollars.
- Advised and built business plans for different entrepreneurs in the SaaS industry, well-being industry, online fashion, and for an intrapreneur in the healthcare insurance industry looking to raise $12 million in funding.
- Built a multiple rounds cap table model for a SaaS startup looking to raise a seed round and a series A of several million dollars. The model included SAFE conversion, management option pool creation, and the possibility for multiple rounds.
- Built a full financial model for a client looking to launch an investment firm. Created financial projections with several sources of revenue and different revenue options (funds management fee vs. brokerage fee).
Focus areas: Financial Planning & Analysis (FP&A), SaaS, Valuation, Cap Tables, Due Diligence, Mergers & Acquisitions (M&A), Lead Generation, Revenue & Expense Projections, Venture Capital, Investment Analysis, Private Company Valuation, Forecasting, Budgeting, Data Analysis, Business Analysis, Business Intelligence (BI), Cash Flow Modeling, Cash Flow Analysis, Cash Flow, Web Content, Financial Writer, Pitch Decks, Investment Thesis, Business Services, Excel Expert, Strategy, Tracking, Revenue Strategy
Technical Writer (Alternative Investments/Writing)
2022 - 2023
American Estate & Trust Inc.
- Wrote a series of technical and SEO-optimized articles on self-directed IRA.
- Researched and built informative materials around self-directed IRA and finance-related topics.
- Delivered relevant content tailored to the specific audience of the company.
Focus areas: Fundraising, Self-directed IRAs, Private Equity, Technical Writing, Writing & Editing, Equity Research, Market Research, Alternative Investments, Wealth Management, Real Estate, Investing, Investment Ideas
Senior Consultant M&A Transaction Services
2014 - 2019
PwC
- Built a broad range of Excel models including modeling of proforma accounts, carve-out, DSO-DPO-DIO, price volume mix, advanced churn, organic and inorganic growth analysis, pipeline, and backlog analysis.
- Conducted comprehensive commercial and financial analysis of target companies to present a normalized view of EBITDA (QofE) net debt and net working capital, focusing on identifying unusual items, changes in accounting, changes in perimeters, any significant change in the business landscape and policies or abnormal levels of inventory, account receivables, and account payables.
- Conducted analyses on profitability drivers and margin sensitivity, assessed the impact of new strategies, developed budgeting processes, and delivered monthly and yearly variance analysis.
- Built historical three-statement financials and detailed forecasts based on trial balance-level detail.
- Conducted interviews of top management and finance professionals to retrieve information to assess the financial and operating health of target companies.
- Managed cross-cultural and cross-department teams, liaising with legal, data analytics, and corporate finance teams.
Focus areas: Normalization, Pro Forma Financial Statements, Business Planning, Financial Analysis, Financial Modeling, Financial Planning & Analysis (FP&A), Mergers & Acquisitions (M&A), Due Diligence, Revenue & Expense Projections, Investment Analysis, Forecasting, Budgeting, Data Analysis, Business Analysis, Business Intelligence (BI), Xero, Cash Flow Modeling, Cash Flow Analysis, Cash Flow, Retail & Wholesale, Investment Thesis, Business Services, Excel Expert, Strategy, Tracking, Revenue Strategy
Investment Associate
2018 - 2018
ForPurposeCo
- Built a full three-way forecast model to assess profitability and cash generation of a fresh orange juice vending machine business which allowed the charity to raise funds for the company which now operates around 40 vending machines in the Sydney area.
- Built from the ground up a full teaser and Information memorandum including break-even analysis, market research, cash flow projection, and presentation of strengths of the business.
- Advised the company's CEO and board of directors and modeled different negotiation strategies and capital structures to raise funds from private investors (with a mix of debt and equity).
- Conducted market research on food-related technologies to help the board assess the potential of new projects in the pipeline.
- Managed the relationships with lawyers to structure the fundraising from a legal perspective.
Focus areas: Business Planning, Startup Funding, Startups, Modeling, Investments, Private Equity, Revenue & Expense Projections, Investment Analysis, Forecasting, Budgeting, Data Analysis, Business Analysis, Business Intelligence (BI), Cash Flow Modeling, Cash Flow Analysis, Cash Flow, Pitch Decks, Investment Thesis, Excel Expert, Strategy, Tracking, Revenue Strategy
Investment Associate
2013 - 2014
Isatis Capital (formerly BNPP Private Equity)
- Built a wide range of Excel models including capital raise mechanism, complex cap table and value distribution, multi-scenarios LBO structures, and complex exit proceeds schemes.
- Assisted investment directors in negotiations and deal execution, liaising with lawyers, due diligence teams, and target company CEOs. Target companies were profitable companies generating between $10 to $70 million in revenue.
- Executed extensive market searches and competitive landscape anlayisis to assess the potential of investment targets in industries such as food delivery, manufacturing, onsite marketing, datacenter, and development technologies.
- Authored an investment memorandum including market overview, comparable analyses, profitability assessment, development strategy, valuation, and recommendations for next steps that we presented to the internal investment committee.
- Managed relationships with CEOs of target companies, leading Q&A, and onsite visits.
Focus areas: Deal Execution, Valuation, Modeling Cases, Financial Planning & Analysis (FP&A), Investing, Revenue & Expense Projections, Venture Capital, Investment Analysis, Private Company Valuation, Forecasting, Budgeting, Data Analysis, Business Analysis, Business Intelligence (BI), Cash Flow Modeling, Cash Flow Analysis, Cash Flow, Pitch Decks, Investment Thesis, Business Services, Excel Expert, Strategy, Tracking, Revenue Strategy
Other Experience
Education
2010 - 2014
MBA in Finance and Business Administration
Essec Business School - Cergy
Certifications
NOVEMBER 2019 - PRESENT
Certification AMF
Autorité des Marchés Financiers (Financial Market Authority)
AUGUST 2019 - PRESENT
Full-stack Data Science
Jedha Bootcamp