Financial Statement.xlsx

	A	B	C	D	E	F
1	Dough Re Mi Financial Statements
2
3	The costs of doughnut selling
4			RM
5	Doughnut		712
6	Plastic Bag		7,8
7	Poster		1,8
8	Packaging Box		54,66
9	Sticker		16
10	COD		60
11	Rental (FKJ&EXPO)		65
12	Others		107,3
13
14
15	Total Capital invested by the shareholders is RM80
16
17	Sales is RM1695
18
19
20
21	Projected Cash Flow Statement for the whole sale
22					RM	RM
23	Sales					1695
24	Minus Costs of Sales
25		Doughnut			712
26		Total Costs of Sales				-712
27	Gross Profit					983
28
29	Minus Expenses / Overhead
30		Plastic Bag			7,8
31		Poster			1,8
32		Packaging Box			54,66
33		Sticker			16
34		COD			60
35		Rental (FKJ&EXPO)			65
36		Others			107,3
37		Total Expenses/Overhead				-312,56
38	Net profit before tax					670,44
39
40
41	Projected Cash Flow Statement for the whole sale
42					RM	RM
43	Cash Balance (from previous month)					0
44
45	Cash Received
46		Capital			80
47		Sales			1695
48		Total Cash Received				1775
49
50	Minus Cash Payment
51		Doughnut			712
52		Plastic Bag			7,8
53		Poster			1,8
54		Packaging Box			54,66
55		Sticker			16
56		COD			60
57		Rental (FKJ&EXPO)			65
58		Others			107,3
59		Total Cash Payment				-1024,56
60	Cash Balance					750,44
61
62
63
64
65	Proforma Balance Sheet for the whole sale (19.12.2024)
66			RM			RM
67	Current Assets			Current Liabilities		0
68	Cash		750,44
69				Long term Liabilities		0
70	Fixed Assets		0
71				Equity
72				Capital	80
73				Profit	670,44
74						750,44
75
76	Total Assets		750,44	Total Liabilities and Equity		750,44
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100