This course provides the financial professional with detailed tutorials on how to customize the provided Excel Financial Forecast Model and Valuation Model templates as well as how to construct the formal Capital Plan and Valuation Report provided in Part I of this course.

The Excel spreadsheet tutorials review each tab in detail and explain the logic and functions of each “engine.” The valuation and financial models are linked so any changes to the market-based assumptions in the financial model “flows” through to the valuation. The initial valuation is analyzed to determine if the valuation is “in balance” and if “out of balance,” steps are taken to create a “balanced investment.” 

Course Series

This course is included in the following series:

2 CoursesNew Venture and Product Valuation

  1. Pre-Revenue New Venture and New Product Valuation Technique: Part I
  2. Pre-Revenue New Venture and New Product Valuation Technique: Part II
Learning Objectives
  • Discover the New Venture and New Product Valuation Technique.
  • Recognize how to manipulate and customize the Financial Model and Valuation Templates.
  • Recognize how to analyze the results to determine if the valuation is balanced.
  • Discover how to create a formal valuation document. 
Last updated/reviewed: March 26, 2024
9 Reviews (48 ratings)

Reviews

3
Member's Profile
Concepts are good, following it without studying the spreadsheets before listening to video is confusing. I think some of the things manualyl done could be automated and protected as I think likelihood of forgetting to do something important in the process is high
5
Anonymous Author
Well thought out and presented modeling example with underlying logic explained clearly. Having the templates to use for reference helps the information sink in.
5
Anonymous Author
Great course that explains the use and functionality of the Financial and Valuation Model templates with a step by step approach.
4
Member's Profile
A bit of a rehash of Part 1 - but still a valuable rehash Got to love Excel for this one :)
4
Anonymous Author
Good hands-on activity on valuation. The sample provided gave good insights and practice.
4
Anonymous Author
Solid program with a good template / model to utilize.
5
Member's Profile
Great course..
4
Anonymous Author
Good overview.
5
Member's Profile
Great course
Prerequisites
Course Complexity: Advanced

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other course in the series prior to completing this one.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  9:42PREVIEW: Introduction to Part II
Financial Model
  Financial Model Approach6:41
  Financial Model Problems6:30
  Financial Model Tutorial13:09
  Financial Model Tutorial (continued)14:32
Valuation Model
  Valuation Model Review13:45
  Valuation Model Approach4:39
  Valuation Tutorial10:09
Illustrative Examples
  Illustration Introduction4:36
  Illustration Financial Model13:50
  Illustration Financial Model (continued)6:24
  Illustration Valuation Model10:20
Conclusion
  Course Summary7:12
Continuous Play
  Pre-Revenue New Venture and New Product Valuation Technique: Part II2:01:37
SUPPORTING MATERIALS
  Slides: Pre-Revenue New Venture and New Product Valuation Technique: Part IIPDF
  Pre-Revenue New Venture and New Product Valuation Technique: Part II Glossary/IndexPDF
  Template_Financials-InternetXLSX
  Template_FinancialsXLSX
  Template_ValuationXLSX
  Valuation Report Boiler PlatePDF
REVIEW & TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam