Question: please attached excel document Required information Blackwater Spring and Metal utilizes the same computerized spring-forming machinery in its U.S. and Malaysian plant The first cost
please attached excel document

Required information Blackwater Spring and Metal utilizes the same computerized spring-forming machinery in its U.S. and Malaysian plant The first cost was $750,000 with S= $150,000 after n = 10 years. MACRS (Modified Accelerated Cost Recovery System) depreciation with n = 5 years is applied in the United States, and standard SL depreciation with n = 10 years is used by the Malaysian facility. Depreciation Rate (%) for Each MACRS Recovery Period In Years Year n =3 n =5 n =7 n = 10 n =15 n = 20 33.33 20.00 14.29 10.00 5.00 3.75 44.45 32.00 24.49 18.00 9.50 7.22 14.81 19.20 17.49 14.40 8.55 HAWN 6.68 7.41 11.52 12.49 11.52 7.70 6.18 11.52 8.93 9.22 6.93 5.71 5.76 8.92 7.37 6.23 5.29 8.93 6.55 5.90 4.89 4.46 6.55 5.90 4.52 6.56 5.91 4.46 6.55 5.90 4.46 3.28 5.91 4.46 5.90 4.46 5.91 4.46 5.90 4.46 5.91 4.46 K 16 2.95 4.46 17-20 4.46 21 2.23 Use a spreadsheet to plot the book values for both methods on a single graph. (Please upload your response/solution using th
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
