Enquire Now


Our valuation and financial modeling modules are offered separately or bundled for those seeking to build, compliment or expand their professional skill set.

Financial modeling is a departure point from valuation in that it helps to provide us with predicative assessment of what our target company would look like under particular transaction. Modeling is a crucial step in making informed investment decisions that can have a huge financial impact on companies. By attending this course, you will be able to effectively prepare, analyze and interpret financial models in corporate finance and mergers and acquisitions.


  • The mix of basic valuation techniques & applications provided in this seminar will appeal to a widely diverse audience.
  • Equity research analysts, who are interested in examining alternatives to the multiples that they use or the linkage to discounted cash flow models
  • Corporate financial officers, who want to understand the details of valuation, either because they are planning acquisitions or are interested in value enhancement strategies for their firms
  • Analysts involved in mergers and acquisitions, who would like to acquire a wider repertoire of valuation skills
  • Portfolio Managers who are interested in the effects of corporate restructuring on firm value, and the implications for portfolio management.
  • Anyone interested in valuation

    - Gain an introductory understanding of integrated financial statement modeling
    - Learn to how to forecast projections
    - Become familiar with cash sweep modeling
    - Acquire the ability to prepare, analyze and interpret financial models
    - Construct forecasted financial statement models and perform sensitivity analysis
    - Develop or improve Excel skills while learning different modeling techniques


    Rick is an experienced Wall Street and Silicon Valley investment banker based in Asia. Having completed over 50 transactions totaling over US$10 Billion and having covered a broad base of fundraising and M&A advisory assignments across the globe, he has worked with a wide range of clients from Fortune 500 companies to advising start-ups. His industry experience covers chemicals, transportation, telecom, media, technology, retailing, consumer products, and security and defense industries. He is the founder of Lares Loreno Private Capital, a Singapore-based firm providing advisory and corporate finance services to small and medium-sized enterprises, family businesses and private equity investors. Rick is also a director with Fortress Group, a US-based fund placement agent and oversees their fund placement operations in Asia. Previously, Rick was a Vice President at Deutsche Bank in their Consumer Products and Retail Coverage Group in New York where he called on and worked with corporate and private equity clients globally. Prior to Deutsche Bank, Rick split his time between Merrill Lynch’s Consumer Products Group in New York and their Internet Technology Group in Silicon Valley, California where he led their Internet E-commerce investment banking group, raising capital and providing strategic advisory for companies looking to monetize or expand their existing internet businesses. Rick began his investment banking career as an associate at Donaldson, Lufkin & Jenrette (subsequently acquired by Credit Suisse). He immediately gained significant transaction experience in emerging markets, M&A and leveraged finance. He also has a corporate governance background as an independent director on the boards of directors of listed and private companies in Spain, US, China and Japan and is the trustee for an employee stock ownership plan (ESOP) for a Wang Technologies, a geotechnical engineering company in the US. He was actively involved in recruiting and training incoming analysts and associates at Deutsche Bank and Merrill Lynch and was a teaching assistant for advanced financial statement analysis at the University of Chicago – Booth School of Business. Rick is a member of the Singapore Institute of Directors and is a Chartered Alternative Financial Analyst (CAIA). He graduated with an MBA from the University of Chicago – Booth and a BS in Economics from the United States Naval Academy at Annapolis.


    Financial Modeling Overview

    • Purpose, uses and types

    Introduction to LBO Modeling

    • Key Components
    • Financial statement forecasting
    • Cash sweep and statement integration
    • Purchase price calculations and considerations
    • Creation of short form LBO Model
    • Returns analysis
    • Credit ratios

    Introduction to M&A Modeling

    • Merger model uses

    Creation of Accretion / Dilution Model

    • Calculation of equity value and purchase price
    • Impact of various considerations
    • Synergies and pre-tax synergies required to breakeven
    • Proforma income statement
    • Pro Forma EPS to acquirer

    Registration Details

    Bank A/C Details for -
    Cheque,Cash & NEFT Payment

    Account Name: I-Deals NetworkPvt. Ltd.
    Bank name : ICICI bank
    Branch name :Gaur City
    Account no : 345205000116
    IFSC code : ICIC0003452
    Swift Details: ICICINBBCTS

    In case of queries, please email us at register@i-dealsnetwork.com or Call / Whatsapp on +91 9650920078



    DoubleTree by Hilton Hotel