Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Financial Analysis
Intro to Mammoth Interactive
00 About Mammoth Interactive (1:05)
01 How to Learn Online Effectively (13:39)
01. Introduction to the course
1.1 Introduction to the Course (4:16)
1.2 Why should you learn Financial Analysis (4:22)
1.3 Introduction of the instructor (6:24)
1.4 Course requirements (what software, experience) (5:46)
Source Files
02. Excel Statement Models
2.1 What will we learn in this section (2:35)
2.2 Preparing Data Source for P&L (16:08)
2.3 Create P&L Structure (13:27)
2.4 Adding Data to P&L (19:48)
2.5 Calculating Variances (11:51)
2.6 Balance Sheet Structure (10:43)
2.7 Adding Values on BS from different files format (20:38)
2.8 Cash Flow Structure (10:25)
2.9 Calculating Cash Flow (11:04)
2.10 Challenge (1:35)
Source Files
03. Excel Finance Methods
3.1 What Will We Learn In This Section (5:48)
3.2 Forecast With Scenarios (23:30)
3.3 How To Calculate Finance Main KPI's (15:38)
3.4 Fixed Assets Roll Forward (18:29)
3.5 Loan Schedule (13:54)
3.6 Ar Management Basics (20:49)
3.7 Customers Rank (11:56)
3.8 Create Budgets Categories (19:45)
3.9 Challenge (1:25)
Source Files
04 Summary
4.1 Course Summary And Next Steps (31:21)
2.5 Calculating Variances
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock