Profit and Loss Forecast(millions of $USD) 12 first years
Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL($M) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GROSS INCOME | |||||||||||||
Cash Sales, see years 1-3 cash sales | 240,000 | 240,000 | 240,000 | 240,000 | 480,000 | 480,000 | 480,000 | 480,000 | 720,000 | 720,000 | 720,000 | 720,000 | 5760,000 |
Credit Sales, see years 1-3 | 0,000 | 0,000 | 0,000 | 0,000 | 00,000 | 0,000 | 0,000 | 0,000 | 0,000 | 0,000 | 0,000 | 0,000 | 0,000 |
TOTAL SALES | 240,000 | 240,000 | 240,000 | 240,000 | 480,000 | 480,000 | 480,000 | 480,000 | 720,000 | 720,000 | 720,000 | 720,000 | 5760,000 |
$VARIABLE see venture capital | -120,000 | -120,000 | -120,000 | -120,000 | -240,000 | -330,000 | -240,000 | -240,000 | -360,000 | -360,000 | -360,000 | -540,000 | -3150,000 |
$GROSS PROFIT | 120,000 | 120,000 | 120,000 | 120,000 | 240,000 | 240,000 | 240,000 | 240,000 | 360,000 | 360,000 | 360,000 | 360,000 | 2610,000 |
$OTHER INCOME | 60,000 | 60,000 | 60,000 | 60,000 | 120,000 | 120,000 | 120,000 | 120,000 | 180,000 | 180,000 | 180,000 | 180,000 | 1440,000 |
$TOTAL INCOME | 180,000 | 180,000 | 180,000 | 180,000 | 360,000 | 360,000 | 360,000 | 360,000 | 540,000 | 540,000 | 540,000 | 540,000 | 4051,000 |
$OVERHEADS | -149,400 | -149,400 | -149,400 | -149,400 | -298,000 | -298,000 | -298,000 | -298,000 | -448,000 | -448,000 | -448,000 | -448,000 | -3585,600 |
$PROFIT/LOSS | 30,600 | 30,600 | 30,600 | 30,600 | 62,000 | 62,000 | 62,000 | 62,000 | 92,000 | 92,000 | 92,000 | 92,000 | 654,40 |
$PROFIT/LOSS % | 17,000 | 17,00 | 17,000 | 17,000 | 17,000 | 17,000 | 17,000 | 17,000 | 17,000 | 17,000 | 17,000 | 17,000 | |
SALES | |||||||||||||
Xi4M | 36 | 36 | 36 | 36 | 72 | 72 | 72 | 72 | 108 | 108 | 108 | 108 | 864 |
Price | 0,17 | 0,17 | 0,17 | 0,17 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | |
$ Xi4M | 7,320 | 7,320 | 7,320 | 7,320 | 14,640 | 14,640 | 14,640 | 14,640 | 21,96 | 21,96 | 21,96 | 21,96 | 175,680 |
Xi4P | 36 | 36 | 36 | 36 | 72 | 72 | 72 | 72 | 108 | 108 | 108 | 108 | 864 |
Price | 0,17 | 0,17 | 0,17 | 0,17 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | |
$ Xi4P | 7,320 | 7,320 | 7,320 | 7,320 | 14,640 | 14,640 | 14,640 | 14,640 | 21,96 | 21,96 | 21,96 | 21,96 | 175,680 |
Xi4B | 36 | 36 | 36 | 36 | 72 | 72 | 72 | 72 | 108 | 108 | 108 | 108 | 864 |
Price | 0,17 | 0,17 | 0,17 | 0,17 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | 0,21 | |
$ Xi4B | 7,320 | 7,320 | 7,320 | 7,320 | 14,640 | 14,640 | 14,640 | 14,640 | 21,96 | 21,96 | 21,96 | 21,96 | 175,680 |
Base4Xi4M | 36 | 36 | 36 | 36 | 72 | 72 | 72 | 72 | 108 | 108 | 108 | 108 | 864 |
Price | 1,7 | 1,7 | 1,7 | 1,7 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | |
$ Base4Xi4M | 73,20 | 73,20 | 73,20 | 73,20 | 146,40 | 146,40 | 146,40 | 146,40 | 219,60 | 219,60 | 219,60 | 219,60 | 1756,800 |
Base4Xi4P | 36 | 36 | 36 | 36 | 72 | 72 | 72 | 72 | 108 | 108 | 108 | 108 | 864 |
Price | 1,7 | 1,7 | 1,7 | 1,7 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | |
$ Base4Xi4P | 73,20 | 73,20 | 73,20 | 73,20 | 146,40 | 146,40 | 146,40 | 146,40 | 219,60 | 219,60 | 219,60 | 219,60 | 1756,800 |
36 | 36 | 36 | 36 | 72 | 72 | 72 | 72 | 108 | 108 | 108 | 108 | 864 | |
Price | 1,7 | 1,7 | 1,7 | 1,7 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | 2,1 | |
$ Base4Xi4B | 73,20 | 73,20 | 73,20 | 73,20 | 146,40 | 146,40 | 146,40 | 146,40 | 219,60 | 219,60 | 219,60 | 219,60 | 1756,800 |
Sensor4Xi4M | 360 | 360 | 360 | 360 | 720 | 720 | 720 | 720 | 1080 | 1080 | 1080 | 1080 | 8640 |
Price | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | |
$ Sensor4Xi4M | 0.01008 | 0.01008 | 0.01008 | 0.01008 | 0.02268 | 0.02268 | 0.02268 | 0.02268 | 0.03108 | 0.03108 | 0.03108 | 0.03108 | 0,239 |
Sensor4Xi4P | 360 | 360 | 360 | 360 | 720 | 720 | 720 | 720 | 1080 | 1080 | 1080 | 1080 | 8640 |
Price | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | |
$ Sensor4Xi4P | 0.01008 | 0.01008 | 0.01008 | 0.01008 | 0.02268 | 0.02268 | 0.02268 | 0.02268 | 0.03108 | 0.03108 | 0.03108 | 0.03108 | 0,239 |
Sensor4Xi4B | 360 | 360 | 360 | 360 | 720 | 720 | 720 | 720 | 1080 | 1080 | 1080 | 1080 | 8640 |
Price | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | 0,00007 | |
$ Sensor4Xi4B | 0.01008 | 0.01008 | 0.01008 | 0.01008 | 0.02268 | 0.02268 | 0.02268 | 0.02268 | 0.03108 | 0.03108 | 0.03108 | 0.03108 | 0,239 |
FD1(4M,4P,4B) | 108 | 108 | 108 | 108 | 216 | 216 | 216 | 216 | 324 | 324 | 324 | 324 | 2592 |
Price | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | |
$ FD1 | 0,0756 | 0,0756 | 0,0756 | 0,0756 | 0,1512 | 0,1512 | 0,1512 | 0,1512 | 0,2268 | 0,2268 | 0,2268 | 0,2268 | 18,144 |
PRD(4M,4P,4B) | 108 | 108 | 108 | 108 | 216 | 216 | 216 | 216 | 324 | 324 | 324 | 324 | 2592 |
Price | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | 0,0003 | |
$ PRD | 0,0108 | 0,0108 | 0,0108 | 0,0108 | 0,0108 | 0,0108 | 0,0108 | 0,0108 | 0,0324 | 0,0324 | 0,0324 | 0,0324 | 0,259 |
RD(4M,4P,4B) | 108 | 108 | 108 | 108 | 216 | 216 | 216 | 216 | 324 | 324 | 324 | 324 | 2592 |
Price | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | 0,021 | |
$ RD | 0,756 | 0,756 | 0,756 | 0,756 | 1,512 | 1,512 | 1,512 | 1,512 | 2,268 | 2,268 | 2,268 | 2,268 | 181,440 |
FD2(4M,4P,4B) | 108 | 108 | 108 | 108 | 216 | 216 | 216 | 216 | 324 | 324 | 324 | 324 | 2592 |
Price | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | 0,0021 | |
$ FD2 | 0,0756 | 0,0756 | 0,0756 | 0,0756 | 0,1512 | 0,1512 | 0,1512 | 0,1512 | 0,2268 | 0,2268 | 0,2268 | 0,2268 | 18,144 |
$OVERHEADS | |||||||||||||
Emloeyee's wages | 4,5 | 4,5 | 4,5 | 4,5 | 9,0 | 9,0 | 9,0 | 9,0 | 13,5 | 13,5 | 13,5 | 13,5 | 108,0 |
Empoyeers' National Insurance | 0,81 | 0,81 | 0,81 | 0,81 | 1,62 | 1,62 | 1,62 | 1,62 | 2,43 | 2,43 | 2,43 | 2,43 | 19,44 |
Training of staff | 0,36 | 0,36 | 0,36 | 0,36 | 0,72 | 0,72 | 0,72 | 0,72 | 1,08 | 1,08 | 1,08 | 1,08 | 8,64 |
Rent (rented premises) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Rates and water rates | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Fuel (gas,electricity etc) | 4,5 | 4,5 | 4,5 | 4,5 | 9,0 | 9,0 | 9,0 | 9,0 | 13,5 | 13,5 | 13,5 | 13,5 | 108,0 |
Telephone | 2,7 | 2,7 | 2,7 | 2,7 | 5,4 | 5,4 | 5,4 | 5,4 | 8,13 | 8,13 | 8,13 | 8,13 | 64,92 |
Postage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Printing and stationery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Subsdcriptions and periodicals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Advertising and promotions | 4,5 | 4,5 | 4,5 | 4,5 | 9,0 | 9,0 | 9,0 | 9,0 | 13,5 | 13,5 | 13,5 | 13,5 | 108,0 |
Repairs and maintenance | 4,5 | 4,5 | 4,5 | 4,5 | 9,0 | 9,0 | 9,0 | 9,0 | 13,5 | 13,5 | 13,5 | 13,5 | 108,0 |
Insurances | 4,5 | 4,5 | 4,5 | 4,5 | 9,0 | 9,0 | 9,0 | 9,0 | 13,5 | 13,5 | 13,5 | 13,5 | 108,0 |
Professional fees | 0,9 | 0,9 | 0,9 | 0,9 | 1,8 | 1,8 | 1,8 | 1,8 | 2,7 | 2,7 | 2,7 | 2,7 | 21,6 |
Interest payments | 6,3 | 6,3 | 6,3 | 6,3 | 12,6 | 12,6 | 12,6 | 12,6 | 18,97 | 18,97 | 18,97 | 18,97 | 151,48 |
Bank charges | 2,7 | 2,7 | 2,7 | 2,7 | 5,4 | 5,4 | 5,4 | 5,4 | 8,13 | 8,13 | 8,13 | 8,13 | 64,92 |
Vehicles and travel costs | 4,5 | 4,5 | 4,5 | 4,5 | 9,0 | 9,0 | 9,0 | 9,0 | 13,5 | 13,5 | 13,5 | 13,5 | 108,0 |
Depreciation - vehicle | 1,8 | 1,8 | 1,8 | 1,8 | 3,6 | 3,6 | 3,6 | 3,6 | 5,4 | 5,4 | 5,4 | 5,4 | 43,28 |
Depreciation - other | 8,1 | 8,1 | 8,1 | 8,1 | 16,2 | 16,2 | 16,2 | 16,2 | 24,39 | 24,39 | 24,39 | 24,39 | 194,76 |
Other expenses | 0,9 | 0,9 | 0,9 | 0,9 | 1,8 | 1,8 | 1,8 | 1,8 | 2,7 | 2,7 | 2,7 | 2,7 | 21,6 |
$TOTAL OVERHEADS | 51,57 | 51,57 | 51,57 | 51,57 | 103,14 | 103,14 | 103,14 | 103,14 | 154,71 | 154,71 | 154,71 | 154,71 | 1237,68 |