No Judul Video
1

Cara Mendownload Banyak Data Saham Perusahaan dengan Satu Kali Klik

2

Pengadilan Amerika Serikat memakai Metode Valuasi Direct Capitalization of Cash Flows dan Build-up

3

Proyeksi Laporan Keuangan Menggunakan berdasarkan Asumsi Data Historis Keuangan

4

Mengambil Data Historis dan Membuat Analisa Common Size Ratio untuk Proyeksi Laporan Keuangan

5

Membuat Analisa Rasio Keuangan (Financial Ratio) dalam Proyeksi Laporan Keuangan

6

Menyeimbangkan Neraca dalam Proyeksi Laporan Keuangan (Bagian 1)

7

Menyeimbangkan Neraca dalam Proyeksi Laporan Keuangan (Bagian 2)

8

Pembuatan Asumsi Pembayaran Deviden dan Hutang Jangka Panjang dalam Proyeksi Laporan Keuangan

9

Membuat Target Struktur Modal pada Proyeksi Laporan Keuangan (Financial Modeling)

10

Melakukan Analisa Sensitivitas pada Proyeksi Laporan Keuangan

11

Melakukan Analisa Skenario pada Proyeksi Laporan Keuangan

12

Managing for The Future : Using Financial Modeling

13

Capital Budgeting untuk Lembaga Nonprofit dan Sektor Publik

14

Manajemen Modal Kerja (Working Capital Management) Bagian 1

15

Manajemen Modal Kerja (Working Capital Management) Bagian 2

16

Menggunakan Dupont Model untuk Menentukan Apakah Bisnis Siap untuk Memperoleh Pinjaman (1)

17

Menggunakan Dupont Model untuk Menentukan Apakah Bisnis Siap untuk Memperoleh Pinjaman (2))

18

Menggunakan Dupont Model untuk Menentukan Apakah Bisnis Siap untuk Memperoleh Pinjaman (3))

19

Valuasi Saham (Equity Valuation and Analysis) Part 1

20

Valuasi Saham (Equity Valuation and Analysis) Part 2

21

Bagaimana mencari rata-rata dari suatu data? (Arithmetic dan Geometric Mean)

22

Arithmetic And Geometric Mean Part 1

24

Arithmetic And Geometric Mean Part 2

25

Arithmetic And Geometic Mean Part 3

26

Arithmetic And geometric Mean Part 4

27

Arithmetic And Geometric Mean Part 5.1

28

Arithmetic And Geometric Mean Part 5.2

29

Arithmetic and Geometric Mean Part 6

30

Arithmetic And Geometric Mean Part 7.1

31

Arithmetic And Geometric Mean Part 7.2

32

Arithmetic and Geometric Mean Part 8

33

Warren Buffett"s 2 Golden Rules

34

Training Joint Venture: Structure, Accounting, And Tax

35

DEBT RESTRUCTURING Gain/Loss Or No Gain/Loss (IAS 39) Quantitative Approach Part 1

36

DEBT RESTRUCTURING Gain/Loss Or No Gain/Loss (IAS 39) Quantitative Approach Part 2

37

DEBT RESTRUCTURING Gain/Loss Or No Gain/Loss (IAS 39) Quantitative Approach Part 3

38

DEBT RESTRUCTURING Gain/Loss Or No Gain/Loss (IAS 39) Quantitative Approach Part 4

39

Training financial modeling (+Business Valuation DCF Method) using excel part 1

40

Training financial modeling (+Business Valuation DCF Method) using excel part 2

41

Training financial modeling (+Business Valuation DCF Method) using excel part 3

42

Training financial modeling (+Business Valuation DCF Method) using excel part 4

43

Common error in using the annuity formula when discount rates vary by maturity

44

The difference of flat interest rate and effective interest rate

45

Tutorial Fungsi Offset : Memahami Cara Bekerja Fungsi Offset

46

Tutorial Fungsi Offset : Contoh Penerapan pada Tabel Depresiasi Metode Garis Lurus

47

Tutorial Fungsi Offset : Contoh Penerapan pada Tabel Pembayaran Pinjaman (Bagian 1)

48

Tutorial Fungsi Offset : Contoh Penerapan pada Tabel Pembayaran Pinjaman (Bagian 2)

49

INDEX, IF, CHOOSE, atau OFFSET ? : Fungsi excel yang dipakai untuk memilih alternatif asumsi

50

FUTURUM - Financial Modeling Training (+Business Valuation DCF Method), Jakarta (Teaser 1)

51

FUTURUM - Financial Modeling Training (+Business Valuation DCF Method), Jakarta (Teaser 2)

52

FUTURUM - Financial Modeling Training (+Business Valuation DCF Method), Jakarta (Teaser 3)

53

FUTURUM - Joint Arrangement (Join Operation and Joint Venture) Training , Jakarta Teaser

54

Tutorial Fungsi Solver : Optimalisasi Laba

55

Tutorial Fungsi Solver : Optimalisasi Hari Kerja

56

Tutorial Fungsi Solver : Optimalisasi Distribusi dan Transportasi

57

Tutorial Conditional Formatting

58

Tutorial: Menghitung Bunga Efektif Kredit Tanpa Agunan (KTA)

59

Tutorial: Penggunaan PMT dalam MS Excel

60

Tutorial: Internal & Sustainable Growth Rate

61

Tutorial: Menggunakan Goal Seek untuk Debt Payment

62

Tutorial: Menggunakan Solver untuk Debt Payment Part 1

63

Tutorial: Menggunakan Solver untuk Debt Payment Part 2

64

Tutorial: Measuring Return - DCF or ROI

65

Tutorial: Memilih Skenario Menggunakan Offset & Index

66

Tutorial: Mengatasi Circular Reference pada MS Excel

67

Tutorial: Variasi Pengerjaan Data Table

68

Perbedaan Financial Analysis dan Financial Statement Analysis

69

Tutorial: Menghitung Shareholder Value (Bagian 1)

70

Tutorial: Menghitung Shareholder Value (Bagian 2)

71

Menjelaskan Financial Leverage melalui rumus ROCE dan ROE

72

IRR Series: Menghitung Incremental IRR

73

IRR Series: Bagaimana mendapatkan 2 IRR

74

IRR Series: Kaitan antara nilai IRR dan kapan proyek dijual

75

IRR Series: Savings Bank Analogy Part 1

76

IRR Series: Savings Bank Analogy Part 2

77

IRR Series: Savings Bank Analogy Part 3

78

IRR Series: Savings Bank Analogy Part 4

79

IRR Series: Savings Bank Analogy Part 5

80

Financial Modeling: Analyzing Commercial Property Part 1

81

Financial Modeling: Analyzing Commercial Property Part 2

82

Financial Modeling: Analyzing Commercial Property Part 3

83

Financial Modeling: Analyzing Commercial Property Part 5

84

Financial Modeling: Analyzing Commercial Property Part 6

85

Financial Modeling: Analyzing Commercial Property Part 7

86

Financial Modeling: Analyzing Commercial Property Part 8

87

Financial Modeling: Analyzing Commercial Property Part 9

88

Operating Leverage: Tiga Jenis Break Even Point

89

Incremental Cash Flow Analysis Machine Replacement Part 1 of 4

90

Incremental Cash Flow Analysis Machine Replacement Part 2 of 4

91

Using incremental cost of borrowing to choose mortgage debt offerings

92

Operating Leverage Calculation

93

Value depends on FCF and not Accounting Income Part 1 of 3

94

Value depends on FCF and not Accounting Income Part 2 of 3

95

Value depends on FCF and not Accounting Income Part 3 of 3

96

Understanding Installment Loans using Excel and Manual Calculation 1 of 9

97

Understanding Installment Loans using Excel and Manual Calculation 4 of 9

98

Understanding Installment Loans using Excel and Manual Calculation 7 of 9

99

Understanding Installment Loans using Excel and Manual Calculation 8 of 9

100

Understanding Installment Loans using Excel and Manual Calculation 9 of 9

101

Solving circular reference Algebraic Approach in Project Finance Model Part 1 of 2

102

Solving circular reference Algebraic Approach in Project Finance Model Part 2 of 2

103

Understanding what behind FV Excel formula Part 1 of 2

104

Understanding what behind FV Excel formula Part 2 of 2

105

Average Internal Rate of Return in Project Finance or Real Estate Model (1) Part 1 of 5

106

Average Internal Rate of Return in Project Finance or Real Estate Model (1) Part 2 of 5

107

Average Internal Rate of Return in Project Finance or Real Estate Model (1) Part 3 of 5

108

Average Internal Rate of Return in Project Finance or Real Estate Model (1) Part 4 of 5

109

Average Internal Rate of Return in Project Finance or Real Estate Model (1) Part 5 of 5

110

Average Internal Rate of Return in Project Finance or Real Estate Model (2) Part 1 of 2

111

Average Internal Rate of Return in Project Finance or Real Estate Model (2) Part 2 of 2

112

Calculating Effective Borrowing Interest Rate Part 1 of 5

113

Calculating Effective Borrowing Interest Rate Part 2 of 5

114

Calculating Effective Borrowing Interest Rate Part 3 of 5

115

Calculating Effective Borrowing Interest Rate Part 4 of 5

116

Calculating Effective Borrowing Interest Rate Part 5 of 5

117

Using SUM OFFSET for depreciation calculation in Project Finance Model 1 of 6

118

Using SUM OFFSET for depreciation calculation in Project Finance Model 2 of 6

119

Using SUM OFFSET for depreciation calculation in Project Finance Model 3 of 6

120

Using SUM OFFSET for depreciation calculation in Project Finance Model 4 of 6

121

Using SUM OFFSET for depreciation calculation in Project Finance Model 5 of 6

122

Using SUM OFFSET for depreciation calculation in Project Finance Model 6 of 6

123

Using True False to Find Payback Period in Project Finance Model a of d

124

Using True False to Find Payback Period in Project Finance Model b of d

125

Using True False to Find Payback Period in Project Finance Model c of d

126

Using True False to Find Payback Period in Project Finance Model d of d

127

Using MIRR in Project Finance Model 1 of 5

128

Using MIRR in Project Finance Model 2 of 5

129

Using MIRR in Project Finance Model 3 of 5

130

Using MIRR in Project Finance Model 4 of 5

131

Using MIRR in Project Finance Model 5 of 5

132

Making Monthly Cash Budget Model Part 1 of 4

133

Making Monthly Cash Budget Model Part 2 of 4

134

Making Monthly Cash Budget Model Part 3 of 4

135

Making Monthly Cash Budget Model Part 4 of 4

136

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 1 of 7

137

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 2 of 7

138

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 3 of 7

139

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 4 of 7

140

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 5 of 7

141

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 6 of 7

142

Modeling Fade Rate in Growth Rate Forecasting in Corporate Valuation 7 of 7

143

Understanding How to Get the Arithmetic Mean and CAGR 1 of 8

144

Understanding How to Get the Arithmetic Mean and CAGR 2 of 8

145

Understanding How to Get the Arithmetic Mean and CAGR 3 of 8

146

Understanding How to Get the Arithmetic Mean and CAGR 4 of 8

147

Understanding How to Get the Arithmetic Mean and CAGR 5 of 8

148

Understanding How to Get the Arithmetic Mean and CAGR 6 of 8

149

Understanding How to Get the Arithmetic Mean and CAGR 7 of 8

150

Understanding How to Get the Arithmetic Mean and CAGR 8 of 8

151

Building a simple project finance model 1 of 10

152

Building a simple project finance model 2 of 10

153

Building a simple project finance model 3 of 10

154

Building a simple project finance model 4 of 10

155

Building a simple project finance model 5 of 10

156

Building a simple project finance model 6 of 10

157

Building a simple project finance model 7 of 10

158

Building a simple project finance model 8 of 10

159

Building a simple project finance model 9 of 10

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

Building a simple project finance model 10 of 10

Modeling a Simple Capital Budgeting for Power Plant Case Study 1 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 2 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 3 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 4 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 8 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 9 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 11 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 19 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 20 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 21 of 22

Modeling a Simple Capital Budgeting for Power Plant Case Study 22 of 22

Financial Modeling Terminal Value in Business Valuation Model 1 of 11

Financial Modeling Terminal Value in Business Valuation Model 2 of 11

Financial Modeling Terminal Value in Business Valuation Model 3 of 11

Financial Modeling Terminal Value in Business Valuation Model 4 of 11

Financial Modeling Terminal Value in Business Valuation Model 4 of 11

Financial Modeling Terminal Value in Business Valuation Model 9 of 11

Financial Modeling Terminal Value in Business Valuation Model 10 of 11

Financial Modeling Terminal Value in Business Valuation Model 11 of 11

Integrating Scenario into Corporate Model 1 of 6

Integrating Scenario into Corporate Model 2 of 6

Showing Header Name Using Sheet Name

Building a Good Financial Model 1 of 20

Building a Good Financial Model 2 of 20

Building a Good Financial Model 3 of 20

Building a Good Financial Model 4 of 20

Building a Good Financial Model 5 of 20

Building a Good Financial Model 6 of 20

Building a Good Financial Model 10 of 20

Building a Good Financial Model 11 of 20

Building a Good Financial Model 14 of 20

Building a Good Financial Model 14 of 20

Building a Good Financial Model 16 of 20

Building a Good Financial Model 18 of 20

Building a Good Financial Model 19 of 20

Building a Good Financial Model 20 of 20

Using Market Model to Calculate Beta Estimate 1 of 7

Using Market Model to Calculate Beta Estimate 2 of 7

Using Market Model to Calculate Beta Estimate 3 of 7

Using Market Model to Calculate Beta Estimate 4 of 7

Using Market Model to Calculate Beta Estimate 5 of 7

Using Market Model to Calculate Beta Estimate 6 of 7

Using Market Model to Calculate Beta Estimate 7 of 7

Financial Modeling Analyzing Commercial Property Part 4

Comparing Profitability Index and Solver result under Headcount constraint 2 of 2

Comparing Profitability Index and Solver result under Headcount constraint 1 of 2

Comparing Profitability Index and Solver result under Capital Constraint