Index

Input Sheets Content
Products and Sales Details Per Product - Volumes, Sell Prices, Cost prices
   
Fixed Expenses Alphabetical List of Fixed Expenses
  Specific Fixed Expense Schedules
   
Variable Expenses Schedule for specific variable expenses drivers
   
Capex Schedule of Purchased Fixed Assets
  Schedule of Leased Assets
   
Funding Details of Capital and Loans
   
Deposits Deposit Schedule
   
Settings - Schedule of Operating Parameters Sales - Cash /Credit mix
  Bank - Interest rates - Overdraft /Credit Balance
  Working Capita l Terms, Debtors, Creditors, Stock
  Tax Rate
  Dividend %
  Shareholder Cost of Capital
 
   
   
Output Schedules Content
 
IS Schedules Sales analysis by payment
  Variable Expenses
  Bank Interest - Overdraft and Credit Balance
   
BS Schedules Schedules for Debtors, Stock and Creditors
  Fixed assets - at Cost
  Accumulated Depreciation
  Deposits
  Financing Loans
   
Tax Schedule Normal Tax
  Provision for Tax
  Dividends
  Free ash Flow Tax Calculation
 
Financial Statements Content
Income Statement  
EBT Earnings before tax
EBIT Earnings before interest and taxes
EBITDA Earnings before interest, taxes, depreciation and amortization
PAT Profits after tax
Cash Flow  
FCF Free Cash Flow
   
   
Balance Sheet  
NCA Net Current Assets - Current assets less Current Liabilities
   
KFIs Content
Break-even Break-even turnover level - no profit or loss
CFADS Cash Flow after Debt Servicing ( FCF)
Dividend IRR Dividends received in relation to Capital Invested
NPV Net Present Value
Payback Period of time required to recoup capital employed based on FCF
Project IRR Internal rate on return (based on free cash flow after tax)
WACC % Weighted average cost of capital used to calculate NPV
 
 
Analysis
Key Financial Indicators
Sensitivity Specific Sheet
Scenario Control Available on all Sheets