A company is considering purchasing equipment to conduct quality inspections of one of its finished products....

A company is considering purchasing equipment to conduct quality inspections of one of its finished products. The equipment will cost $ 150,000 and it is estimated that due to its specialized function it will have no resale value at the end of its useful life. The equipment's operation and maintenance costs are estimated to be $ 1,000 in the first year, and management expects these costs to increase in subsequent years according to the inflation rate. The company estimates that the useful life of the equipment will be 10 years. The team qualifies for depreciation purposes as a 5-year MACRS property. Assume that headline inflation during that period will be 3%, the tax rate 35%, and the inflation-adjusted rate of return 15% (Market Rate).
Determine:
1) The present value PW and EAW of the costs associated with this purchase in a pre-tax analysis.
2) The PW present value and the EAW of the costs associated with this purchase in an after-tax analysis.
You must use Excel to solve this problem and display all your computations. Include comments and
annotations.
You must use Excel to solve these problems and display all your computations. Include comments and annotations when you deem it necessary (for example, to make a presumption).

Please use Excel only to solve this problem and include it's functional functions. Help me. Thanks.

Solutions

Expert Solution

Answer is attached below

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

A company is considering purchasing equipment to conduct quality inspections of one of its finished products....

M&M company is considering purchasing equipment to conduct quality inspections of one of its finished products....

M&M company is considering purchasing equipment to conduct quality inspections of one of its finished products. The equipment will cost $ 150,000 and it is estimated that due to its specialized function it will have no resale value at the end of its useful life. The equipment's operation and maintenance costs are estimated to be $ 1,000 in the first year, and management expects these costs to increase in subsequent years according to the inflation rate. The company estimates that...

A company is considering purchasing equipment to perform quality inspections of one of its finished products....

A company is considering purchasing equipment to perform quality inspections of one of its finished products. The equipment will cost $150,000 and it is estimated that its specialized function will have no resale value at the end of its useful life. It is estimated that the operating and maintenance costs of the equipment will be $1,000 in the first year and management expects these costs to increase in subsequent years in line with the inflation rate. The company estimates that...

ANALYSIS OF COSTS WITH INFLATION A company is considering purchasing equipment to conduct quality inspections of...

ANALYSIS OF COSTS WITH INFLATION A company is considering purchasing equipment to conduct quality inspections of one of its finished products. The equipment will cost $ 150,000 and it is estimated that due to its specialized function it will have no resale value at the end of its useful life. The equipment's operation and maintenance costs are estimated to be $ 1,000 in the first year, and management expects these costs to increase in subsequent years according to the inflation...

An Engineering company is considering purchasing a piece of plant equipment and wishes to compare its...

An Engineering company is considering purchasing a piece of plant equipment and wishes to compare its replacement strategies for purchase and maintenance over a period of time. The machine’s initial cost is $170,000 with immediate payment required. Running Costs including maintenance are $12,000 in year 1, $17,000 in year 2, $24,000 in year 3 and $33,000 in year 4. Payments are required at the end of each year. Interest rates are 4% p.a. The equipment will have a salvage value...

An Engineering company is considering purchasing a piece of plant equipment and wishes to compare its...

An Engineering company is considering purchasing a piece of plant equipment and wishes to compare its replacement strategies for purchase and maintenance over a period of time. The machine’s initial cost is $160,000 with immediate payment required. Running Costs including maintenance are $11,000 in year 1, $16,000 in year 2, $23,000 in year 3 and $32,000 in year 4. Payments are required at the end of each year. Interest rates are 4% p.a. The equipment will have a salvage value...

A company is considering purchasing new equipment. The purchase of the equipment is expected to...

A company is considering purchasing new equipment. The purchase of the equipment is expected to generate after tax savings of $12,600 each year for 8 years. The company can borrow money at 6%. Assume annual compounding. Determine the present value of the future cash inflows. Hint: the $12,600 are your annuity payments

3. Chavez Company is considering purchasing new equipment or overhauling its existing equipment. The manager has...

3. Chavez Company is considering purchasing new equipment or overhauling its existing equipment. The manager has gathered the following information: Current machinery: Original cost $ 50,000 Accumulated depreciation 40,000 Annual operating costs 5,000 Current market value 1,500 Salvage value at the end of five years - Cost of overhauling machinery: Cost of overhaul $ 12,000 Annual operating costs after overhauling 2,000 Salvage value at the end of five years - New machinery: Cost $ 56,000 Annual operating costs 1,000 Salvage...

A company is considering of purchasing a testing equipment costing $50,000. This equipment is expected to...

A company is considering of purchasing a testing equipment costing $50,000. This equipment is expected to reduce labor costs by $16,000 annually. The equipment has useful life of 5 years, but falls in the 3-year property class for depreciation purpose. No salvage value is expected at the end. The marginal tax rate is 34% and its required after-tax rate of return is 16%. 1.What is the incremental after-tax cash flow for the first year of operation? 2.On the basis of...

A company is considering whether to replace one of its construction equipment. • The existing equipment...

A company is considering whether to replace one of its construction equipment. • The existing equipment has a current cost of $15,000, which declines by 20% each year for three years. The operating cost for this equipment is $20,000 for year 1, $8,000 for year 2, and $12,000 for year 3. • The proposed equipment will cost $50,000, last five years, and has a market value that declines by 20% each year. The operating cost for the proposed equipment is...

Subjects