Scribd
Upload
17 views3 pages

Week 4 - Practice File

The document contains a sales transaction log with details such as Sale ID, Customer ID, date, time, and amount for various sales. Additionally, it includes an income statement with sales, cost of goods sold, gross profit, operating expenses, and net income for four quarters. The document also features horizontal and vertical analyses of the income statement.

Uploaded by

Athena Baraoidan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
17 views3 pages

Week 4 - Practice File

The document contains a sales transaction log with details such as Sale ID, Customer ID, date, time, and amount for various sales. Additionally, it includes an income statement with sales, cost of goods sold, gross profit, operating expenses, and net income for four quarters. The document also features horizontal and vertical analyses of the income statement.

Uploaded by

Athena Baraoidan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Sale ID Customer ID Date Time Amount

SALE00005 49 4/1/23 7:57 1961


SALE00009 51 10/1/22 1:17 892
SALE00016 37 3/21/23 8:16 929
SALE00017 37 8/12/23 16:54 719
SALE00021 7 4/20/23 23:55 974
SALE00023 56 8/29/23 15:49 1258
SALE00025 46 12/26/22 0:11 1714
SALE00025 40 5/23/23 12:40 376
SALE00031 41 2/1/23 10:48 334
SALE00040 66 7/5/23 12:08 630
SALE00040 88 5/1/23 7:28 433
SALE00043 73 4/28/23 2184
SALE00047 7 9/1/22 5:22 344
SALE00048 28 8/28/23 1:42 1924
SALE00056 46 1/8/23 0:58 2285
SALE00056 39 6/26/23 7:18 1716
SALE00060 64 4/26/23 0:10 847
SALE00062 1 2/7/23 15:14 741
SALE00068 20 4/28/23 19:14 1923
SALE00076 48 2/10/23 18:12 1879
SALE00089 75 7/4/23 23:49 1867
SALE00089 19 12/16/22 6:25 269
SALE00098 72 5/2/23 8:34 1442
SALE00098 85 5/20/23 7:06 431
SALE00101 49 7/30/23 3:15 1468
SALE00102 86 6/15/23 9:07 557
SALE00109 2 2/21/23 14:49 649
SALE00109 61 7/11/23 22:21 341
SALE00109 77 6/15/23 3:25 1006
SALE00111 65 5/16/23 6:15 2263
SALE00114 12 11/14/22 19:06 1112
SALE00119 10 4/29/23 5:00 1210
SALE00119 31 10/30/22 4:20 1302
SALE00121 7 4/8/23 1741
SALE00122 40 5/19/23 8:43 1206
SALE00126 52 12/11/22 1:38 2185
SALE00127 55 12/17/22 23:52 1068
SALE00128 84 11/16/22 1:07 562
SALE00130 34 8/24/23 19:23 1874
SALE00130 60 7/20/23 22:41 578
SALE00135 33 7/20/23 18:18 1315
SALE00137 66 3/5/23 1:41 2205
SALE00137 4 2/21/23 4:38 1859
SALE00139 58 11/26/22 2154
SALE00146 85 11/2/22 4:13 1760
SALE00147 82 11/1/22 15:28 974
SALE00149 62 4/18/23 13:13 1112
SALE00155 77 10/4/22 18:55 1741
SALE00156 74 12/24/22 6:45 1792
SALE00158 58 2/24/23 3:57 1167
SALE00167 10 8/4/23 16:07 680
SALE00168 31 12/23/22 2:13 2268
SALE00171 16 4/24/23 0:08 984
SALE00171 52 1/7/23 355
SALE00177 14 6/3/23 14:48 743
SALE00184 5 4/4/23 6:57 1663
SALE00192 8 11/12/22 15:45 684
SALE00192 41 3/3/23 10:44 472
SALE00199 74 8/26/23 9:32 487
SALE00200 38 2/27/23 9:48 915
Income Statement
Y1 Q1 Y1 Q2 Y1 Q3 Y1 Q4
Sales
Cost of goods sold
Gross profit
Operating expenses
Operating income
Interest expense
Tax expense
Net income
Income Statement - Horizontal Analysis
Sales % of Y1 Q1
Net income % of Y1 Q1
Income Statement - Vertical Analysis
Y1 Q1 Y1 Q2 Y1 Q3 Y1 Q4
Sales
Cost of goods sold
Gross profit
Operating expenses
Operating income
Interest expense
Tax expense
Net income

Y1 Q1 Y1 Q2 Y1 Q3 Y1 Q4
Sales 72,300 73,100 73,980 74,870
Cost of goods sold 34,710 34,820 35,030 35,140
Operating expenses 21,690 21,830 21,990 22,080
Interest expense 400 400 700 600
Tax expense 3,570 3,700 3,740 3,930

You might also like