Course Content
Part 1: Time and your first model
Welcome! This course will show you step by step how to use Openbox. If you haven’t already, you can get a 45 day free trial of the software by clicking the “Download” button at the top of the screen.
0/3
Intro
00:55
1a: Build a 3 Financial Statement model
04:21
1b Standard project finance model
06:57
Part 2: Reports
This section of the course shows you how to create and edit reports. Reports are the purpose of the model – the results it produces – and every model needs to have at least one.
0/3
Intro
00:50
2a: Adding a new report
04:12
2b: Importing a whole report structure
02:12
Part 3: Calculations
0/5
Intro
00:19
3a: Instant mode
06:20
3b: Instant mode with alt down
01:54
3c editing in normal OBX window
04:22
3d: Editing a calculation in the preview window
03:23
Part 4: Inputs
0/4
Intro
00:22
4a: Entering inputs
02:30
4b: Input sheets and types of input
03:16
4c: Entering complex inputs, such as tables or time series
01:10
Part 5: Visualizing your model
0/3
Intro
00:39
5a: Focus mode
02:58
5b: Model structure
03:53
Part 6: Components
0/5
Intro
00:55
6a: Finding a component
02:29
6b: Importing components
03:55
6c: suggesting components
01:10
6d: Creating your own components
03:37
Part 7: Validating and sending to Excel
0/3
Intro
00:42
7a: Validating – checking – your models
02:36
7b: Sending the model to Excel
01:58
Advanced topics
This section covers more advanced topics, such as creating a portfolio of assets using arrays, editing the model once it has been created in Excel, and so on.
0/1
A1: Portfolio of assets
00:00
Course completion
0/1
Get your certificate
00:00
Introduction to Openbox
About Lesson

The previous sections covered the basics of bringing components into your models. But there are some complexities here. Which parts of your component should link to which parts of the existing model? What if the component specifies one formula for something, but the existing model already has a different formula for that?

This video shows you how to deal with these situations.

Join the conversation
Previous
Next