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 |