Do you wish you or your staff produced better, more consistent Models?
You've come to the right place.
- 34 instructional videos (ranging between 3 and 8 minutes in length)
- Downloadable PDF slides and Excel files that are yours to keep
- Setting up Excel options for ease of use and reduced errors
- Keyboard shortcuts to save time and energy
- Building formulas correctly
- Industry conventions for formatting and layout
- Audit trails and color coding for increased usability
- How to build a 3-statement financial forecast model
- Supplementary calculations to improve auditing and presentation
- Building a cash flow statement that will balance your balance sheet every time
- Dealing with circular calculations safely
Course curriculum
-
1
Welcome
-
A message from the instructor
-
How to use this course
-
Before we begin...
-
-
2
Financial modeling - introduction
-
3
The modeling process
-
Excel materials to download
-
The modeling process
-
The modeling process review
-
-
4
Forecasting financial statements
-
Excel materials to download
-
Introduction and historical subtotals
-
Historical subtotals review
-
Forecast income statement
-
Forecast income statement review
-
Forecast balance sheet
-
Forecast balance sheet review
-
Forecast cash flow statement
-
Forecast cash flow statement review
-
Completed Excel materials
-
-
5
A more complete example
-
Excel materials to download
-
Introduction and historical subtotals
-
Historical subtotals review
-
Forecast income statement part 1
-
Forecast income statement part 1 review and forecast income statement part 2
-
Forecast income statement part 2 review
-
Forecast balance sheet part 1
-
Forecast balance sheet part 1 review and forecast balance sheet part 2
-
Forecast balance sheet part 2 review
-
Forecast cash flow statement
-
Balancing the balance sheet and dragging right
-
Calculating interest income and expense
-
Interest income and expense review
-
Dealing with circular calculations safely
-
Checking and sharing your work
-
Completed Excel materials
-
-
6
Building a cash flow statement from scratch
-
Excel materials to download
-
Cash flow statement logic
-
Building a cash flow statement from scratch - walkthrough and setup
-
Buidilng the cash flow statement - operating section
-
Building the cash flow statement - investing and financing sections & ending cash
-
Proper presentation of the cash flow statement
-
-
7
Next steps
-
Thank you
-
More resources for you
-
Feedback
-
Instructor
Trainer
Pete Mazzarese
Reviews
Really useful
Kate L
Really useful content. Thank you!
Really useful content. Thank you!
Read Less