ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Financial Model
2
Private and confidential
3
Year 1Year 2
4
CommentsJul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Apr-20May-20Jun-20
5
6
Income
7
Grant Funding
8
Sales0
9
asdasdasd000000000000000000000000
10
11
Variable Costs
12
Parts
13
Shipping
14
000000000000000000000000
15
16
Fixed Costs
17
Staff costsmonthly total for all employees10,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,000
18
PremisesLab space at ? a month330033003300330033003300330033003300330033003300330033003300330033003300330033003300330033003300
19
Business ratesEstimated at 5% of lab space a year165165165165165165165165165165165165165165165165165165165165165165165165
20
WaterIncluded in lab space000000000000000000000000
21
ElectricityIncluded in lab space000000000000000000000000
22
Internet / Phone0 phones at 0 per month000000000000000000000000
23
InsuranceEstimated at £600 per year505050505050505050505050505050505050505050505050
24
CleaningIncluded in lab space000000000000000000000000
25
Legal feesBudgeted at £1200 a year100100100100100100100100100100100100100100100100100100100100100100100100
26
Accountancy fees
Budgeted at £120 a year including Innovate reports
101010101010101010101010101010101010101010101010
27
Other professional feesPatent Lawyer £500 Jun 19424242424242424242424242424242424242424242424242
28
MarketingExpected to commence Year 2?000000000000000000000000
29
Bank chargesEstimated £360 a year303030303030303030303030303030303030303030303030
30
13,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,69713,697
31
32
Capital Costs
33
Lab equipment 20,000
34
Computers2,500
35
Fixture & Fittings
36
22,50000000000000000000000000
37
38
Total Cash Inflow / (Outflow)-36,197-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697
39
40
Cash Reserves
41
Opening balance63,80350,10636,40922,7129,015-4,682-18,379-32,076-45,773-59,470-73,167-56,864-70,561-84,258-97,955-111,652-125,349-139,046-152,743-166,440-180,137-193,834-207,531
42
Funding
Starting funds of £50000. Extra £30,000 in Jul 19
100,00030,000
43
Add/less profit-36,197-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697-13,697
44
Closing Cash63,80350,10636,40922,7129,015-4,682-18,379-32,076-45,773-59,470-73,167-56,864-70,561-84,258-97,955-111,652-125,349-139,046-152,743-166,440-180,137-193,834-207,531-221,228
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...