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

Previous sessions showed you how to get constant inputs into the model. As this video will show, entering more complex table or series inputs is as easy as in Excel. Just type, or copy and paste, into the preview and hit F9.

Join the conversation
Feda Alrajoudi 11 months ago
The video doesn't show the data entry for table, only capex?
Reply
Previous
Next