TABLE 12.3 PRE-TAX AND AFTER-TAX CASH FLOW ANALYSIS SMART SAND - UTICA OPERATION LaSalle County, Illinios Prepared For SMART SAND, INC By John T. Boyd Company Mining and Geological Consultants January 2022 2032 2042 2052 2062 2072 2082 2092 2102 2112 2122 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 to 2041 to 2051 to 2061 to 2071 to 2081 to 2091 to 2101 to 2111 to 2121 to 2182 Total Production Statistics (Tons 000): ROM Production off Fee Property 982 982 982 982 982 982 982 982 982 982 9,822 9,822 9,822 9,822 9,822 9,822 9,822 9,822 9,822 59,924 158,143 Processing Statistics (Tons 000): Wet Plant Feed 982 982 982 982 982 982 982 982 982 982 9,822 9,822 9,822 9,822 9,822 9,822 9,822 9,822 9,822 59,927 158,145 Processing Recovery (%) 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 84.0 Wet Plant Product 825 825 825 825 825 825 825 825 825 825 8,247 8,247 8,247 8,247 8,247 8,247 8,247 8,247 8,247 50,321 132,795 Dry Plant Feed 825 825 825 825 825 825 825 825 825 825 8,247 8,247 8,247 8,247 8,247 8,247 8,247 8,247 8,247 50,321 132,795 Processing Recovery (%) 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 97.0 Dry Plant Product 800 800 800 800 800 800 800 800 800 800 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 48,811 128,811 Overall Processing Recovery (%) 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 81.5 Sales and Financial Data: Saleable Product Tons Sold (000): 40/70-Mesh and coarser 693 693 693 693 693 693 693 693 693 693 6,930 6,930 6,930 6,930 6,930 6,930 6,930 6,930 6,930 42,250 111,550 70/100-Mesh 107 107 107 107 107 107 107 107 107 107 1,070 1,070 1,070 1,070 1,070 1,070 1,070 1,070 1,070 6,561 17,261 Total Tons Sold 800 800 800 800 800 800 800 800 800 800 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 48,811 128,811 Product Pricing ($ per ton) 40/70-Mesh and coarser 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 70/100-Mesh 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 Weighted Average 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 Revenues ($ 000) 40/70-Mesh and coarser 13,860 13,860 13,860 13,860 13,860 13,860 13,860 13,860 13,860 13,860 138,600 138,600 138,600 138,600 138,600 138,600 138,600 138,600 138,600 845,000 2,231,000 70/100-Mesh 2,140 2,140 2,140 2,140 2,140 2,140 2,140 2,140 2,140 2,140 21,400 21,400 21,400 21,400 21,400 21,400 21,400 21,400 21,400 131,220 345,220 Total Sales Revenues 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 976,220 2,576,220 COGS ($ 000): Cash Operating Expense: Wages and benefits 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 297,600 777,600 Excavation 1,248 1,248 1,248 1,248 1,248 1,248 1,248 1,248 1,248 1,248 12,480 12,480 12,480 12,480 12,480 12,480 12,480 12,480 12,480 76,145 200,945 Utilities 1,544 1,544 1,544 1,544 1,544 1,544 1,544 1,544 1,544 1,544 15,440 15,440 15,440 15,440 15,440 15,440 15,440 15,440 15,440 94,205 248,605 Equipment 456 456 456 456 456 456 456 456 456 456 4,560 4,560 4,560 4,560 4,560 4,560 4,560 4,560 4,560 28,272 73,872 Maintenance 800 800 800 800 800 800 800 800 800 800 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 48,811 128,811 Peru Trucking 1,560 1,560 1,560 1,560 1,560 1,560 1,560 1,560 1,560 1,560 15,600 15,600 15,600 15,600 15,600 15,600 15,600 15,600 15,600 95,181 251,181 Real Estate taxes 600 600 600 600 600 600 600 600 600 600 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 37,200 97,200 Other Costs 72 72 72 72 72 72 72 72 72 72 880 1,040 1,200 1,360 1,520 1,680 1,840 2,000 2,160 17,140 31,540 Total Cash Operating Expense 11,080 11,080 11,080 11,080 11,080 11,080 11,080 11,080 11,080 11,080 110,960 111,120 111,280 111,440 111,600 111,760 111,920 112,080 112,240 694,554 1,809,754 $ per ROM ton 11.28 11.28 11.28 11.28 11.28 11.28 11.28 11.28 11.28 11.28 11.30 11.31 11.33 11.35 11.36 11.38 11.39 11.41 11.43 11.59 11.44 $ per ton sold 13.85 13.85 13.85 13.85 13.85 13.85 13.85 13.85 13.85 13.85 13.87 13.89 13.91 13.93 13.95 13.97 13.99 14.01 14.03 14.23 14.05 S,G&A 1,136 1,136 1,136 1,136 1,136 1,136 1,136 1,136 1,136 1,136 11,360 11,360 11,360 11,360 11,360 11,360 11,360 11,360 11,360 69,312 182,912 $ per ton sold 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 1.42 Final Reclamation Escrow 54 54 54 54 54 54 54 54 54 54 536 536 536 536 536 536 536 536 536 3,269 8,629 $ per ton sold 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 Total COGS 12,270 12,270 12,270 12,270 12,270 12,270 12,270 12,270 12,270 12,270 122,856 123,016 123,176 123,336 123,496 123,656 123,816 123,976 124,136 767,135 2,001,295 $ per ton sold 15.34 15.34 15.34 15.34 15.34 15.34 15.34 15.34 15.34 15.34 15.36 15.38 15.40 15.42 15.44 15.46 15.48 15.50 15.52 15.72 15.54 EBITDA 3,730 3,730 3,730 3,730 3,730 3,730 3,730 3,730 3,730 3,730 37,144 36,984 36,824 36,664 36,504 36,344 36,184 36,024 35,864 209,085 574,925 $ per ton sold 4.66 4.66 4.66 4.66 4.66 4.66 4.66 4.66 4.66 4.66 4.64 4.62 4.60 4.58 4.56 4.54 4.52 4.50 4.48 4.28 4.46 CapEx ($ 000): Total CapEx 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 61,014 161,014 Net Pre-Tax Cash Flow 2,730 2,730 2,730 2,730 2,730 2,730 2,730 2,730 2,730 2,730 27,144 26,984 26,824 26,664 26,504 26,344 26,184 26,024 25,864 148,071 413,911 Federal Income and State Franchise Taxes 196 166 147 183 293 266 238 209 387 772 7,681 7,636 7,591 7,546 7,501 7,455 7,410 7,365 7,320 40,631 110,992 After-Tax Net Cash Flow 2,534 2,565 2,584 2,547 2,437 2,464 2,493 2,521 2,344 1,958 19,463 19,348 19,233 19,118 19,003 18,889 18,774 18,659 18,544 107,441 302,920 DCF-NPV Analysis: Pre-Tax Discounted Cash Flows at 12% 2,580 2,304 2,057 1,836 1,640 1,464 1,307 1,167 1,042 930 5,226 1,673 535 171 55 18 6 2 1 0 24,013 Cumulative Pre-Tax Discounted Cash Flows at 12% 2,580 4,884 6,940 8,777 10,416 11,880 13,187 14,354 15,396 16,327 21,553 23,225 23,761 23,932 23,987 24,005 24,010 24,012 24,013 24,013 After-Tax Dis\counted Cash Flows at 12% 2,395 2,164 1,946 1,713 1,463 1,321 1,193 1,078 894 667 3,747 1,199 384 123 39 13 4 1 0 0 20,347 Cumulative After-Tax Discounted Cash Flows at 12% 2,395 4,559 6,505 8,218 9,682 11,003 12,196 13,274 14,168 14,836 18,583 19,782 20,166 20,289 20,328 20,341 20,345 20,346 20,347 20,347 12-4 JO H N T. B O Y D C O M PA N Y