![slide79](https://www.sec.gov/Archives/edgar/data/1529628/000152962823000013/a202210-kex1028079.jpg)
TABLE 12.3 PRE-TAX AND AFTER-TAX CASH FLOW ANALYSIS SMART SAND - BLAIR OPERATION Tremealeau and Jackson Counties, WI Prepared For SMART SAND, INC By John T. Boyd Company Mining and Geological Consultants February 2023 As of Jan.1,2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044-2081 Production Statistics (Tons 000): ROM Production 816 1,640 1,968 2,165 2,381 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 2,620 97,575 - Dry Plant Product 612 1,230 1,476 1,624 1,786 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 73,181 - Overall Processing Recovery (%) 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 - Sales and Financial Data: - Total Tons Sold 612 1,230 1,476 1,624 1,786 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 1,965 73,181 - Product Pricing ($ per ton) - Weighted Average 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 - Revenues ($ 000) - Total Sales Revenues 22,032 44,280 53,136 58,464 64,296 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 70,740 2,634,516 - COGS ($ 000): - $ per ton sold 23.27 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 - - S,G&A 1,845 2,214 2,657 2,923 3,215 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 3,537 131,726 $ per ton sold 3.01 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 1.80 - Total COGS 16,086 24,354 29,225 32,155 35,363 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 38,907 1,448,984 $ per ton sold 26.28 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 19.80 EBITDA 5,946 19,926 23,911 26,309 28,933 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 31,833 1,185,532 $ per ton sold 9.72 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 16.20 - CapEx ($ 000): - Total CapEx 4,919 2,460 2,952 3,248 3,572 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 3,930 145,410 Net Pre-Tax Cash Flow 1,027 17,466 20,959 23,061 25,361 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 27,903 1,040,122 - Federal and State Income Taxes 154 4,847 5,798 6,346 6,950 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 7,416 275,720 After-Tax Net Cash Flow 873 12,619 15,161 16,714 18,411 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 20,487 764,402 - DCF-NPV Analysis: - Pre-Tax Discounted Cash Flows at 12% 970 14,736 15,788 15,510 15,230 14,961 13,358 11,927 10,649 9,508 8,489 7,580 6,767 6,042 5,395 4,817 4,301 3,840 3,429 3,061 2,733 22,443 Cumulative Pre-Tax Discounted Cash Flows at 12% 970 15,706 31,494 47,004 62,233 77,194 90,552 102,478 113,127 122,635 131,124 138,704 145,471 151,513 156,908 161,725 166,026 169,866 173,295 176,356 179,089 201,533 - After-Tax Dis\counted Cash Flows at 12% 825 10,647 11,420 11,242 11,056 10,984 9,808 8,757 7,819 6,981 6,233 5,565 4,969 4,436 3,961 3,537 3,158 2,819 2,517 2,248 2,007 16,479 Cumulative After-Tax Discounted Cash Flows at 12% 825 11,472 22,892 34,134 45,190 56,174 65,982 74,739 82,557 89,538 95,771 101,336 106,305 110,741 114,702 118,239 121,397 124,216 126,734 128,981 130,988 147,467 Q:\ENG_WP\3555.022 SS - YE 2022 S-K 1300\WP\REPORT\Table 12.3 Table 12.3-Cash Flow Table 2/22/2023 4:30 PM Page 1 12-4 JOHN T. BOYD COMPANY