| 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 | Balance Sheet | |||||||||||||||||||||||||
2 | Panhandle Precast of NW FL LLC | |||||||||||||||||||||||||
3 | As of 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 | |||||||||||||
6 | Assets | |||||||||||||||||||||||||
7 | Current Assets | |||||||||||||||||||||||||
8 | Bank Accounts | |||||||||||||||||||||||||
9 | Operating Account-TrustMark | 60,041.58 | 53,788.09 | -867.38 | -8,672.06 | -7,745.85 | -10,092.82 | -5,698.12 | -3,374.27 | 15,705.81 | 16,513.26 | 18,201.07 | 12,848.35 | |||||||||||||
10 | Payroll Account-TrustMark | 11,088.59 | 12,125.36 | 13,844.45 | 40,207.87 | 19,344.58 | 10,703.59 | 7,760.99 | 7,884.43 | 6,446.96 | 10,568.69 | 12,583.37 | 14,627.64 | |||||||||||||
11 | Renasant Line Of Credit-0521 Note 1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
12 | Renasant Money Market | 0.00 | 11,523.63 | 11,526.42 | 11,525.71 | 11,525.23 | 11,524.68 | 11,523.97 | 11,523.50 | 11,522.94 | 11,522.15 | 11,521.84 | 11,521.05 | |||||||||||||
13 | Renasant Operating Account | 43,712.18 | 209,752.43 | 232,220.78 | 397,702.69 | 603,424.96 | -28,434.83 | 306,369.05 | 449,691.72 | 786,371.54 | 475,412.89 | 361,486.06 | 419,774.69 | |||||||||||||
14 | Trustmark (Money Market | 4,361.57 | 4,359.57 | 4,358.45 | 3,354.01 | 74,389.20 | 76,165.01 | 76,183.10 | 26,405.67 | 26,477.86 | 55,981.90 | 56,106.87 | 56,236.29 | |||||||||||||
15 | Total for Bank Accounts | 119,203.92 | 291,549.08 | 261,082.72 | 444,118.22 | 700,938.12 | 59,865.63 | 396,138.99 | 492,131.05 | 846,525.11 | 569,998.89 | 459,899.21 | 515,008.02 | |||||||||||||
16 | Accounts Receivable | |||||||||||||||||||||||||
17 | Accounts Receivable | 657,543.08 | 1,001,890.44 | 1,168,687.79 | 1,386,435.35 | 1,014,238.13 | 1,325,902.40 | 1,009,616.43 | 1,062,115.18 | 870,296.13 | 1,218,680.97 | 1,939,109.89 | 1,521,734.76 | |||||||||||||
18 | Total for Accounts Receivable | 657,543.08 | 1,001,890.44 | 1,168,687.79 | 1,386,435.35 | 1,014,238.13 | 1,325,902.40 | 1,009,616.43 | 1,062,115.18 | 870,296.13 | 1,218,680.97 | 1,939,109.89 | 1,521,734.76 | |||||||||||||
19 | Other Current Assets | |||||||||||||||||||||||||
20 | Construction in Progress | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
21 | Inventory Asset | 110,188.74 | 129,965.00 | 144,704.32 | 171,585.07 | 184,644.91 | 204,591.99 | 217,262.38 | 234,136.49 | 257,502.20 | 281,295.43 | 301,156.47 | 336,438.34 | |||||||||||||
22 | Prepaid Expenses | 13,225.77 | 11,903.19 | 10,580.61 | 9,258.03 | 7,935.45 | 6,612.87 | 5,290.29 | 3,967.71 | 2,645.13 | 1,322.55 | 0.00 | 0.00 | |||||||||||||
23 | Undeposited Funds | 0.00 | 0.00 | 0.00 | 16,665.40 | 16,665.40 | 16,665.40 | 16,665.40 | 16,665.40 | 19,794.40 | 0.00 | 0.00 | 0.00 | |||||||||||||
24 | Total for Other Current Assets | 123,414.51 | 141,868.19 | 155,284.93 | 197,508.50 | 209,245.76 | 227,870.26 | 239,218.07 | 254,769.60 | 279,941.73 | 282,617.98 | 301,156.47 | 336,438.34 | |||||||||||||
25 | Total for Current Assets | 900,161.51 | 1,435,307.71 | 1,585,055.44 | 2,028,062.07 | 1,924,422.01 | 1,613,638.29 | 1,644,973.49 | 1,809,015.83 | 1,996,762.97 | 2,071,297.84 | 2,700,165.57 | 2,373,181.12 | |||||||||||||
26 | Fixed Assets | |||||||||||||||||||||||||
27 | Accumulated Depreciation | -2,236,957.27 | -2,378,958.59 | -2,520,959.91 | -2,662,961.23 | -2,804,962.55 | -2,946,963.87 | -3,088,965.19 | -3,230,966.51 | -3,372,967.83 | -3,514,969.15 | -3,656,970.47 | -3,498,724.79 | |||||||||||||
28 | Forms | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
29 | Besser Forms | 190,549.45 | 190,549.45 | 190,549.45 | 190,549.45 | 190,549.45 | 190,549.45 | 190,549.45 | 210,398.07 | 234,476.18 | 234,476.18 | 234,476.18 | 311,476.18 | |||||||||||||
30 | Escofab Forms | 185,661.55 | 191,167.07 | 191,167.07 | 191,167.07 | 191,167.07 | 191,167.07 | 191,167.07 | 191,167.07 | 191,167.07 | 191,167.07 | 199,268.97 | 199,268.97 | |||||||||||||
31 | M&M Welding & Fabrication, Inc. | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | 244,088.82 | |||||||||||||
32 | Triple J & Sons | 5,290.00 | 5,290.00 | 5,290.00 | 5,290.00 | 5,290.00 | 5,290.00 | 5,290.00 | 5,290.00 | |||||||||||||||||
33 | Wieser Forms | 185,000.00 | 191,800.00 | 191,800.00 | 191,800.00 | 217,400.00 | 217,400.00 | 217,400.00 | 219,000.00 | 219,000.00 | 219,000.00 | 219,000.00 | 219,000.00 | |||||||||||||
34 | Mike G Bascetta | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | 21,000.00 | |||||||||||||
35 | Western Forms | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | 54,413.29 | |||||||||||||
36 | Total for Forms | 880,713.11 | 893,018.63 | 893,018.63 | 893,018.63 | 923,908.63 | 923,908.63 | 923,908.63 | 945,357.25 | 969,435.36 | 969,435.36 | 977,537.26 | 1,054,537.26 | |||||||||||||
37 | Furniture and Equipment | 3,380.00 | 19,976.80 | 19,976.80 | 23,678.05 | 23,678.05 | 28,620.44 | 28,620.44 | 36,221.58 | 36,221.58 | 42,639.44 | 42,639.44 | 42,639.44 | |||||||||||||
38 | Land Buildings & Improvements | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
39 | Land Improvements | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
40 | Manufacturing Building | 1,098,213.71 | 1,148,251.51 | 1,266,490.74 | 1,379,445.13 | 1,457,222.62 | 1,530,505.11 | 1,642,691.51 | 1,709,533.31 | 1,740,749.71 | 1,776,626.05 | 1,828,810.72 | 1,806,068.18 | |||||||||||||
41 | Office Building | 75,316.64 | 100,483.52 | 100,397.22 | 102,354.79 | 102,509.29 | 102,509.29 | 103,009.29 | 103,009.29 | 103,009.29 | 103,009.29 | 103,009.29 | 103,009.29 | |||||||||||||
42 | Pole Barn | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | 3,000.00 | |||||||||||||
43 | Yard Office | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | 37,464.64 | |||||||||||||
44 | Total for Land Buildings & Improvements | 1,213,994.99 | 1,289,199.67 | 1,407,352.60 | 1,522,264.56 | 1,600,196.55 | 1,673,479.04 | 1,786,165.44 | 1,853,007.24 | 1,884,223.64 | 1,920,099.98 | 1,972,284.65 | 1,949,542.11 | |||||||||||||
45 | Machinery & Equipment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
46 | 2019 Mack GR64B Concrete Truck | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 300,247.00 | 223,364.02 | 0.00 | |||||||||||||
47 | Cementech Concrete Plant | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
48 | JD 844L Wheel Loader | 486,590.00 | 486,590.00 | 486,590.00 | 486,590.00 | 486,590.00 | 486,590.00 | 486,590.00 | 486,590.00 | 486,590.00 | ||||||||||||||||
49 | Mixer Systems Batch Plant 2023 | 571,920.35 | 571,920.35 | 571,920.35 | 571,920.35 | 571,920.35 | 571,920.35 | 571,920.35 | 571,920.35 | 593,560.35 | 593,560.35 | 593,560.35 | 593,560.35 | |||||||||||||
50 | Small Equipment | 82,731.34 | 83,675.17 | 91,673.13 | 107,623.93 | 108,567.76 | 109,511.59 | 128,214.42 | 129,158.25 | 134,452.08 | 140,210.91 | 141,154.74 | 247,405.98 | |||||||||||||
51 | 2002 Mantis Crane | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | 120,741.81 | |||||||||||||
52 | Concrete Bucket | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | |||||||||||||
53 | JD 350P Excavator | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | 374,214.25 | |||||||||||||
54 | JD 624K Wheel Loader | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | 206,220.00 | |||||||||||||
55 | Komatsu WA 250 Loader | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | 33,121.68 | |||||||||||||
56 | Total for Machinery & Equipment | 1,690,096.43 | 1,691,040.26 | 1,699,038.22 | 2,201,579.02 | 2,202,522.85 | 2,203,466.68 | 2,222,169.51 | 2,223,113.34 | 2,250,047.17 | 2,255,806.00 | 2,179,866.85 | 2,062,754.07 | |||||||||||||
57 | Site Work | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
58 | Trailer | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | 19,811.50 | |||||||||||||
59 | Vehicles | |||||||||||||||||||||||||
60 | Ram 2021 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | |||||||||||||
61 | Total for Vehicles | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | 86,996.50 | |||||||||||||
62 | Total for Fixed Assets | 1,658,035.26 | 1,621,084.77 | 1,605,234.34 | 2,084,387.03 | 2,052,151.53 | 1,989,318.92 | 1,978,706.83 | 1,933,540.90 | 1,873,767.92 | 1,779,819.63 | 1,622,165.73 | 1,717,556.09 | |||||||||||||
63 | Other Assets | |||||||||||||||||||||||||
64 | Loan Fees | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | 1,912.87 | |||||||||||||
65 | Accumulated Amort - Loan Fees | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | -1,912.87 | |||||||||||||
66 | Total for Loan Fees | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
67 | Total for Other Assets | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
68 | Total for Assets | 2,558,196.77 | 3,056,392.48 | 3,190,289.78 | 4,112,449.10 | 3,976,573.54 | 3,602,957.21 | 3,623,680.32 | 3,742,556.73 | 3,870,530.89 | 3,851,117.47 | 4,322,331.30 | 4,090,737.21 | |||||||||||||
69 | Liabilities and Equity | |||||||||||||||||||||||||
70 | Liabilities | |||||||||||||||||||||||||
71 | Current Liabilities | |||||||||||||||||||||||||
72 | Accounts Payable | |||||||||||||||||||||||||
73 | Accounts Payable | 413,521.13 | 417,701.12 | 436,662.62 | 469,734.59 | 258,726.12 | -27,833.95 | -91,267.14 | -19,128.89 | 87,296.36 | 112,666.92 | 122,103.22 | 117,080.75 | |||||||||||||
74 | Total for Accounts Payable | 413,521.13 | 417,701.12 | 436,662.62 | 469,734.59 | 258,726.12 | -27,833.95 | -91,267.14 | -19,128.89 | 87,296.36 | 112,666.92 | 122,103.22 | 117,080.75 | |||||||||||||
75 | Credit Cards | |||||||||||||||||||||||||
76 | Capital One Credit Card | 8,044.46 | 3,423.28 | 1,426.53 | 1,553.38 | 5,626.63 | 12,377.98 | 8,183.18 | 5,855.00 | 4,154.17 | 10,153.06 | 8,293.62 | 4,660.23 | |||||||||||||
77 | Trustmark Credit Card | 1,979.35 | 1,337.07 | 4,039.47 | 2,360.41 | 3,692.43 | 1,907.65 | 3,023.47 | 1,517.33 | 2,828.89 | 2,768.12 | 4,686.96 | 915.67 | |||||||||||||
78 | Total for Credit Cards | 10,023.81 | 4,760.35 | 5,466.00 | 3,913.79 | 9,319.06 | 14,285.63 | 11,206.65 | 7,372.33 | 6,983.06 | 12,921.18 | 12,980.58 | 5,575.90 | |||||||||||||
79 | Other Current Liabilities | |||||||||||||||||||||||||
80 | Direct Deposit Liabilities | -8,912.96 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
81 | Direct Deposit Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,031.16 | 0.00 | 0.00 | 0.00 | ||||||||||||||
82 | Due to/from KBar | 0.00 | -200.00 | -200.00 | -200.00 | -200.00 | 12,340.00 | 12,340.00 | -37,660.00 | -137,660.00 | -137,660.00 | -137,660.00 | -137,660.00 | |||||||||||||
83 | Florida Department Of Revenue Payable | 18,657.83 | 51,489.06 | 38,509.77 | 167,834.83 | 187,162.80 | 89,055.94 | 77,212.03 | 34,541.51 | 24,895.88 | -15,247.80 | 14,833.82 | 26,193.56 | |||||||||||||
84 | Out Of Scope Agency Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||
85 | Payroll Liabilities | -2,061.93 | 2,032.17 | 1,828.95 | 1,625.73 | 1,422.51 | 1,219.29 | 1,016.07 | 812.85 | 609.63 | 406.41 | 203.19 | -0.03 | |||||||||||||
86 | Federal Taxes (941/943/944) | 287.88 | 1,008.16 | 1,990.40 | 1,903.52 | 2,197.57 | -1,727.27 | 3,403.39 | 4,341.69 | -136.47 | -575.75 | -287.87 | 0.01 | |||||||||||||
87 | Federal Unemployment (940) | 74.38 | 185.17 | 362.81 | -149.87 | -20.49 | 74.92 | 221.23 | 316.45 | 390.83 | 192.21 | 266.59 | 340.97 | |||||||||||||
88 | FL Unemployment Tax | 8.62 | 23.30 | 49.11 | -40.13 | -22.37 | -10.26 | -19.71 | -7.64 | 0.96 | -5.90 | 2.70 | 11.30 | |||||||||||||
89 | Total for Payroll Liabilities | -1,691.05 | 3,248.80 | 4,231.27 | 3,339.25 | 3,577.22 | -443.32 | 4,620.98 | 5,463.35 | 864.95 | 16.97 | 184.61 | 352.25 | |||||||||||||
90 | Sales Tax Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
91 | Total for Other Current Liabilities | 8,053.82 | 54,537.86 | 42,541.04 | 170,974.08 | 190,540.02 | 100,952.62 | 94,173.01 | 2,344.86 | -110,868.01 | -152,890.83 | -122,641.57 | -111,114.19 | |||||||||||||
92 | Total for Current Liabilities | 431,598.76 | 476,999.33 | 484,669.66 | 644,622.46 | 458,585.20 | 87,404.30 | 14,112.52 | -9,411.70 | -16,588.59 | -27,302.73 | 12,442.23 | 11,542.46 | |||||||||||||
93 | Long-term Liabilities | |||||||||||||||||||||||||
94 | N/P JD 844L Wheel Loader | 1,851.86 | 3,703.72 | 5,555.58 | 471,047.44 | 472,899.30 | 463,570.52 | 443,236.55 | 434,046.92 | 424,863.34 | 415,679.76 | 406,496.18 | 397,312.60 | |||||||||||||
95 | N/P John Deere 350P Excavator - | 276,933.67 | 278,141.27 | 272,209.33 | 266,277.39 | 260,345.45 | 254,413.51 | 248,481.57 | 242,549.63 | 236,617.69 | 230,685.75 | 224,753.81 | 218,821.87 | |||||||||||||
96 | N/P John Deere 624K | 98,556.49 | 94,166.99 | 89,777.49 | 85,387.99 | 80,998.49 | 76,608.99 | 72,219.49 | 67,829.99 | 63,440.49 | 59,050.99 | 54,661.49 | 45,677.37 | |||||||||||||
97 | N/P Renasant- 2019 Mack Cementech Truck | 180,741.05 | 174,615.53 | 168,616.08 | 162,563.82 | 156,593.21 | 156,593.21 | 150,694.66 | 144,792.52 | 138,927.61 | 133,179.38 | 121,449.83 | 0.00 | |||||||||||||
98 | NP-Renasant 2022 Dodge Ram | 50,372.76 | 49,152.10 | 48,355.92 | 47,135.26 | 45,914.60 | 44,693.94 | 43,473.28 | 42,252.62 | 41,031.96 | 39,811.30 | 38,590.64 | 37,369.98 | |||||||||||||
99 | N/p Renasant-Mixer Systems Conc | 435,303.46 | 420,479.68 | 414,644.39 | 408,809.10 | 402,973.81 | 397,138.52 | 391,303.23 | 385,467.94 | 379,632.65 | 373,797.36 | 367,962.07 | 362,126.78 | |||||||||||||
100 | Renasant Construction Loan | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||