Long-Term Trend Analysis & Charts Help
Print Reports (#3) & Charts
Years: -4 -3 -2 -1 04-05 05-06 06-07 07-08 08-09 09-10
No. of Months in Year: 12 12 12 12 12 12 12 12 12 12
INCOME STATEMENTS $000 $000 $000 $000 $000 $000 $000 $000 $000 $000
  Act Act Act Act Est Proj Proj Proj Proj Proj
           
Sales   200 1,000 2,313 4,681 6,746 8,045 9,252 10,177
Cost of sales   150 600 1,350 2,688 3,874 4,544 5,273 5,597
Gross margin     50 400 963 1,993 2,872 3,501 3,978 4,580
           
Overhead expenses   200 400 990 2,106 1,962 2,188 2,400 2,600
Bad debts   2 10 5 23 42 58 40 45
Depreciation   15 35 50 110 155 190 238 279
Operating lease payments   20 40 45 66 72 72 80 90
Total operating expenses     237 485 1,090 2,306 2,231 2,508 2,758 3,014
 
Income from operations (187) (85) (127) (313) 641 993 1,221 1,566
 
Other income/expenses:          
 -Profit (loss) fixed asset disposals     80 125 85 85  
 -Intangible asset amortization     60 2  
 -Miscellaneous income   20 40 75 120 120 120 200 230
Total other income (expenses)     20 40 75 140 243 205 285 230
   
Earnings before interest/taxes (167) (45) (52) (173) 884 1,198 1,506 1,796
   
Interest expense/income:          
 -Interest expense   35 29 57 71 91 82 91 91
 -Lease interest expense   20 41 55 75 40 40 30 30
 -Interest income   1 2 2 12 36 68 110
Net interest expense (income)     55 69 110 144 120 86 53 12
   
Net income before taxes     (222) (114) (162) (317) 764 1,112 1,453 1,785
Taxes     53 89 116 143
Net income     (222) (114) (162) (317) 710 1,023 1,336 1,642
Dividends declared     125 150 140
Transferred to reserves     (222) (114) (162) (317) 710 898 1,186 1,502
 
 
Years: (4) (3) (2) (1) 04-05 05-06 06-07 07-08 08-09 09-10
                     
BALANCE SHEETS $000 $000 $000 $000 $000 $000 $000 $000 $000 $000
  Act Act Act Act Est Proj Proj Proj Proj Proj
   
ASSETS  
Current assets:          
  Cash at bank   10 483 1,316 2,074 3,431
  Accounts receivable   285 608 852 974 1,141 1,255
  Inventory   290 396 568 649 760 836
  Prepaid expenses   75 65 60 60 60 60
  Sales Tax recoverable     #REF!
Total current assets         660 1,069 1,963 2,999 4,035 5,582
           
Net fixed assets   675 1,140 1,270 1,620 1,817 1,939
           
Net intangible assets   70 10 8 8 8 8
           
Total assets 1,405 2,219 3,241 4,627 5,861 7,529
   
LIABILITIES  
Current liabilities:          
  Accounts payable   210 379 480 538 673 719
  Capital expenditure creditors   45 300 53 45
  Accrued expenses   30 10 10 10 10 10
  Payroll taxes/benefits   25 69 69 69 69 69
  Dividends     75 101 94
  Taxes     53 89 116 143
  Sales Tax payable   20 31 66 76 83 91
  Short-term loans/line of credit   120 148  
  Current portion of longterm liabilities:          
      Longterm debt/notes   100 163 275 325 325 325
      Other loans   25 30 99 83 99 116
      Lease debt   90 48 54 42 57 72
Total current liabilities         665 877 1,107 1,605 1,584 1,682
   
Longterm liabilities:          
  Longterm debt/notes   100 488 275 325 325 325
  Other loans   25 120 201 168 201 235
  Lease debt     111 125 97 132 167
Total longterm liabilities         125 719 601 590 658 727
   
Equity:          
  Equity investments   850 1,175 1,375 1,375 1,375 1,375
  Retained earnings   (235) (552) 158 1,057 2,243 3,745
Total owners' equity         615 623 1,533 2,432 3,618 5,120
 
Total liabilities & equity 1,405 2,219 3,241 4,627 5,861 7,529
                     
CHECK balance sheets balance ->>         0.000 0.000 0.000 0.000 0.000 0.000
Years: -4 -3 -2 -1 04-05 05-06 06-07 07-08 08-09 09-10
No. of Months in Year: 12 12 12 12 12 12 12 12 12 12
PERFORMANCE REVIEW Act Act Act Act Est Proj Proj Proj Proj Proj
(All ratios annualised)  
Months per year factor 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
   
As % total sales:  
 -Gross margin n/a n/a 25.0 40.0 41.6 42.6 42.6 43.5 43.0 45.0
 -Income from operations n/a n/a n/a n/a n/a n/a 9.5 12.3 13.2 15.4
 -Net income before taxes n/a n/a n/a n/a n/a n/a 11.3 13.8 15.7 17.5
   
Projected sales as % breakeven n/a n/a 21 82 88 86 129 140 144 152
Headcount   115 154 163 168 170
             
Changes over previous year (%):  
 -Sales - n/a n/a 400 131 102 44 19 15 10
 -Net income before taxes - n/a n/a n/a n/a n/a n/a 46 31 23
 -Transfers to reserves - n/a n/a n/a n/a n/a n/a 26 32 27
 -Owner's equity - n/a n/a n/a n/a 1 146 59 49 42
 -Dividends per share - n/a n/a n/a n/a n/a n/a n/a 20 (7)
 -Earnings per share - n/a n/a n/a n/a n/a n/a 39 31 23
   
Net income before taxes/total assets (% pa) n/a n/a n/a n/a n/a n/a 23.6 24.0 24.8 23.7
Return on owners' equity (% pa) n/a n/a n/a n/a n/a n/a 46.3 42.1 36.9 32.1
   
Annual sales/total assets (times) n/a n/a n/a n/a 1.6 2.1 2.1 1.7 1.6 1.4
Annual sales/net fixed assets (times) n/a n/a n/a n/a 3.4 4.1 5.3 5.0 5.1 5.2
   
Net debt as percentage of  
  owners' equity n/a n/a n/a n/a 59 152 24 n/a n/a n/a
Interest cover (times) n/a n/a n/a n/a n/a n/a 10.6 25.4 64.2 n/a
   
Current asset ratio (times) n/a n/a n/a n/a 1.0 1.2 1.8 1.9 2.5 3.3
   
Accounts receivable (days sales) n/a n/a n/a n/a 45 47 46 44 45 45
Inventory (days sales) n/a n/a n/a n/a 46 31 31 29 30 30
Accounts payable (days costs & expenses) n/a n/a n/a n/a 33 29 30 29 32 32
           
Cumulative issued shares (000s)   500 615 665 665 665 665
Net assets per share ($) n/a n/a n/a n/a 1.23 1.01 2.31 3.66 5.44 7.70
Earnings per share ($) n/a n/a n/a n/a n/a n/a 1.11 1.54 2.01 2.47
Dividend per share ($) n/a n/a n/a n/a n/a n/a n/a 0.19 0.23 0.21
Dividend cover (times) n/a n/a n/a n/a n/a n/a n/a 8.2 8.9 11.7
Long-Term Trend Charts
Chart Values - These items will not be printed  
Any Corp Inc - Sales & Income  
Years: -4 -3 -2 -1 04-05 05-06 06-07 07-08 08-09 09-10
Sales     200 1,000 2,313 4,681 6,746 8,045 9,252 10,177
Gross margin     50 400 963 1,993 2,872 3,501 3,978 4,580
Income from operations     (187) (85) (127) (313) 641 993 1,221 1,566
Net income before taxes      (222) (114) (162) (317) 764 1,112 1,453 1,785
Any Corp Inc - Cashflow  
Years: -4 -3 -2 -1 04-05 05-06 06-07 07-08 08-09 09-10
Net cash balance (deficit)         (110) (148) 483 1,316 2,074 3,431
Net cashflow n/a       (110) (38) 631 832 759 1,357
Any Corp Inc - Key Indicators  
Years: -4 -3 -2 -1 04-05 05-06 06-07 07-08 08-09 09-10
Net income before taxes (% sales) n/a n/a n/a n/a n/a n/a 11.3 13.8 15.7 17.5
Gross margin (% sales) n/a n/a 25.0 40.0 41.6 42.6 42.6 43.5 43.0 45.0
Net income before taxes as % total assets n/a n/a n/a n/a n/a n/a 23.6 24.0 24.8 23.7
Net debt as % owners' equity (right axis) n/a n/a n/a n/a 59 152 24 n/a n/a n/a
Any Corp Inc - Financial Ratios  
Years: -4 -3 -2 -1 04-05 05-06 06-07 07-08 08-09 09-10
Annual sales/total assets n/a n/a n/a n/a 1.6 2.1 2.1 1.7 1.6 1.4
Current asset ratio n/a n/a n/a n/a 1.0 1.2 1.8 1.9 2.5 3.3
Interest cover n/a n/a n/a n/a n/a n/a 10.6 25.4 64.2 n/a