Career Principles – The Complete Finance & Valuation + AI

Here’s What You Get:

This course will teach you the basics of financial accounting, finance, and how to perform the three main valuation methods: Discounted Cash Flow, Comparable Companies, and Precedent Transactions – all on Excel. Throughout the course, you’ll learn the theory, followed by practical exercises in the form of case studies to replicate the type of work you may encounter as an intern or full-time working professional. Case studies range from forecasting a company’s financial statements, to creating full valuation models on real companies such as Apple.

• 80+ High Quality Lessons
• Downloadable Excel and PDF files
• Full Valuation on Apple Using Real Financial Statements
• Lifetime Access on Any Device

Module 1: Course Introduction

• Course Introduction
• Excel Computer Settings
• Course Resource: Excel Shortcuts
• Course Resource: Excel Formulas Glossary
• Course Resource: Finance and Accounting Cheat Sheet
• Course Resource: Finance and Valuation Glossary
• Common Interview Questions in Finance

Module 2: Financial Accounting

• The 3 Financial Statements
• The Income Statement
• Apple Income Statement Analysis
• The Cash Flow Statement
• Apple Cash Flow Statement Analysis
• The Balance Sheet
• Apple Balance Sheet Analysis
• Building a Cash Flow Statement Steps
• Case Study: Building a Cash Flow Statement from Scratch
• Financial Accounting Quiz

Module 3: Financial Statement Analysis

• Introduction to Financial Ratios
• Profitability Ratios
• Profitability Ratios Exercise
• Liquidity Ratios
• Liquidity Ratios Exercise
• Activity Ratios
• Activity Ratios Exercise
• Leverage Ratios
• Leverage Ratios Exercise
• Finance Ratios Quiz
• Case Study: Analyzing Company and Industry Ratios

Module 4: Three Statement Model

• Excel Financial Modeling Best Practices
• 3 Statement Model Introduction
• Gathering the Relevant Data
• Setting up the Income Statement
• Filling in the Income Statement
• Setting up the Balance Sheet
• Filling in the Balance Sheet
• Income Statement Assumptions
• Income Statement Forecast
• Scenario Analysis
• Balance Sheet Forecast
• Cash Flow Statement
• Fixed Assets Schedule
• Retained Earnings Schedule
• Revolver Setup
• Interest Income / Expense
• Model Circularity

Module 5: Discounted Cash Flow Valuation

• Discounted Cash Flow Introduction
• Time Value of Money
• Time Value of Money Quiz
• Free Cash Flow
• Enterprise Value & Equity Value
• Enterprise Value and Equity Value Quiz
• Weighted Average Cost of Capital (WACC) Pt 1
• Weighted Average Cost of Capital (WACC) Pt 2
• Optional: Advanced Beta Calculation Method
• WACC Quiz
• Discounting Cash Flows
• Treasury Stock Method & Implied Share Price
• Treasury Stock Method Quiz
• Terminal Value & Sensitivity Analysis Pt 1
• Sensitivity Analysis Pt 2
• Optional: Goal Seek Analysis

Module 6: Complete DCF Valuation on Apple

• Apple DCF Introduction
• Calculating the UFCF
• WACC Part 1
• WACC Part 2
• Terminal Value Exit Multiple Method
• Terminal Value Growth Perpetuity Method
• Enterprise Value to Equity Value
• Shares Outstanding & Implied Share Price
• Sensitivity Table

Module 7: Comparable Companies Valuation

• Comparable Companies Introduction
• Common Comps Multiples
• Where to Find Comparable Companies
• Gathering the Relevant Financials
• Calculating the Multiples
• Calculating the Implied Share Price
• Comparable Companies Football Field Chart

Module 8: Precedent Transactions Valuation

• Precedent Transactions Introduction
• Synergies & Control Premiums
• Finding Relevant Transactions
• Fairness Opinions (Form S-4)
• Screening for Transactions
• Spreading the Multiples
• Full Valuation Football Field Chart

Module 9: Stock Pitch & Football Field

• What is a Stock Pitch
• Stock Pitch Presentation
• Next Steps