Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling with Excel
วิธีการเรียน และ ไฟล์แบบฝึกหัดระหว่างเรียน
วิธีการเรียน (2:51)
ไฟล์ตัวอย่างระหว่างเรียน
Review Data Types and Essential Functions for Finance
Chapter1-Review Data Types (30:01)
Chapter2-Creating Automatic Depreciation Table (10:53)
Chapter3-Essential Functions in Excel (30:08)
Chapter4-Financial Functions in Excel (38:04)
Calculating Cost of Capital ( WACC }
Chapter5-WACC Calculation and Beta Estimation (31:17)
Financial Analysis Tools
Chapter6-Scenario Analysis (20:24)
Chapter7(1)-Sensitivity Analysis 1 Variable and 2 Variables (21:08)
Chapter7(2)-Sensitivity Analysis more than 2 Variables (10:03)
Chapter7(3)-Sensitivity Analysis Across Worksheets (9:09)
Chapter8-Risk analysis with Tornado Chart (22:59)
Solving Business Problems with Goal Seek and Solver
Chapter9-Goal Seek (17:03)
Chapter10(1)-Solver (19:30)
Chapter10(2)-Solver-Optimization (26:45)
Project Valuation
Chapter11-Capital Budgeting Functions (24:55)
Chapter12-Using Circular Reference Calculation (5:53)
Chapter13(1)-Calculate Debt and IDC ( Interest During Construction ) with Goal Seek | 1-year Construction Period (16:38)
Chapter13(2)-Calculate Debt and IDC ( Interest During Construction ) with Circular Reference Calculation | 1-year Construction Period (4:38)
Chapter13(3)-Calculate Debt and IDC ( Interest During Construction ) with Goal Seek | Construction Period More Than 1 Year (8:52)
Chapter13(4)-Calculate Debt and IDC ( Interest During Construction ) with Circular Reference Calculation | Construction Period More Than 1 Year (5:39)
Chapter13(5)-Calculate Debt and IDC ( Interest During Construction ) with VBA Macros (13:58)
Chapter14-Project Valuation | From assumptions to Financial Statements and Free Cash Flows Estimation (95:46)
Leasing Analysis
Chapter15-The Financial Analysis of Leasing (32:42)
Corporate Valuation and Financial Statement Modeling
Chapter16-Financial Statement Modeling (53:54)
Chapter17(1)-Corporate Valuation | Discounted Free Cash Flows Method (29:57)
Chapter17(2)-Evaluate Stock Price with Reverse Free Cash Flows Method (6:03)
Post-Test
Post-Test
Chapter8-Risk analysis with Tornado Chart
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock