Question

1 Approved Answer

Posted on Jun 29, 2024

Table 1 MACRS Year 0 Year 21 Depreciation $345 Plant and Equipment $ 350,000,000.00 Year 7'Year class Depreciation [in millions) Land 4.242,000.00 $ 40,000,000.00 [factory,

Table 1 MACRS Year 0 Year 21 Depreciation $345 Plant and Equipment $ 350,000,000.00 Year 7'Year class Depreciation [in millions) Land 4.242,000.00 $ 40,000,000.00 [factory, equipment, and land year 2021) 14.29% 43.30 Inventory $ 14.000,000.00 $ 14.000,000.00 24.49% $ 84.49 Accounts Receivable $ 17.000,000.00 |$ 17.000,000.00 17.49% $ 60.34 Accounts Payable 15,000,000.00 |$ 15,000,000.00 2.49% $ 43.09 Cash Flow $(370,242,000.00) $ 56,000,000.00 8.93% $ 30.81 8.92% $ 30.77 Plant and Equipment 8.93% $ 30.81 Land 4.46% $ 15.39 Inventory Accounts Receivable 2 Table 2 Accounts Payable A C E F Cash Flow Cash from Cash outflow. Depreciatio Tax in After tax Cash Revenue in expenses in nin Taxable Income in $ Millions Flow In Year $Millions $Millions $Millions $ Millions 27.5% rate |$Millions 0 $ $ (370.24) 1 $ 1,800.00 $ 1.728.00 $ 49.30 $ 22. 70 $ 6.24 $ 65.76 2 1,900.00 $ 1824.00 $ 84.49 $ 8.49) $ 2.33) $ 8.33 3 $ 2,000.00 $ 1,920.00 60.34 $ 19.66 $ 5.41 $ 4.59 4 $ 2.100.00 $ 2,016.00 $ 43.09 $ 40.91 $ 11.25 $ 72.75 5 $ 2.200.00 $ 2.112.00 $ 30.81 $ 57.19 $ 15.73 $ 72.27 6 $ 2,300.00 $ 2,208.00 30.77 $ 61.23 $ 16.84 $ 75. 16 7 $ 2,400.00 $ 2,304.00 $ 30.81 $ 65.19 $ 17.93 $ 78.07 8 $ 2,500.00 $ 2,400.00 $ 5.39 $ 84.61 $ 23.27 $ 76.73 9 $ 2.600.00 $ 2.496.00 104.00 $ 28.60 $ '5.40 10 $ 2.700.00 $ 2,592.00 $ 108.00 $ 29.70 $ '8.30 11 $ 2,600.00 $ 2.496.00 $ 04.00 $ 28.60 $ 5.40 12 $ 2,500.00 $ 2.400.00 $ 00.00 $ 27.50$ 2.50 13 $ 2.400.00 $ 2.304.00 $ 36.00 $ 26.40 $ 59.60 14 $ 2.200.00 $ 2.112.00 $ $ 38.00 $ 24.20 $ 63.80 15 $ 2.000.00 $ 1,920.00 $ 30.00 $ 22.00 $ 58.00 16 $ .800.00 $ 1,728.00 $ 72.00 $ 19.80 $ 52.20 17| $ 1.500.00 $ 1.440.00 $ 60.00 $ 16.50 $ 13.50 18 $ .200.00 $ 1.152.00 $ 48.00 $ 13.20 $ 34.80 19 $ 300.00 $ 768.00 | $ 32.00 $ 8.80 $ 23.20 20| $ 400.00 $ 384.00 $ 16.00 $ 4.40 $ 11.60 21 56.00 3 NP $727.75 $357.51 LIRR 19%Table 3 A B C D E F Tax in $Millions 27.5% rate in years 1. Cash from Cash outflow. Depreciatio 2. 3 and After tax Cash Revenue in expenses in nin Taxable Income in 50% there Flow In Year # Millions $Millions $Millions $ Millions after $Millions O$ 1 $ 1,800.00 $ 1,762.56 $ 49.30 $ (11.86) $ (3.26) $ 40.70 2 $ 1.900.00 $ 1,860.48 $ 84.49 $ 44.97) $ [12.37) $ 51.89 3 $ 2,000.00 $ 1,958.40 $ 60.34 $ (18. 74) $ (5. 15) $ 46.75 4 1 2.100.00 $ 2.056.32|$ 43.09 | $ 0.59 $ 0.29 $ 43.39 5 $ 2.200.00 | $ 2.154.24 $ 30.81 | $ 14.95 $ 7.48 $ 38.28 6 $ 2,300.00 $ 2.252.16 $ 30.77 $ 17.07 $ B.53 | $ 39.31 7 $ 2.400.00 $ 2.350.08 $ 30.81 $ 19. 11 $ $ 40.36 8 $ 2,500.00 $ 2,448.00 $ 15.39 $ 36.61 $ 18.31 $ 33.69 9 1 2,600.00 |$ 2,545.92 $ $ 54.08 $ 27.04 $ 27.04 10 $ 2.700.00 |$ 2,643.84 $ $ 56.16 $ 28.08 | $ 28.08 11 $ 2,600.00 $ 2,545.92 $ - 54.08$ 27.04 $ 27.04 12 $ 2.500.00 $ 2.448.00 $ - 52.00 $ 26.00 $ 26.00 13 $ 2.400.00 $ 2.350.08 | $ - 49.92 $ $ 24.96 14 $ 2,200.00 $ 2.154.24 $ 45.76 $ 22.88 22.88 15 $ 2,000.00 1,958.40 $ 41.60 $ $ 20.80 16 $ 1,800.00| $ 1.762.56 | $ 37.44 $ 18. 72 17 $ 1,500.00 $ 1,468.80 $ $ 31.20 $ 15.60 $ 15.60 18 $ 1,200.00 | $ 1.175.04 $ 24.96 $ 12.48 $ 12.48 19 $ 800.00 $ 83.36 $ $ 16.64 $ 8.32 $ B.32 20 $ 100.00 | $ 391.68 $ - 8.32 | $ 4. 16 $ 4. 16 21 5 NPY