Introduction
  • Introduction
  • A little bit about me
  • How to deal with Blurry image
  • How to reach additional resources
Essential Concepts
  • Essential Concepts
  • Time value of money
  • Time value of money – in Excel
  • NPV – Introduction
  • NPV – How to use it
  • IRR
  • NPV – How to calculate it in Excel
  • Cost reduction Investment – Ceramic Tiles – Introduction
  • Cost reduction Investment – Ceramic Tiles – Current Costs
  • Cost reduction Investment – Ceramic Tiles – Future Costs
  • Cost reduction Investment – Ceramic Tiles – NPV
  • Cost reduction Investment – Ceramic Tiles – Solution in Power Point
Cash Flow
  • Cash Flow – Introduction
  • What is the purpose of Cash Flow
  • 3 parts of Cash Flow
  • Cash Flow from Operating Activities
  • Cash Flow from Investing
  • Cash Flow from Financing
  • Cash Flow statement example – Amazon
Essential Valuation Techniques
  • Valuation Case study – Introduction
  • Introduction to Valuation
  • Introduction to DCF method
  • Difference between FCFF and FCFE
  • DCF method of valuation applied to FCFF
  • DCF method of valuation applied to FCFE
  • Introduction to using multipliers for valuation
  • Enterprise to EBIT or EBITDA
  • Price per Earning multiplier
Financial Modeling
  • Cosmetics E-commerce – Case Introduction
  • Cosmetics E-commerce – Data Available
  • Cosmetics E-commerce – Sales & Margin & Head Office Costs
  • Cosmetics E-commerce – P&L
  • Cosmetics E-commerce – How to get from Net Profit to Cash Flow
  • Cosmetics E-commerce – Some comments on Working Capital
  • Cosmetics E-commerce – Back to Excel
  • Cosmetics E-commerce – Working Capital, Capex, Debt
  • Cosmetics E-commerce – Cash Flow
  • More on Valuation
Conclusions
  • Bonus Lecture