Question

In: Accounting

A company is considering the purchase of a piece of equipment that would cost $380,000 and...

A company is considering the purchase of a piece of equipment that would cost $380,000 and would last for 8 years. At the end of 8 years, the equipment would have a salvage value of $97,500. The equipment would provide annual cost savings of $85,000. The company requires a minimum pretax return of 12% on all investment projects. (Ignore income taxes.)

Required:

Provide your Excel input and the final net present value amount you calculated. (If a variable is not used in the calculation, input a zero (0). Omit the "$" and "%" signs in your response.) Round your answer to the nearest dollar and use a minus sign for negative numbers.

Excel input:

Rate
%

  Nper

  PMT

$

  PV

$
  FV $
Net Present Value (NPV) $
Required:

Input the required variables and the computed internal rate of return. (If a variable is not used in the calculation, input a zero (0). Omit the "$" and "%" signs in your response.) Round your answer to one decimal place and use a minus sign for negative numbers.

Excel input:

Rate

%

  Nper

  PMT $
  PV $
  FV $


Internal Rate of Return (IRR) %

Solutions

Expert Solution


Related Solutions

Quinn Industries is considering the purchase of a machine that would cost $380,000 and would last...
Quinn Industries is considering the purchase of a machine that would cost $380,000 and would last for 9 years. At the end of 9 years, the machine would have a salvage value of $95,500. The machine would reduce labor and other costs by $76,000 per year. The company requires a minimum pretax return of 14% on all investment projects. (Ignore income taxes.) Required: Provide your Excel input and the final net present value amount you calculated. Required: Input the required...
Quinn Industries is considering the purchase of a machine that would cost $380,000 and would last...
Quinn Industries is considering the purchase of a machine that would cost $380,000 and would last for 9 years. At the end of 9 years, the machine would have a salvage value of $93,000. The machine would reduce labor and other costs by $73,000 per year. The company requires a minimum pretax return of 16% on all investment projects. (Ignore income taxes.) Required: Provide your Excel input and the final net present value amount you calculated. (If a variable is...
6) Company is considering the purchase of a piece of equipment in '12. The projected cost...
6) Company is considering the purchase of a piece of equipment in '12. The projected cost of the equipment is 50,000 The equipment will be depreciated via the MACRS - 5 year life This equipment is expected to generate the following economics: Revenue for first year will be          45,700 Revenue will increase by 1.0% per year thereafter Expenses for first year will be          29,700 Expenses will decrease by 1.0% per year thereafter Company's Capital Structure is as follows:...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment would result in an annual increase in net income of $200000. the equipment will have an initial cost of $1200000 and have an 8 year life. the salvage value of the equipment is estimated to be $200000. the hurdle rate is 10%. what is accounting rate of return? b) what is the payback period? c) what is the net present value? d) what would...
The Masterson, Inc. is considering the purchase of a piece of equipment whose upfront cost is...
The Masterson, Inc. is considering the purchase of a piece of equipment whose upfront cost is $65 million. The company estimates that the result of operating this equipment could go one of two ways: it could be highly successful and produce EBIT of $15 million in year one and that EBIT grows at 3.42% per year for nine more years; or it could be a poor performer and produce only $5 million in EBIT in year one and that will...
Patterson Corp. is considering the purchase of a new piece of equipment, which would have an...
Patterson Corp. is considering the purchase of a new piece of equipment, which would have an initial cost of $528,000, a 7-year life, and $150,000 salvage value. The increase in net income each year of the equipment's life would be as follows: Year 1 $ 105,000 Year 2 $ 97,000 Year 3 $ 95,000 Year 4 $ 84,000 Year 5 $ 81,000 Year 6 $ 76,000 Year 7 $ 70,000 What is the payback period? Multiple Choice 5.92 years 6.13...
Clyde Corp. is considering the purchase of a new piece of equipment. The cost savings from...
Clyde Corp. is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an annual increase in cash flow of $101,100. The equipment will have an initial cost of $601,100 and have an 8 year life. The equipment has no salvage value. The hurdle rate is 8%. Ignore income taxes. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor from...
Briar Corp. is considering the purchase of a new piece of equipment. The cost savings from...
Briar Corp. is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an annual increase in cash flow of $217,000. The equipment will have an initial cost of $1,217,000 and have an 8-year life. The salvage value of the equipment is estimated to be $217,000. The hurdle rate is 6%. Ignore income taxes. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.)...
Grove Corp. is considering the purchase of a new piece of equipment. The cost savings from...
Grove Corp. is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an annual increase in net income of $200,300. The equipment will have an initial cost of $1,200,300 and have an 8 year life. The salvage value of the equipment is estimated to be $200,300. The hurdle rate is 12%. Ignore income taxes. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of...
Wilson Corp. is considering the purchase of a new piece of equipment. The cost savings from...
Wilson Corp. is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an annual increase in net income after tax of $50,000. The equipment will have an initial cost of $626,000 and have an 8 year life. The salvage value of the equipment is estimated to be $114,000. If the hurdle rate is 11%, what is the approximate net present value? can you please explain everything step by step as to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT