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