Docstoc

calculator

Document Sample
calculator Powered By Docstoc
					REVENUE PROJECTIONS: CALCULATOR

To calculate scenerios, please fill inputs in Yellow cells




REVENUE:                                                     Month 1    Month 2    Month 3    Month 4    Month 5    Month 6    Month 7    Month 8    Month 9    Month 10    Month 11   Month 12
Number of active kiosks (#):                                       0          1          1          1          1          1          2          2          2           2           2          2
Number of daily payments per kiosk (#):                            0        100        100        150        150        150        150        150        150         150         150        150
Average amount of one payment, (USD):                          $0.00      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50       $4.50       $4.50      $4.50
Fee charged from payers (% of payment amount):                  0.0%       4.5%       4.5%       4.5%       4.5%       4.5%       4.5%       4.5%       4.5%        4.5%        4.5%       4.5%
Revenue shared by iCAN (% of payment amount):                   0.0%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%        0.6%        0.6%       0.6%
Generated monthly turnover:                                        0     13,500     13,500     20,250     20,250     20,250     40,500     40,500     40,500      40,500      40,500     40,500
Total monthly revenue:                                             0        689        689      1,033      1,033      1,033      2,066      2,066      2,066       2,066       2,066      2,066

COSTS:                                                       Month 1    Month 2    Month 3    Month 4    Month 5    Month 6    Month 7    Month 8    Month 9    Month 10    Month 11   Month 12
Number of kiosks purchased:                                        1          0          0          0          0          1          0          0          0           0           0          0
Price per 1 kiosk:                                             4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500       4,500       4,500      4,500
Set-up package (delievery, instalation, "iCAN turn-key"):        500          0          0          0          0      1,000          0          0          0           0           0          0
Rent of space per 1 kiosk (0,5-1m2):                               0        120        120        120        120        120        120        120        120         120         120        120
Internet traffic (GPRS) per 1 kiosk:                               0         20         20         20         20         20         20         20         20          20          20         20
Encashment related costs per 1 kiosk:                              0         50         50         50         50         50         50         50         50          50          50         50
Kiosk servicing (paper replacement) per 1 kiosk:                   0         30         30         30         30         30         30         30         30          30          30         30
Bank fee (0,1%) of cash deposited):                                0         14         14         20         20         20         41         41         41          41          41         41
Total monthly costs:                                           5,000        234        234        240        240      5,740        481        481        481         481         481        481


Income before taxes:                                          -5,000        455        455        793        793     -4,708      1,585      1,585      1,585       1,585       1,585      1,585
Less: Тахеs:                                                    6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%        6.0%        6.0%       6.0%
Net income after tax:                                         -5,000        428        428        745        745     -4,708      1,490      1,490      1,490       1,490       1,490      1,490
Cumulative income:                                           ($5,000)   ($4,572)   ($4,145)   ($3,400)   ($2,655)   ($7,362)   ($5,872)   ($4,382)   ($2,893)    ($1,403)       $87      $1,577
Month 13   Month 14   Month 15   Month 16   Month 17   Month 18   Month 19   Month 20   Month 21   Month 22   Month 23   Month 24   Month 25   Month 26   Month 27   Month 28   Month 29
       2          2          2          3          3          3          3          4          4          4          5          5          5          5          7          7          7
     150        150        150        150        150        150        150        150        150        150        150        150        150        150        150        150        150
   $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50
    4.5%       4.5%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%
    0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%
  40,500     40,500     40,500     60,750     60,750     60,750     60,750     81,000     81,000     81,000    101,250    101,250    101,250    101,250    141,750    141,750    141,750
   2,066      2,066      2,268      3,402      3,402      3,402      3,402      4,536      4,536      4,536      5,670      5,670      5,670      5,670      7,938      7,938      7,938

Month 13   Month 14   Month 15   Month 16   Month 17   Month 18   Month 19   Month 20   Month 21   Month 22   Month 23   Month 24   Month 25   Month 26   Month 27   Month 28   Month 29
       0          0          1          0          0          0          1          0          0          1          0          0          0          2          0          0          0
   4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500
       0          0      1,000          0          0          0      1,000          0          0      1,000          0          0          0      2,000          0          0          0
     120        120        120        120        120        120        120        120        120        120        120        120        120        120        120        120        120
      20         20         20         20         20         20         20         20         20         20         20         20         20         20         20         20         20
      50         50         50         50         50         50         50         50         50         50         50         50         50         50         50         50         50
      30         30         30         30         30         30         30         30         30         30         30         30         30         30         30         30         30
      41         41         41         61         61         61         61         81         81         81        101        101        101        101        142        142        142
     481        481      5,981        721        721        721      6,221        961        961      6,461      1,201      1,201      1,201     14,201      1,682      1,682      1,682


   1,585      1,585     -3,713      2,681      2,681      2,681     -2,819      3,575      3,575     -1,925      4,469      4,469      4,469     -8,531      6,256      6,256      6,256
    6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%
   1,490      1,490     -3,713      2,520      2,520      2,520     -2,819      3,361      3,361     -1,925      4,201      4,201      4,201     -8,531      5,881      5,881      5,881
  $3,067     $4,557      $844      $3,365     $5,885     $8,406     $5,587     $8,947    $12,308    $10,383    $14,584    $18,784    $22,985    $14,454    $20,334    $26,215    $32,096
Month 30   Month 31   Month 32   Month 33   Month 34   Month 35   Month 36   Month 37
       7         10         10         10         10         10         10         10
     150        150        150        150        150        150        150        150
   $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50      $4.50
    5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%       5.0%
    0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%       0.6%
 141,750    202,500    202,500    202,500    202,500    202,500    202,500    202,500
   7,938     11,340     11,340     11,340     11,340     11,340     11,340     11,340

Month 30   Month 31   Month 32   Month 33   Month 34   Month 35   Month 36   Month 37
       3          0          0          0          0          0          0          0
   4,500      4,500      4,500      4,500      4,500      4,500      4,500      4,500
   3,000          0          0          0          0          0          0          0
     120        120        120        120        120        120        120        120
      20         20         20         20         20         20         20         20
      50         50         50         50         50         50         50         50
      30         30         30         30         30         30         30         30
     142        203        203        203        203        203        203        203
  24,182      2,403      2,403      2,403      2,403      2,403      2,403      2,403


 -16,244      8,938      8,938      8,938      8,938      8,938      8,938      8,938
    6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%       6.0%
 -16,244      8,401      8,401      8,401      8,401      8,401      8,401      8,401
 $15,852    $24,254    $32,655    $41,056    $49,457    $57,859    $66,260    $74,661

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:9/26/2012
language:Unknown
pages:3