| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Profit and Loss | |||||||||||||||||||||||||
2 | Panhandle Precast of NW FL LLC | |||||||||||||||||||||||||
3 | January 1-December 31, 2024 | |||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | Distribution account | January 2024 | February 2024 | March 2024 | April 2024 | May 2024 | June 2024 | July 2024 | August 2024 | September 2024 | October 2024 | November 2024 | December 2024 | Total | ||||||||||||
6 | Income | |||||||||||||||||||||||||
7 | Discounts given | -808.10 | -751.34 | -800.96 | -7,839.40 | -2,775.90 | -12,975.70 | |||||||||||||||||||
8 | Sales | 510,989.53 | 807,452.81 | 682,539.86 | 1,056,386.37 | 681,526.70 | 518,832.45 | 654,288.58 | 723,601.74 | 817,465.42 | 967,428.73 | 1,101,841.69 | 539,173.39 | 9,061,527.27 | ||||||||||||
9 | Shipping Income | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||
10 | Total for Income | 510,989.53 | 807,452.81 | 682,539.86 | 1,056,386.37 | 681,526.70 | 518,832.45 | 653,480.48 | 722,850.40 | 816,664.46 | 967,428.73 | 1,094,002.29 | 536,397.49 | $9,048,551.57 | ||||||||||||
11 | Cost of Goods Sold | |||||||||||||||||||||||||
12 | Cost of Goods Sold | |||||||||||||||||||||||||
13 | Concrete | 66,423.89 | 230,628.06 | 51,819.18 | 156,529.34 | 37,027.87 | 185,738.56 | 25,322.51 | 95,210.37 | 115,908.61 | 35,243.37 | 13,641.85 | 178,907.43 | 1,192,401.04 | ||||||||||||
14 | ConcreteTesting | 16,714.08 | 645.42 | 17,359.50 | ||||||||||||||||||||||
15 | DOT Testing | 1,249.50 | 5,210.00 | 6,459.50 | ||||||||||||||||||||||
16 | Equipment Rental | 3,683.35 | 3,683.35 | 3,037.25 | 21,438.52 | 6,915.82 | 16,924.93 | 3,683.35 | -11,516.76 | 7,981.30 | 5,359.34 | 7,322.66 | 68,513.11 | |||||||||||||
17 | Foundry | 48,405.42 | -4,559.06 | 72,649.79 | 45,919.34 | 35,018.58 | 24,940.63 | 68,065.20 | 7,594.73 | 75,635.90 | 373,670.53 | |||||||||||||||
18 | Inventory Adjustment | -16,472.69 | -19,776.26 | -14,739.32 | -26,880.75 | -13,059.84 | -19,947.08 | -12,670.39 | -16,874.11 | -23,365.71 | -23,793.23 | -19,861.04 | -35,281.87 | -242,722.29 | ||||||||||||
19 | Miscellaneous Components | 41,962.22 | 20,788.63 | 64,108.81 | 42,762.36 | 27,937.58 | 46,767.14 | 6,269.15 | 16,605.38 | 44,816.30 | 22,638.86 | 40,160.02 | 30,557.24 | 405,373.69 | ||||||||||||
20 | Shipping | 13,743.79 | 11,683.64 | 23,884.33 | 19,336.39 | 5,900.00 | 10,855.97 | 16,197.40 | 49,122.08 | 52,220.36 | 72,797.12 | 39,582.62 | 17,155.17 | 332,478.87 | ||||||||||||
21 | Steel | 823.62 | 32,464.60 | 110,594.89 | 29,581.30 | 31,101.84 | 23,264.42 | 16,633.90 | 87,386.03 | 40,788.08 | 35,590.62 | 408,229.30 | ||||||||||||||
22 | Structure-Outsource | 6.00 | 1,018.53 | 27,101.31 | 12,736.80 | 6,959.76 | 7,964.50 | 12,718.80 | 72,378.75 | 469.03 | 80,453.20 | 1,150.80 | 222,957.48 | |||||||||||||
23 | Tools for Manufacturing | 89,457.43 | 42,011.08 | 23,961.36 | 69,214.32 | 23,495.85 | 64,508.48 | 53,530.96 | 44,747.10 | 43,774.73 | 66,071.49 | 70,178.33 | 210,147.99 | 801,099.12 | ||||||||||||
24 | Welding | 7,000.00 | 7,000.00 | 3,210.35 | 14,490.75 | 19,764.00 | 51,465.10 | |||||||||||||||||||
25 | Total for Cost of Goods Sold | 248,033.03 | 297,037.03 | 218,637.52 | 402,422.31 | 197,408.13 | 295,887.57 | 195,314.54 | 253,987.52 | 350,281.56 | 356,623.17 | 294,611.21 | 527,041.36 | $3,637,284.95 | ||||||||||||
26 | Total for Cost of Goods Sold | 248,033.03 | 297,037.03 | 218,637.52 | 402,422.31 | 197,408.13 | 295,887.57 | 195,314.54 | 253,987.52 | 350,281.56 | 356,623.17 | 294,611.21 | 527,041.36 | $3,637,284.95 | ||||||||||||
27 | Gross Profit | 262,956.50 | 510,415.78 | 463,902.34 | 653,964.06 | 484,118.57 | 222,944.88 | 458,165.94 | 468,862.88 | 466,382.90 | 610,805.56 | 799,391.08 | 9,356.13 | $5,411,266.62 | ||||||||||||
28 | Expenses | |||||||||||||||||||||||||
29 | Advertising & Promotion | 750.00 | 1,127.73 | 248.00 | 2,125.73 | |||||||||||||||||||||
30 | Ask My Accountant | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||
31 | Automobile Expense | |||||||||||||||||||||||||
32 | Auto | 5,028.70 | 1,322.58 | 1,322.58 | 2,730.61 | 1,322.58 | 1,322.58 | 1,322.58 | 1,322.58 | 1,322.58 | 1,322.58 | 1,322.55 | 19,662.50 | |||||||||||||
33 | Fuel | 7,845.79 | 2,963.78 | 8,610.88 | 2,544.42 | 13,129.77 | 5,357.02 | 557.48 | 1,427.88 | 1,102.13 | 5,184.28 | 569.34 | 3,435.92 | 52,728.69 | ||||||||||||
34 | Tolls | 29.00 | 8.50 | 22.50 | 10.50 | 70.50 | ||||||||||||||||||||
35 | Vehicle Registration | 170.15 | 226.20 | 576.20 | 972.55 | |||||||||||||||||||||
36 | Total for Automobile Expense | 13,044.64 | 4,286.36 | 9,933.46 | 5,275.03 | 14,481.35 | 6,679.60 | 1,880.06 | 2,750.46 | 2,433.21 | 6,529.36 | 2,128.59 | 4,012.12 | $73,434.24 | ||||||||||||
37 | Bank Service Charges | 9.42 | 134.62 | 5,471.04 | 65.58 | 11.58 | 9.68 | 102.76 | 14.58 | 74.92 | 183.53 | 21.99 | 78.93 | 6,178.63 | ||||||||||||
38 | Computer and Internet Expenses | 3,339.82 | 4,562.50 | 125.00 | 2,988.00 | 3,734.00 | 5,723.00 | 6,500.00 | 2,988.00 | 29,960.32 | ||||||||||||||||
39 | Donation/Sponsorship | 10,000.00 | 10,000.00 | |||||||||||||||||||||||
40 | Dues and Subscriptions | 436.98 | 116.98 | 630.88 | 3,855.70 | 4,514.81 | 386.50 | 267.92 | 333.31 | 599.77 | 495.80 | 3,357.76 | 916.13 | 15,912.54 | ||||||||||||
41 | Insurance Expense | 2,893.40 | 9,340.00 | 41,271.76 | 7,668.32 | 1,642.00 | 1,642.00 | 1,642.00 | 3,284.00 | 1,642.00 | 71,025.48 | |||||||||||||||
42 | Meals and Entertainment | 214.75 | 414.29 | 184.72 | 392.56 | 110.11 | 901.55 | 73.50 | 177.44 | 129.38 | 6,828.68 | 81.34 | 1,577.79 | 11,086.11 | ||||||||||||
43 | Office Building | 0.00 | 0.00 | |||||||||||||||||||||||
44 | Office Supplies | 800.16 | 2,638.24 | 1,633.27 | 3,102.55 | 757.39 | 296.70 | 306.00 | 328.19 | 939.26 | 2,192.33 | 2,475.62 | 4,312.54 | 19,782.25 | ||||||||||||
45 | Payroll Expenses | |||||||||||||||||||||||||
46 | Employee Reimbursements | 1,235.00 | 1,766.00 | 700.00 | 1,425.00 | 1,225.00 | 725.00 | 750.00 | 800.00 | 800.00 | 1,038.24 | 2,212.71 | 12,676.95 | |||||||||||||
47 | Payroll Processing Fee | 142.00 | 64.00 | 498.73 | 704.73 | |||||||||||||||||||||
48 | Payroll Taxes | 3,071.14 | 3,684.30 | 6,865.35 | 12,887.42 | 8,323.78 | 7,255.02 | 9,756.72 | 8,117.47 | 7,679.24 | 9,913.31 | 8,509.28 | 5,547.92 | 91,610.95 | ||||||||||||
49 | Service Fee | 39.10 | 15.00 | 27.84 | 35.00 | 8.40 | 35.00 | 160.34 | ||||||||||||||||||
50 | Taxes | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
51 | Wages | 59,875.92 | 83,201.11 | 86,898.04 | 84,027.28 | 105,777.49 | 91,309.00 | 125,750.19 | 104,270.15 | 125,692.03 | 158,077.43 | 108,638.34 | 150,269.54 | 1,283,786.52 | ||||||||||||
52 | Workers Compensation | 2,716.81 | 2,709.95 | 3,696.60 | 6,523.55 | 3,927.87 | 4,636.73 | 3,445.11 | 2,106.73 | 29,037.81 | 5,162.01 | 5,162.74 | 4,918.69 | 74,044.60 | ||||||||||||
53 | Total for Payroll Expenses | 67,040.87 | 91,464.46 | 98,159.99 | 104,863.25 | 118,044.14 | 104,453.59 | 139,677.02 | 115,279.35 | 163,707.81 | 173,961.15 | 123,383.60 | 162,948.86 | $1,462,984.09 | ||||||||||||
54 | Postage | 68.62 | 146.00 | 214.62 | ||||||||||||||||||||||
55 | Printing | 349.48 | 0.00 | 212.93 | 387.63 | 0.00 | 950.04 | |||||||||||||||||||
56 | Professional Fees | 67.90 | 729.40 | 0.00 | 16,497.35 | 4,342.50 | 2,096.79 | 0.00 | 23,733.94 | |||||||||||||||||
57 | Rent Expense | |||||||||||||||||||||||||
58 | Overflow Storage To KBAR | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 2,860.00 | 31,460.00 | |||||||||||||
59 | Panhandle Rent To KBAR | 4,680.00 | 4,860.00 | 4,680.00 | 9,680.00 | 9,680.00 | 9,680.00 | 9,680.00 | 9,680.00 | 9,680.00 | 9,680.00 | 9,680.00 | 91,660.00 | |||||||||||||
60 | Total for Rent Expense | 7,540.00 | 7,720.00 | 4,680.00 | 2,860.00 | 12,540.00 | 12,540.00 | 12,540.00 | 12,540.00 | 12,540.00 | 12,540.00 | 12,540.00 | 12,540.00 | $123,120.00 | ||||||||||||
61 | Repairs and Maintenance | 1,997.87 | 14,377.67 | 20,881.94 | 7,279.49 | 13,680.24 | 4,620.80 | 6,444.93 | 11,898.06 | 48,466.39 | 6,620.54 | 8,148.26 | 13,551.67 | 157,967.86 | ||||||||||||
62 | Suspense | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||
63 | Telephone Expense | 124.00 | 124.00 | 248.00 | 124.00 | 124.00 | 124.00 | 124.00 | 248.00 | 124.00 | 1,364.00 | |||||||||||||||
64 | Travel Expense | 33.02 | 229.06 | 481.26 | 894.39 | 1,637.73 | ||||||||||||||||||||
65 | Trustmark Credit Card Rebate | 0.00 | 0.00 | |||||||||||||||||||||||
66 | Uniforms | 4,072.72 | 4,072.72 | |||||||||||||||||||||||
67 | Utilities | 994.68 | 2,055.53 | 2,276.61 | 2,225.62 | 1,357.31 | 2,030.83 | 3,477.50 | 3,051.62 | 4,183.47 | 3,302.76 | 2,198.28 | 5,179.32 | 32,333.53 | ||||||||||||
68 | Total for Expenses | 95,197.69 | 127,855.91 | 158,628.41 | 187,936.89 | 165,621.93 | 146,772.29 | 174,680.81 | 148,285.01 | 250,776.14 | 218,282.94 | 162,832.06 | 211,013.75 | $2,047,883.83 | ||||||||||||
69 | Net Operating Income | 167,758.81 | 382,559.87 | 305,273.93 | 466,027.17 | 318,496.64 | 76,172.59 | 283,485.13 | 320,577.87 | 215,606.76 | 392,522.62 | 636,559.02 | -201,657.62 | $3,363,382.79 | ||||||||||||
70 | Other Income | |||||||||||||||||||||||||
71 | Gain/Loss on Sale of Equipment | -20,999.55 | 233,500.00 | 212,500.45 | ||||||||||||||||||||||
72 | Interest Earned | 14.03 | 16.67 | 12.85 | -5.59 | -29.53 | 35.38 | 187.63 | 74.63 | 78.25 | 95.63 | 131.63 | 611.58 | |||||||||||||
73 | Other Income | 0.00 | 0.00 | |||||||||||||||||||||||
74 | Total for Other Income | 14.03 | 16.67 | 12.85 | -5.59 | -29.53 | 35.38 | 187.63 | 74.63 | 78.25 | -20,903.92 | 233,631.63 | $213,112.03 | |||||||||||||
75 | Other Expenses | |||||||||||||||||||||||||
76 | Amortization Expense | 44.17 | 0.00 | 44.17 | ||||||||||||||||||||||
77 | Depreciation Expense | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 142,001.32 | 1,704,015.84 | ||||||||||||
78 | Interest Expense | 6,923.04 | 6,677.62 | 6,914.55 | 6,485.15 | 6,485.15 | 6,485.15 | 6,485.15 | 6,485.15 | 6,485.15 | 6,485.15 | 6,485.15 | 20,802.48 | 93,198.89 | ||||||||||||
79 | Property Tax | 11,638.02 | 12,068.22 | 23,706.24 | ||||||||||||||||||||||
80 | Total for Other Expenses | 148,968.53 | 148,678.94 | 160,553.89 | 148,486.47 | 148,486.47 | 148,486.47 | 148,486.47 | 148,486.47 | 148,486.47 | 160,554.69 | 148,486.47 | 162,803.80 | $1,820,965.14 | ||||||||||||
81 | Net Other Income | -148,968.53 | -148,664.91 | -160,537.22 | -148,473.62 | -148,492.06 | -148,516.00 | -148,451.09 | -148,298.84 | -148,411.84 | -160,476.44 | -169,390.39 | 70,827.83 | -$1,607,853.11 | ||||||||||||
82 | Net Income | 18,790.28 | 233,894.96 | 144,736.71 | 317,553.55 | 170,004.58 | -72,343.41 | 135,034.04 | 172,279.03 | 67,194.92 | 232,046.18 | 467,168.63 | -130,829.79 | $1,755,529.68 | ||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | Accrual Basis Wednesday, October 08, 2025 03:49 PM GMTZ | |||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||