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.
- 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.
• Purpose, uses and types
• 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
• Merger model uses
• 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