Download as Xlsx
Download as Html
Print document
Home
Home
Insert
Insert
Formulas
Formulas
Data
Data
Review
Review
View
View
Design
Design
Layout
Layout
Format
Format
Format
Format
Design
Design
Undo
Redo
Print
Cut
Copy
Paste
Grow Font
Shrink Font
Bold
Italic
Underline
Strikethrough
Borders
Top Align
Middle Align
Bottom Align
Align Text Left
Center
Align Text Right
Decrease Indent
Increase Indent
Wrap Text
Merge Cells
Accounting Number Format
Percentage
Comma Style
Increase Decimal
Decrease Decimal
Insert
Delete
Format
AutoSum
Fill
Clear
Sort Filter
Find
Format As Table
Table
Picture
Column
Line
Pie
Bar
Area
Scatter
Other Charts
Hyperlink
AutoSum
Financial
Logical
Text
More
Calculation Options
Calculate Now
Calculate Sheet
Sort A to Z
Sort Z to A
Filter
Clear
Reapply
Data Validation
New Comment
Edit Comment
Delete Comment
Show/Hide Comment
Gridlines
Headings
Full Screen
Freeze Panes
Change Chart Type
Switch Row/Column
Select Data
Chart Layouts
Chart Styles
Chart Title
Axis Titles
Legend
Data Labels
Axes
Gridlines
Bring Forward
Send Backward
Bring Forward
Send Backward
Convert to Range
Table Style Options
Modify Style
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Revenue
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
YTD
Sales
$50,000
$63,098
$55,125
$23,881
$60,775
$44,500
$50,000
$62,500
$44,850
$51,000
$53,250
$59,000
$617,979
Sales Returns (Reduction)
$0
($500)
$0
$0
($234)
$0
$0
$0
$0
$0
$0
$0
($734)
Sales Discounts (Reduction)
($5,000)
($5,250)
($5,513)
($5,788)
($6,078)
($5,250)
($5,200)
($5,500)
($5,750)
($5,800)
($5,000)
($4,856)
($64,985)
Other Revenue 1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other Revenue 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other Revenue 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net Sales
$45,000
$57,348
$49,612
$18,093
$54,463
$39,250
$44,800
$57,000
$39,100
$45,200
$48,250
$54,144
$552,260
Cost of Goods Sold
$20,000
$21,000
$22,050
$23,153
$24,310
$22,150
$20,000
$21,000
$22,050
$23,000
$20,500
$22,000
$261,213
Gross Profit
$25,000
$36,348
$27,562
($5,060)
$30,153
$17,100
$24,800
$36,000
$17,050
$22,200
$27,750
$32,144
$291,048
$114,500
2024
NET INCOME
DevAV
PROFIT AND LOSS STATEMENT
Operation Expenses
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
YTD
Salaries & Wages
$7,500
$7,875
$8,269
$8,682
$9,116
$8,500
$8,000
$8,500
$7,950
$9,000
$8,650
$7,950
$99,992
Depreciation
$500
$525
$551
$579
$608
$560
$500
$525
$550
$610
$580
$590
$6,678
Rent
$1,500
$1,575
$1,654
$1,736
$1,823
$1,620
$1,700
$1,750
$1,680
$1,820
$1,690
$1,725
$20,273
Office Supplies
$475
$499
$524
$550
$577
$525
$500
$499
$550
$525
$577
$475
$6,276
Utilities
$123
$123
$123
$123
$123
$123
$123
$123
$123
$123
$123
$123
$1,476
Telephone
$68
$68
$68
$68
$68
$68
$68
$68
$68
$68
$68
$68
$816
Insurance
$125
$125
$125
$125
$125
$125
$125
$125
$125
$125
$125
$125
$1,500
Travel
$250
$263
$276
$289
$304
$285
$250
$275
$285
$260
$270
$250
$3,256
Maintenance
$100
$105
$110
$116
$122
$105
$100
$110
$120
$115
$100
$110
$1,313
Advertising
$200
$210
$221
$232
$243
$250
$225
$210
$240
$235
$225
$200
$2,690
Other 1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Total Operation Expenses
$10,841
$11,367
$11,920
$12,500
$13,109
$12,161
$11,591
$12,185
$11,691
$12,881
$12,408
$11,616
$144,270
Income From Operations
$14,159
$24,981
$15,642
($17,560)
$17,044
$4,939
$13,209
$23,815
$5,359
$9,319
$15,342
$20,528
$146,777
Profit and Loss
Profit and Loss