Question

In: Finance

PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company...

PLEASE DO NOT USE EXCEL, as we cannot use excel on our test.

The Wagner Company currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6-years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $350 [($2,100/6) = $350 per year]. If the old machine is not replaced, it can be sold for $500 at the end of its useful life. Wagner is offered a replacement machine that has a cost of $8,000, an estimated useful life of 6 years, and an estimated salvage value of $800. This machine falls into the MACRS 5-year class, so the applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. The replacement machine would permit an output expansion, so sales would rise by $2,000 per year. Even so, the new machine's much greater efficiency would reduce operating expenses by $3,000 per year. The new machine would require that inventories be increased by $4,000, but accounts payable would simultaneously increase by $1,000. Wagner's marginal federal-plus-state tax rate is 40%, and its WACC is 15%. Should The Wagner Company replace the old machine? Justify your answer.

Solutions

Expert Solution


Related Solutions

PLEASE DO NO USE EXCEL, as we are not able to use excel on our test...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test XYZ company is considering a new machine that costs $300,000 and would reduce pre-tax manufacturing costs by $108,000 annually. XYZ would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The net operating working capital...
-please answer this written out. Do not use excel I cannot access it. i need to...
-please answer this written out. Do not use excel I cannot access it. i need to know how to do it on paper- Deluxe River Cruises operates a fleet of river vessels. The fleet has two types of vessels: A type A vessel has 60 deluxe cabins and 160 standard cabins, whereas a type B vessel has 80 deluxe cabins and 120 standard cabins. Under a charter agreement with the Odyssey Travel Agency, Deluxe River Cruise sis to provide Odyssey...
Please do not use Excel to answer this. I need the computations as we are not...
Please do not use Excel to answer this. I need the computations as we are not allowed to use excel. Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $80,000 $312,000    $165,000    $78,500 $107,400 Square feet 1,500...
Why do we test the null hypothesis and not our research hypothesis?
Why do we test the null hypothesis and not our research hypothesis?
We are now going to use Excel to test a hypothesis based on one given sample....
We are now going to use Excel to test a hypothesis based on one given sample. We would like to know if the average cholesterol level of patients in intensive care is equal to 200 and for that reason we collect cholesterol level of 20 random people from various intensive care units. Cholesterol level 154,168,134,201,208,220,225,228,201,207,168,211,203,254,268,198,298,135,154,189 We put our data in column A. In Cells A3-A22 we type our data and in cell A1 we type Cholesterol. First let’s input the...
Chi Square Test We will now use Excel to run an example of a chi square...
Chi Square Test We will now use Excel to run an example of a chi square test. Chi square test is checking the independence of two variables. Our example will test if taking hormonal pills and being overweight are related. We will test the independence on 200 random patients. Thus, N=200. They will be divided first into two groups, those who take hormonal pills and those who do not. Second, they will be divided into three groups based on weight,...
What are two things in the repeated measure anova test that we can do in our...
What are two things in the repeated measure anova test that we can do in our study that would increase our power?
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company Based on a Mini Case presented in the textbook Ross, S.A., R.W. Westerfield and J. Jaffe, Corporate Finance, McGraw Hill/Irwin. Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the...
PLEASE DO BY HAND AND NOT EXCEL Suppose we have the following data on variable X...
PLEASE DO BY HAND AND NOT EXCEL Suppose we have the following data on variable X (independent) and variable Y (dependent): X         Y 2          70 0          70 4          130 a. Test to see whether X and Y are significantly related using a t-test on the slope of X. Test this at the 0.05 level. b. Test to see whether X and Y are significantly related using an F-test on the slope of X. Test this at the 0.05 level.
please use excel to do it. it also need to come with formula. formula is very...
please use excel to do it. it also need to come with formula. formula is very important. many many thanks. Prepare a sales budget for January through March and for the Quarter in total. The selling price per unit is $50.00. December of the previous year           20,000 January                                     100,000 February                                   80,000 March                                       60,000 April                                         40,000                           2. Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT