Financial Statement

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Please note: This file is in view-only mode and can not be amended. Please create your own copy of this sheet to make changes. Press File --> Make a copy.
2
3	Financial Statement
4	Income Statement: Business A
5	Name	Approval	Gross Sales	Returns & Allowances	NET Sales	Cost of Sales	Cost of Goods Sold	Gross Profit (Loss)	Selling Expenses	Subitems	Admin Expenses	Total Expenses	NET Income (pre tax)	Tax amount	NET Income (post tax)	ROI	Comments
6	2020	CFO	900000	100000	800000	50000	400	799600	2000	Salaries and Wages, Commissions, Advertising	500	2500	797100	79710	717390	714890	Add comments
7	Subitems	Name	Amount
8		Salaries and Wages	500000
9		Commissions	12899
10		Advertising	29000
11	2021	CFO	800000	100000	700000	50000	400	699600	2000		500	2500	697100	69710	627390	624890	Add comments
12	2022	CEO	1000000	100000	900000	50000	400	899600	2000		500	2500	897100	89710	807390	804890	Add comments
13	2023	Manager	999000	100000	899000	50000	400	898600	2000		500	2500	896100	89610	806490	803990	Add comments
14			4240899	400000	3299000	200000	1600	3297400	8000		2000	10000	3287400	328740	2958660	2948660
15
16	Income Statement: Business B
17	Name	Approval	Gross Sales	Returns & Allowances	NET Sales	Cost of Sales	Cost of Goods Sold	Gross Profit (Loss)	Selling Expenses	Subitems	Admin Expenses	Total Expenses	NET Income (pre tax)	Tax amount	NET Income (post tax)	ROI	Comments
18	2020	CFO	800000	100000	700000	50000	800	699200	1500		500	2000	697200	69720	627480	625480	Add comments
19	2021	CEO	900000	100000	800000	50000	800	799200	1500		500	2000	797200	79720	717480	715480	Add comments
20	2022	CEO	200000	100000	100000	50000	800	99200	1500		500	2000	97200	9720	87480	85480	Add comments
21	2023	Manager	600000	100000	500000	50000	800	499200	1500		500	2000	497200	49720	447480	445480	Add comments
22			2500000	400000	2100000	200000	3200	2096800	6000		2000	8000	2088800	208880	1879920	1871920
23
24
25
26
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