23/09/2020 HtmlTable examples
A B C D E F G H I J K
1 Statement of profit or loss for digby ltd for year ended 31 December 20X6
2 Revenue 487,280
4 Cost of sales W1
6 Gross profit
8 Admin expenses
9 Distribution cost -10508
Profit from
10
operations
11
12 Finance costs -680
Investment 3,411
13
income
14 Profit before tax
15 Tax expense -14200
16 Profi after tax
17
18 Statment of financial position for digby as at 31 december 20X6
19 Assets
20 Non current assets
Land and
21
buildings
Fixtures and
22
Fitting
23
24 Current Assets
25 Inventories
26 Trade Receivables
27 Cash 97,075
28
29 Total assets
30
31 Equity
32 Share capital 262500
33 Share premium 0
34 Retained earnings
35
36 Total
37
38 Non current
1/5
23/09/2020 HtmlTable examples
liability
Redeemable
39
preference shares
40 Deferred income 30000
41
42 Current liabilty
43 Trade payable 201,600
44 Tax 14660
45 Overdraft 640
46
Total Equity and
47
liabilities
48
49
50
51
52 W1 Cost matrix
53 COS Distribution Admin Opex
54 Tb 209,917 10,508 40,728 Did Should correc
55 Note 5 Gov grant -40000 10000 Dr cash 40 Dr cash 40 Dr admin
56 Cr Admin 40 Cr opex 10 Cr opex 10
Cr deferred cr Def inc30
57
inc 30
58
59 Invoice date YE
60 45100 40700
Cr revenue Dr cash Cr receivables
61
45100 40700 45100
Dr receivable Dr revenue Cr Suspense
62
45100 4400 4400
63 Dr FX 4400
64
65
66
67
68
69
70
71
72
73
74
75
76
2/5
23/09/2020 HtmlTable examples
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
3/5
23/09/2020 HtmlTable examples
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
4/5
23/09/2020 HtmlTable examples
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
5/5