Summary
Overview
Work History
Education
Skills
Interests And Certifications
Timeline
Generic

Lanre Akin

Canada

Summary

I am a finance professional with about 10 years of experience providing budgeting, forecasting, investment appraisal, financial modelling, and M&A services to companies operating in multiple sectors.

Financial analyst with strong track record in financial forecasting, budgeting, and data analysis. Proven ability to deliver actionable insights and drive financial performance through collaboration and adaptability. Equipped with expertise in financial modeling, strategic planning, and risk management. Known for reliable performance and ability to thrive in dynamic environments.

Overview

11
11
years of professional experience

Work History

Senior Financial Analyst – Financial Planning and Analysis (FP&A)

ATCO Energy
10.2022 - Current
  • Developed comprehensive 7-year budgets for multiple lines of businesses, by aligning strategies with overarching corporate objectives
  • Built a consolidated 3-statements model, and ensured all deliverables were finalized two weeks ahead of corporate submission deadlines
  • Led the development of forecasting models by collaborating with business leaders to understand core business drivers, refined assumptions and minimized variance to a maximum of 4%
  • Determined the enterprise value (EV) of an HVAC company using DCF and relative (EV/EBITDA) valuation approach, identified synergies, leading to a $4.5M acquisition with an IRR of 28%
  • Created a flexible financial model with four scenarios for the Warranty LOB, incorporating three promos, termination fees, and multiple churn rates, facilitating quicker decision making
  • Crafted the pitch deck for ATCO Energy’s acquisition of Furnace Family, outlining key metrics, strategy, industry analysis, synergies, valuation assumptions, and sensitivity analysis
  • Prepared a relative valuation model for the acquisition of a solar installer, by researching growth rates and industry gross margin, leading to engagement with the Target within two weeks
  • Reviewed and automated the financial model for generating the divisional report for all ATCO’s LOB, by writing advanced Excel formulas, leading to a 50% decrease in preparation time
  • Streamlined the tax reasonability spreadsheet from 20 to 4 excel tabs and reduced computation time from 2 hours to 15 minutes, by writing excel formulas and leveraging Oracle SmartView
  • Automated the electricity and gas revenue and COGS accrual process by leveraging IF functions, SUMIFS, Pivot, INDEX/MATCH and VLOOKUP, reducing preparation time by 60%
  • Conducted the financial report validation in Oracle’s FCCS consolidation software by validating management information and booking the adjustment entries in the consolidation packages
  • Formulated a multiple regression predictive model to forecast energy consumption by leveraging SQL and Python, and combining results using Excel, producing results with 94% R2

MBA Intern (Investment Banking – Mergers and Acquisitions)

HSBC
06.2022 - 09.2022
  • Built an LBO model for a private equity acquisition, leveraging Capital IQ, Factset and MergerMarket
  • Developed sources and uses of funds table, identified precedent transactions and created sensitivity tables with key variables, leading to an IRR of 10% - 14%
  • Developed a pitchbook for a luxury goods company, showing industry/ company overviews, investment rationale, and a merger model, estimating an EPS accretion of 2%
  • Produced a pitchbook, by preparing an Equity Value to EV bridge, identifying mitigants to issues, and creating a football field showing the EV from multiple valuation techniques
  • Researched the impact of recessions on real estate firms' earnings in previous economic downturns
  • Analyzed earnings decline and recovery rates and incorporated the average findings into a worst-case scenario DCF model for a potential 2022 real estate firm acquisition

Manager – Business Advisory Practice

ANDERSEN
11.2017 - 12.2020
  • Led a due diligence team during the $20M acquisition of a company, creating a quality of earnings report, assessing asset efficiencies, and identifying working capital requirements
  • Reviewed a project finance model to assess a $300M investment in a gas plant
  • Engaged cross-functional teams (e.g., operations and marketing) to collate, consolidate and verify budget data, confirmed business drivers, and built a 5-year budget
  • Managed a financial due diligence team on a $210M acquisition of a power company by a conglomerate, through the development of frameworks and models to estimate Target’s liabilities, leading to the adoption of an asset strip acquisition strategy, potentially saving $10M
  • Automated Seplat Petroleum Plc’s templates for generating reports by writing formulas in the SAP system reducing the total time to generate reports by 70%
  • Earned an accelerated path (double promotion) to the Manager position due to consistent high performance, spending only two years instead of three as a senior associate

Associate – Energy and Natural Resources (ENR)

KPMG
09.2014 - 11.2017
  • Led the due diligence and financial model review of the $4B acquisition of oil and gas assets from divesting international oil and gas company
  • Evaluated a $450M acquisition of an upstream company, by conducting due diligence, building the business plan, forecasting revenues based on oil reserves, and oil price assumptions
  • Implemented process improvement measures and updated budgeting policy, procedural manual, and financial model governance framework, driving model and report integrity
  • Developed a robust two-year rolling cash flow projection after identifying business drivers and validating assumptions, before preparing scenario and sensitivity analysis
  • Highlighted the tax and regulatory risks associated with a PE firm divesting its investment in a company, by assessing the most efficient exit level (subsidiary), resulting in savings of $7M
  • Coordinated the budgeting process for a $25M revenue entity, by collating budget information from various departments, reviewing the consolidated budgets for accuracy, and providing advice to department managers on any capacity constraints
  • Collaborated with the deal team in presenting an investment assessment to leadership, to aid a final investment decision in an oil mining lease, by modelling the decision variables and estimating the internal rate of return of 12%, leading to the client’s $80m capital investment
  • Transformed the tax computation process by writing algorithms in the ERP, to generate pre-calculated columns, and eliminate manual entry of parameters, improving efficiency by 75%
  • Improved the efficiency of the budget model by consolidating and revising formulas of six independent budgets into one file, reducing update time and error rate by 60% and 70%

Education

Master of Business Administration -

Alliance Manchester Business School
01.2022

CPA -

Chartered Professional Accountant
05-2026

Chartered Business Valuator (CBV)
09-2026

Chartered Global Management Accountant -

Chartered Institute of Management Accountants
01.2020

Bachelor of Science - Applied Physics

University of Lagos
01.2012

Skills

  • Advanced Excel
  • Python Programming
  • PowerPoint
  • Capital IQ
  • Oracle SmartView

Interests And Certifications

Bloomberg Market Concepts | HSBC Global Banking | FactSet Essentials: Core Products | Python Programming | Capital IQ | Oracle SmartView. Chess | Basketball | Football | Traveling | Table Tennis | Net Zero Targets and Costs, Net Zero: The Hare and the Tortoise

Timeline

Senior Financial Analyst – Financial Planning and Analysis (FP&A)

ATCO Energy
10.2022 - Current

MBA Intern (Investment Banking – Mergers and Acquisitions)

HSBC
06.2022 - 09.2022

Manager – Business Advisory Practice

ANDERSEN
11.2017 - 12.2020

Associate – Energy and Natural Resources (ENR)

KPMG
09.2014 - 11.2017

Chartered Global Management Accountant -

Chartered Institute of Management Accountants

Bachelor of Science - Applied Physics

University of Lagos

Master of Business Administration -

Alliance Manchester Business School

CPA -

Chartered Professional Accountant

Chartered Business Valuator (CBV)

Similar Profiles

CREATE PROFILE
Lanre Akin