Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help solve using excel Your company manufactures circuit boards and other electronic parts for various commercial products. Design changes in part of the product
please help solve using excel
Your company manufactures circuit boards and other electronic parts for various commercial products. Design changes in part of the product line, which are expected to increase sales, will require changes in the manufacturing operation. The cost basis of new equipment required is $240,000 (MACRS five-year property class; GDS, 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, 5.76%). Increased annual revenues, in year zero dollars, are estimated to be $370,000. Increased annual expenses, in year zero dollars, are estimated to be $238,000. The estimated market value of equipment in actual dollars at the end of the six-year analysis period is $35,000. General price inflation is estimated at 4.9% per year; the total increase rate of annual revenues is 2.4%, and for annual expenses it is 5.6%; the after-tax MARR (in market terms) is 12% per year (im); and t = 25%. Click the icon to view the interest and annuity table for discrete compounding when i = 12% per year. a. Based on an after-tax, actual-dollar analysis, what is the maximum amount that your company can afford to spend on the total project (i.e., changing the manufacturing operations)? Use the PW method of analysis. Fill in the following table. Express values in A$. (Round to the nearest dollar.) Year ATCF 0 EA 1 $ $ 2 3 A 4 $ 5 6 $ $ 6 Capital Recovery Factor To Find A Given P A/P N 1 1.1200 2 Discrete Compounding; i = 12% Single Payment Uniform Series Compound Compound Sinking Amount Present Amount Present Fund Factor Worth Factor Factor Worth Factor Factor To Find F To Find P To Find F To Find P To Find A Given P Given F Given A Given A Given F F/P P/F FIA PIA A/F 1.1200 0.8929 1.0000 0.8929 1.0000 1.2544 0.7972 2.1200 1.6901 0.4717 1.4049 0.7118 3.3744 2.4018 0.2963 1.5735 0.6355 4.7793 3.0373 0.2092 1.7623 0.5674 6.3528 3.6048 0.1574 1.9738 0.5066 8.1152 4.1114 0.1232 2.2107 0.4523 10.0890 4.5638 0.0991 2.4760 0.4039 12.2997 4.9676 0.0813 2.7731 0.3606 14.7757 5.3282 0.0677 3.1058 0.3220 17.5487 5.6502 0.0570 3.4785 0.2875 20.6546 5.9377 0.0484 3.8960 0.2567 24.1331 6.1944 0.0414 3 4 5 6 7 0.5917 0.4163 0.3292 0.2774 0.2432 0.2191 0.2013 0.1877 0.1770 0.1684 0.1614 8 9 10 11 12 Your company manufactures circuit boards and other electronic parts for various commercial products. Design changes in part of the product line, which are expected to increase sales, will require changes in the manufacturing operation. The cost basis of new equipment required is $240,000 (MACRS five-year property class; GDS, 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, 5.76%). Increased annual revenues, in year zero dollars, are estimated to be $370,000. Increased annual expenses, in year zero dollars, are estimated to be $238,000. The estimated market value of equipment in actual dollars at the end of the six-year analysis period is $35,000. General price inflation is estimated at 4.9% per year; the total increase rate of annual revenues is 2.4%, and for annual expenses it is 5.6%; the after-tax MARR (in market terms) is 12% per year (im); and t = 25%. Click the icon to view the interest and annuity table for discrete compounding when i = 12% per year. a. Based on an after-tax, actual-dollar analysis, what is the maximum amount that your company can afford to spend on the total project (i.e., changing the manufacturing operations)? Use the PW method of analysis. Fill in the following table. Express values in A$. (Round to the nearest dollar.) Year ATCF 0 EA 1 $ $ 2 3 A 4 $ 5 6 $ $ 6 Capital Recovery Factor To Find A Given P A/P N 1 1.1200 2 Discrete Compounding; i = 12% Single Payment Uniform Series Compound Compound Sinking Amount Present Amount Present Fund Factor Worth Factor Factor Worth Factor Factor To Find F To Find P To Find F To Find P To Find A Given P Given F Given A Given A Given F F/P P/F FIA PIA A/F 1.1200 0.8929 1.0000 0.8929 1.0000 1.2544 0.7972 2.1200 1.6901 0.4717 1.4049 0.7118 3.3744 2.4018 0.2963 1.5735 0.6355 4.7793 3.0373 0.2092 1.7623 0.5674 6.3528 3.6048 0.1574 1.9738 0.5066 8.1152 4.1114 0.1232 2.2107 0.4523 10.0890 4.5638 0.0991 2.4760 0.4039 12.2997 4.9676 0.0813 2.7731 0.3606 14.7757 5.3282 0.0677 3.1058 0.3220 17.5487 5.6502 0.0570 3.4785 0.2875 20.6546 5.9377 0.0484 3.8960 0.2567 24.1331 6.1944 0.0414 3 4 5 6 7 0.5917 0.4163 0.3292 0.2774 0.2432 0.2191 0.2013 0.1877 0.1770 0.1684 0.1614 8 9 10 11 12
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started