Financial Modeling Formulas for Balance Sheet and P&L
Classified in Economy
Written on in
English with a size of 3.95 KB
Balance Sheet Assets
Total Assets = Non-current assets + Current assets
- Net non-current assets = Gross asset + Accumulated amortization
- Gross asset = Gross asset (past year) + Capex
- Accumulated amortization = Gross asset * Cost of debt
- Current assets = Customer receivables + Inventory + VAT recoverable + Total cash
- Customer receivables = (Revenue / 12) * Average receivable periods (months) * (1 + VAT rate)
- Inventory = (Average supplier periods (days) * (Quantity (B) * Unit cost sale (B) + Quantity (A) * Unit cost sale (A))) / 360
- VAT recoverable = If Output VAT – Input VAT < 0; then Output VAT – Input VAT
- Total cash = Operating cash + Non-operating cash
- Operating cash = Provided in statement
- Non-operating cash = Past year + FCe