Corporate Finance Cheat Sheet

Let the figures speak!

Comprehensive financial model to learn essentials of corporate finance. 

Learn crucial finance principles given through real example and calculations. 

What is included:

Getting started: Financial statement presentation

• Balance sheet
• Profit and Loss account
• Cash flow statement (indirect method)

Historical Ratio analysis

• Liquidity ratios
• Profitability ratios
• Activity / efficiency ratios
• Ratios of financial structure
  

Revenue forecast

Cogs forecast

Fixed and variable overhead cost forecast

Net working capital forecast

• DSO calculation
• DPO calculation
• DIO calculation
• Account receivable forecast
• Account payable forecast
• Inventories forecast

CAPEX forecast

• Forecast of tangible and intangible assets
• Forecast of depreciation and amortization

Financial liabilities forecast

Balance sheet forecast

P&L forecast

Cash flow statement forecast

Breakeven forecast

Vertical P&L analysis

Horizontal P&L analysis

Weighted average cost of capital (WACC) forecast

Valuation based on discounted cash flows

Format available: PDF

NOTE: Excel model and detailed guide will be new product published until July 30, 2023.