Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance In Asia Institutions Regulation And Policy

Authors: Qiao Liu, Paul Lejot, Douglas W. Arner

1st Edition

0415423201, 9780415423205

More Books

Students also viewed these Finance questions