Advanced Concepts in Risk Analysis


Business Valuation

 Advanced Concepts in Risk Analysis
CPE Credit

Program Type: VideoCast (Audio,Video, PPT Presentation)
Program Level: Basic
Prerequisites: Previous training or experience with the fundamentals of accounting, finance, economics, and business writing.
Advanced Preparation: None
Delivery Method: Group Internet-Based
CPE Credits: One (1) hour
Fields of Study: Computer Software & Applications
Item Number: 11OBVVC4339
Shipping Weight: 0lbs. 0oz.
Price: $80.00
Program Description

This case-driven webinar explores both the simple and more complex ways that Microsoft® Office Excel® can help financial analysts, consultants, and managers make better decisions. While the webinar centers on the development of a discounted cash flow analysis as a new product investment, sensitivity analysis and scenario analysis are also reviewed. In addition, an Excel-facilitated technique called "Data Tables" is discussed, which leads to the application of Monte Carlo Simulation.

Learning Objectives

After completing this webinar, attendees will be able to:

- Utilize Discounted Cash Flow modeling, describe and develop sensitivity and scenario analysis
- Integrate "Data Tables" and accurately interpret the results
- Describe the Monte Carlo Simulation and its results while appropriately applying it to recommendations
- Employ the use of illustrations on numerous other valuation applications including M&A

Who Should Attend

CPAs, financial professionals, anyone wanting advanced Excel skills

Presenter(s)

Samuel Weaver, PhD, CMA, CFM
Professor Samuel Weaver joined the full-time faculty at Lehigh in January 1998. He held the position of Director MBA and Professional Education (2003-2005) and the John C. Swartley 24 Professorship (2004-2005 and 2012-2013). Prior to 1998, Dr. Weaver was the Lauer Adjunct Professor of Finance at Lehigh University (1986 - 1997) and the Director, Financial Planning and Analysis at Hershey Foods Corporation for almost 20 years. That position combined the theoretical with the pragmatic and involved the analysis of many different facets of finance including: mergers and acquisitions, strategic planning, performance measurement, operational plans, industry group comparisons, divestiture assessment, alternative financing evaluations, dividend policy, capital expenditure analysis, and the determination of cost of capital and divisional hurdle rates.

His personal research revolves around areas of corporate finance, valuation and investment analysis, financial performance measurement, and supply chain (working capital) management. Dr. Weaver is the sole author of The Essentials of Financial Analysis (McGraw-Hill, 2011). He also is the co-author (with J. Fred Weston) of four books including: Strategic Financial Management: Applications of Corporate Finance (South-Western, February 2007) - along with its study guide and Finance and Accounting for Non-Financial Managers and Mergers and Acquisitions (McGraw Hill - Executive MBA Series - 2001). Both of these McGraw-Hill books have been translated for China, Russia, India, and Malaysia.

He has published in numerous leading academic and practitioner journals, provided chapters for five books, appeared in numerous textbooks discussing applications of corporate finance, and co-authored two cases published by the Darden Graduate School of Business. He serves as an associate editor for four journals and is a regular reviewer. His work has been presented at numerous professional conferences.