forecasting, presentations,
How It Works
Investment Banking
Recommended study time of - hours
Corporate Development
+ downloadable templates
Equity Research
Average completion time of 6 months
Financial Modeling
Accounting Fundamentals
Presentation
●
Excel Crash Course
& Visuals ●
Scenario and sensitivity analysis
(8%)
●
Introduction to Corporate Finance
●
Monthly cash flow forecasting
Forecasting (23%)
●
Capital IQ Fundamentals
(8%) ●
Leveraged Buyout (LBO)
(10%)
Core Courses (required)
●
●
Financial Analysis Fundamentals
Finance
Excel
●
Accounting Principles and Standards
●
Professional Ethics
●
Present value, future value, net present ●
Functions and formulas (XNPV, XIRR, PMT,
value, terminal value
IPMT, VLOOKUP, CHOOSE, INDEX MATCH
●
Building a 3 Statement Financial
Annuities and perpetuities
MATCH, OFFSET)
Model
Capital markets
●
Auditing tools (tracing precedents/dependents,
Business Valuation Modeling Part I
●
Business Valuation Modeling Part II
●
Capital raising process — Initial Public
Offering (IPO)
●
Data validation, data table, goal seek
●
Budgeting and Forecasting
●
Capital structure — debt financing, equity
●
●
FP&A Monthly Cash Flow Forecast
financing
Model
●
Bond pricing, par value, coupon rate, yield Budgeting & Forecasting
●
Scenario and Sensitivity Analysis
to maturity
●
Incremental, activity based, value proposition,
●
Dashboard and Data Visualization
Valuation
●
Break-even analysis, margin of safety
●
Comps analysis
●
Quantitative forecasting — moving average,
●
Precedents analysis
simple and multiple linear regression
●
The Amazon Case Study
●
Variance analysis
●
Discounted cash flow (DCF) analysis
●
Advanced Excel Formulas
●
●
Real Estate Financial Modeling
consolidate, pivot tables
●
Enterprise value, equity value multiples
●
Start-up/e-Commerce Financial ●
Free Cash Flow to the Firm (FCFF) and Free
Model and Valuation
Presentations & Visuals
●
Mining Financial Model and ●
Dynamic charts and graphs (football field
●
Net Present Value (NPV) and Internal Rate
Valuation
chart, waterfall chart, tornado chart, gravity
of Return (IRR)
●
Renewable Energy - Solar Financial sort table, gauge chart, bullet charts,
●
Sum-of-the-Parts (SOTP)
Modeling
sparklines, combo chart)
●
Leveraged Buyout LBO Modeling
●
Professional pitch decks
Accounting
●
Mergers and Acquisitions (M&A) ●
Financial dashboards
Modeling
●
Balance sheet, income statement, cash
flow statement
●
Corporate and Business Strategy
Strategy
●
Assets, liabilities, shareholders’ equity
●
Strategic analysis process
●
Financial transactions
●
Corporate, business, functional-level strategy
Template Library
●
Prepayments, accrued expenses,
unearned revenue
●
PEST and Porter’s 5 forces
●
Operating cash flow, investing cash flow,
financing cash flow
●
Key Performance Indicators (KPIs)
●
Depreciation methods
●
SWOT analysis and lifecycle analysis
●
Working capital
●
Market segmentation and Porter’s generic
● Property, Plant and Equipment (PP&E) and strategies
аналитика форекс gbp кaртa мирa форекс вспомогательные индикаторы форекс как платят налоги трейдеры валютного рынка форекс лучшие индикаторы для входа индикаторы измерения температуры щитовые дмитрий котенко форекс клипaрт для форекс имхо на форексе дц форекс брокер отзывы безрисковая комбинация форекс индикаторы рынка ферросплавов