| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | The Learning Machine Limited | |||||||||||||||
2 | Standard model for a Level1/2 Award | |||||||||||||||
3 | CASH FLOW PROJECTION | |||||||||||||||
4 | For the 12 months to October 2011-September 2012 - illustrative | |||||||||||||||
5 | ||||||||||||||||
6 | ||||||||||||||||
7 | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12 | TOTAL | |||
8 | Cash In Flow | |||||||||||||||
9 | Number of registrations | 50 | 100 | 150 | 250 | 500 | 600 | 700 | 700 | 700 | 700 | 750 | 800 | 6,000.00 | ||
10 | Unit price | 9 | ||||||||||||||
11 | Income from certificates | 450 | 900 | 1350 | 2250 | 4500 | 5400 | 6300 | 6300 | 6300 | 6300 | 6750 | 7200 | 54,000.00 | ||
12 | Assessor training | 1000 | 1000 | 1000 | 3,000.00 | |||||||||||
13 | Total income | 1000 | 450 | 900 | 2350 | 2250 | 4500 | 5400 | 6300 | 6300 | 6300 | 7300 | 6750 | 7200 | 57,000.00 | |
14 | ||||||||||||||||
15 | Initial investment fund float | 7,500.00 | ||||||||||||||
16 | Cash Out Flow | |||||||||||||||
17 | Qualifications Development | 5000 | 5,000.00 | |||||||||||||
18 | Advertising | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 | 500.00 | 2,700.00 | ||
19 | Visits to centres | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | 12,000.00 | ||
20 | Moderation costs | 100.00 | 150.00 | 250.00 | 500.00 | 600.00 | 700.00 | 700.00 | 700.00 | 700.00 | 750.00 | 800.00 | 5,950.00 | |||
21 | Devising question paper | 1,500.00 | 500 | 500 | 2,500.00 | |||||||||||
22 | Additional Business overhead | 100.00 | 150.00 | 150.00 | 150.00 | 200.00 | 200.00 | 200.00 | 250.00 | 300.00 | 400.00 | 400.00 | 600.00 | 3,100.00 | ||
23 | 31,250.00 | |||||||||||||||
24 | ||||||||||||||||
25 | Expenditure | 6500 | 1300 | 1450 | 1500 | 1600 | 1900 | 2500 | 2100 | 2150 | 2200 | 2800 | 2350 | 2900 | 31,250.00 | |
26 | ||||||||||||||||
27 | Cashflow | |||||||||||||||
28 | Balance | 2000 | 1150 | 600 | 1450 | 2100 | 4700 | 7600 | 11800 | 15950 | 20050 | 24550 | 28950 | 33250 | ||
29 | ||||||||||||||||
30 | Note development costs already committed so no risk as even a complete failure | |||||||||||||||
31 | to sell any certificates would not result in permanent harm | |||||||||||||||
32 | In this case there are possibilities to sell 3 different qualifications therefore the volume requirement to get to break-even is made easier. | |||||||||||||||
33 | ||||||||||||||||
34 | ||||||||||||||||
35 | ||||||||||||||||
36 | ||||||||||||||||
37 | ||||||||||||||||
38 | ||||||||||||||||