Extensive granularity for complex forecasting/modeling needs. Line items included:
β
Income Statement
Net Sales
Changes in Inventories, (FG, WIP)
Own work capitalized
Total turnover
Cost of goods sold (COGS)
Cost of purchased services
Gross Profit
Personnel expenses
Operating expenses
Result from consortia, working groups
Depreciation & Amortisation (D&A)
EBIT (Operating income)
Interest income
Interest expense
Earnings Before Taxes and Extraordinary Items
Extraordinary income
Extraordinary expenses
EBT
Tax
NET INCOME
β
Cashflow Statement
Net income
Depreciation & Amortisation (D&A)
Gross operating cashflows
Change in Accounts receivable
Change in Inventories
Change in Other receivables, deferred expenses
Change in Other current assets
Change in Accounts payable
Change in Other liabilities, deferred income
Change in Other current liabilities
Change in NWC
CASHFLOW FROM OPERATIONS
Capex
Change in Intangible assets
Change in Investments
Change in Prepayments, construction in progress
Change in Other non-current assets
CASHFLOW FROM INVESTMENTS
Change in Debt
Change in Other non-current liabilities
Change in Equity
Dividends paid
Cashflow from Financing (before RCF)
Revolving Credit Facility, Drawdown/(Repayment)
CASHFLOW FROM FINANCING
NET CASH MOVEMENT FOR THE PERIOD
Cash & cash equivalents opening balance
CASH & CASH EQUIVALENTS CLOSING BALANCE
Balance Sheet
Cash & cash equivalents
Accounts receivable
Inventories
Other receivables, deferred expenses
Other current assets
Total current assets
Intangible assets
Investments
Fixed assets
Prepayments, construction in progress
Other non-current assets
Total non-current assets
TOTAL ASSETS
Accounts payable
Other liabilities, deferred income
Other current liabilities
Total current liabilities
Revolving Credit Facility
Debt
Other non-current liabilities
Total non-current liabilities
TOTAL LIABILITIES
Book equity
TOTAL LIABILITIES & EQUITY
β
Fixed asset schedule
Opening balance
Capex
Depreciation & Amortisation (D&A)
Closing balance
Equity schedule
Opening balance
Net income
Change in Equity
Dividends paid
Closing balance
Debt schedule
Input of Debt maturities
Opening balance
Redemption based on Input Debt Maturity
Additional Debt Issuance / Repayments
Transfer from long-term debt (Internal)
Consolidated short-term debt, Closing balance
Opening balance
Additional Debt Issuance / Repayments
Transfer to short-term debt (Internal)
Consolidated long-term debt, Closing balance
TOTAL DEBT
Cash & RCF schedule
Minimum cash balance
Cash & cash equivalents, Opening balance
Cashflow from Operations
Cashflow from Investments
Cashflow from Financing (before RCF)
Cash & cash equivalents (before RCF)
Revolving Credit Facility, Drawdown/(Repayment)
CASH & CASH EQUIVALENTS, CLOSING BALANCE
Revolving Credit Facility, Opening balance
Revolving Credit Facility, Drawdown/(Repayment)
REVOLVING CREDIT FACILITY, CLOSING BALANCE