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

please attached excel document Required information Blackwater Spring and Metal utilizes the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!