【4時間で分かる】エクセルで学ぶ企業価値評価(ファイナンス)基礎コース

Understanding Finance & Analysis: This section provides a simple introduction to core financial concepts and analysis techniques. We'll explore the differences between accounting and finance, and delve into the relationship between stock value and stock price.

Comparable Company Analysis: Learn how to estimate company value by comparing it to similar businesses. We'll examine this approach with case studies in the sundry trading company and apparel industry. Discover how even struggling companies can be valued. We'll also analyze the connection between growth rate and Price-to-Earnings Ratio (PER), and get a realistic look at stock valuation.

Discounted Cash Flow (DCF) Modeling: Master the DCF model, a powerful tool for calculating a company's worth based on projected future earnings. We'll break down essential financial metrics like free cash flow, discount rate, and terminal growth rate. Understand how to calculate enterprise value and equity value using DCF. The advanced portion covers sensitivity analysis, case analysis, and creating football charts.

Conclusion: Pros & Cons & Investment Strategies: We'll summarize the advantages and disadvantages of the analysis methods discussed. Understand why DCF calculations often result in higher estimated stock values. Finally, explore how different investment styles align with various analytical approaches.