68000 48000 50000 64000 58000 68000 58000 6800 Units 52000 56000 Unit Costs 0.94 0.95 0.96 0.97 0.98 0.99 1 1.01 1.02 192 1.91 1.99 2.08 2.07 2.12 selling Price 177 1.81 184 1.80 2011 2016 2009 2010 2012 2013 2014 201! 2017 2018 New Froject Exhibit S Exhibit S Revenue $ 94,960.00 $ 94 120.00 $ 103,040.00 5 112 800.00 $ $ 122,820.00 $ 132 600.00 $ 135,320.00 $ 138,040.00 $ 140,760.00 $ 144,160.00 Cost to Expand 57,817.0 Froduction Expenses 58 200.00 $ 62,720.00 $ 67 320.00 5 68,000.00 $ 68,680.00 $ 65,360.00 70,040.00 Interest Exp 7.7536 126 Raw Materials 45,120.00 $ 49,400.00 $ 53,760.00 $ 4,560.37 4,697.18 3.00% Manufacturing Overhead 3,600.00 $ 3.708.00 $ 3,819.24 $ 3.933.82 4,081 83 5 4173.37 $ 4,298.59 4,427.35 $ 2,250.00 5 2 817.50 $ 2,387 03 5 2.458.64 3 2.532 09 5 2608.87 $ 2,686.62 5 2.767.32 $ 2,830.23 $ 2.935.74 Depreciation 4,000 3% Maintenance Expense Tax Rate 40% Exhibit S Labor Expense 19,640.00 $ 20 233.30 $ 22,842 40 $ 25.254.60 $ 28,17490 $ 30,898.30 $ 31,969.60 $ 33,088.50 $ 34,246.60 $ 35,445.20 7 80% selling General and Admin 6,626 89 5 7 341.36 $ 8,037-12 5 8.798.40 $ 9,58464 $ 10.342.80 $ 10,354.96 $ 10,767.12 5 10,979.29 $ 11,244.49 98 645.45 $ 107,063 67 $ 145,333.08 $ 117,509.77 $ NFV Discount Total Operating Expense 90,845.79 119730.32 $ 124,996.49 $ 124,362.60 7.75% 76,236.89 $ 83,000.16 s EBITDA 9,723 12 $ 11 119.84 $ 12,194 22 $ 14154.59 $ 15,846 33 $ 47 266.53 $ 17,840.23 $ 18,309.62 $ 18,763.52 $ 19,797.40 4,000.00 $ 4,000.00 4,000.00 Fb Depreciation 4,000.00 $ 4,000.00 $ 4,000 00 5 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 5 13,840.23 $ 14,309.62 5 14,763.52 $ 15,797.40 EBT 4,723 12 5 7.119.84 $ 8,19421 $ 10.134.35 $ 11,846.33 $ 13 256.93 3 4,490.82 $ 4,480 82 5 4.490.82 4,480 82 5 4 490.82 $ 4,480.92 5 4,490.82 $ 4,490.82 5 4,480.82 Interest Expense 4,480 82 242 30 $ 2.639.02 $ 5.673.73 $ 7,363 51 8.786.13 $ 9,329.41 S 9.828.80 s 10,282.70 $ EET 3,713 39 5 11,316.53 4,113.08 4,526.63 Cal Taxes 96.92 $ 1,055.64 $ 1,483.36 5 2.269.49 $ 2,98421 $ 3 514.45 $ 3,731.77 5 3,931.52 $ 5.271.68 $ 5.397.65 5 5.897.23 $ 6.169.62 5 6.789.95 Net Frofit 145.39 $ 1 583.41 $ 2,228 04 3.404.24 $ 4,401 31 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 4,000.00 $ 4,000.00 5 4,000.00 Add Depreciation 4,000.00 4,000.00 $ 4,000.00 $ 9,597.65 5 9.897.28 10,169.62 $ 10,789.93 Total Cash FI -37 917.0 $ 4,143.39 $ 5.583.41 $ 6,228 04 $ 7.404.24 $ 8,401 31 $ 9.271.60 $ gees backed up their threats with work Q9: Just as Tucker was about to make a der the project! How would you approach this situation stoppages and demanded a 152: increase in wages. Calc from a financial and business perspective? WEMOUT