formula111.xlsx

	A	B	C	E	F	G	I	K
1	Balance	Start	End		Profit and Loss Statement	Fact		https://exceltable.com/
2	Cash	1186	124		Revenue	55656
3	Accounts Receivable	3884	3026		Cost of Goods Sold	41454
4	Inventory	8355	7651		Gross Profit	14202	=G2-G3
5	Total Current Assets	13425	10801	=SUM(C2:C4)
6					Research and Development	2046
7	Equipment and Property	4320	4516		Sales Expenses	6528
8	Other Assets	578	322
9	Total Long-Term Assets	4898	4838	=SUM(C7:C8)	Operating Profit	5628
10
11	Total Assets	18323	15639		Interest Expenses	465
12					Other Costs and Expenses	1368
13	Accounts Payable	1670	2644
14	Accruals	1334	1431		Net Profit	3795
15	Current Notes Payable	788	761
16	Total Current Liabilities	3792	4836	=SUM(C13:C15)	Return on Assets (ROA)	22,35%
17					Return on Equity (ROE)	40,13%
18	Long-Term Notes Payable	3177	3244
19	Total Liabilities	6969	8080			=G14/AVERAGE(B24:C24)
20
21	Public Actions	453	453
22	Additional Capital	4562	4562
23	Retained Earnings	6339	2544
24	Total Equity	11354	7559	=SUM(C21:C23)
25
26	Total Liabilities and Equity	18323	15639
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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