I need help with creating the balance sheet of a business plan for my class. I am going to attach an already completed sales and expense report and you can just add the information in a continuing tab on the excel sheet .
START-UP COSTS
BLU POOLS TO GO
Sales & Expense Report
REVENUE
JAN
Estimated Product Sales
Less Sales Returns & Discounts
Service Revenue
Other Revenue
Net Sales
Cost of Goods Sold
Gross Profit
EXPENSES
Salaries & Wages
Marketing/Advertising
Sales Commissions
Rent
Total Expenses
Income Before Taxes
Income Tax Expense
NET INCOME
FEB
5000
0
0
0
5000
2000
3000
JAN
13000
-350
0
0
12650
5200
7450
FEB
MAR
APR
MAY
JUN
16000
7000
14500
16400
0
-206
-234
0
0
0
0
250
0
0
0
0
16000
6794
14266
16650
6400
2800
5800
6560
9600
3994
8466
10090
MAR
APR
MAY
JUN
2500
400
250
1250
4400
-1400
-210
2500
450
650
1250
4850
2600
390
3500
450
800
1250
6000
3600
540
5000
450
350
1250
7050
-3056
-458.4
5000
900
725
1250
7875
591
88.65
5000
900
820
1250
7970
2120
318
-1190
2210
3060
-2597.6
502.35
1802
JUL
22500
0
350
0
22850
9000
13850
JUL
AUG
SEP
OCT
NOV
DEC
YTD
23125
24549
22000
25000
27349
216423
-280
-1200
-1600
0
-2400
-6270
100
0
0
1245
1360
3305
1500
0
0
0
0
1500
24445
23349
20400
26245
26309
214958
9250
9819.6
8800
10000 10939.6 86569.2
15195 13529.4
11600
16245 15369.4 128388.8
AUG
SEP
OCT
NOV
8000
9000
9000
900
900
900
1125 1156.25 1227.45
1250
1250
1250
11275 12306.25 12377.45
2575 2888.75 1151.95
386.25 433.3125 172.7925
9000
900
1100
1250
12250
-650
-97.5
2188.75 2455.438 979.1575
-552.5
DEC
YTD
9000
9000
76500
1200
1200
9550
1250 1367.45 10821.15
1250
1250
15000
12700 12817.45 111871.2
3545 2551.95 16517.65
531.75 382.7925 2477.648
3013.25 2169.158
14040
Blu Pools to GO
For the year that ended 2020
Revenue
Gross Sales
$ 216,423.00
Less: Sales Returns and Allowances $
6,270.00
Net Sales
$ 210,153.00
Cost of Goods Sold
Beginning Inventory
Add: Purchases
Direct Labor
Indirect Expenses
$
$
2,000.00
74,729.60
Inventory Available
$
76,729.60
Cost of Goods Sold
$
65,790.00
Gross Profit (Loss)
$ 144,363.00
Less: Ending Inventory
$
10,939.60
Expenses
Rent
Amortization
Utilities
Wages & Direct Cost
Commissions
Supplies
Marketing
Logistics
Repairs and Maintenance
Miscellaneous
Depreciation
Interest
$
$
$
$
$
$
$
$
$
$
$
$
15,000.00
5,000.00
76,500.00
10,821.00
9,550.00
1,000.00
500.00
–
Total Expenses
$ 118,371.00
Net Operating Income
$
25,992.00
Other Income
Gain (Loss) on Sale of Assets
Interest Income
Total Other Income
$
Net Income (Loss)
$
25,992.00
Purchase answer to see full
attachment
Recent Comments