Question

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

A company is considering the purchase of a piece of equipment that would cost $400,000 and would last for 9 years. At the end of 9 years, the equipment would have a salvage value of $93,000. The equipment would provide annual cost savings of $73,000. The company requires a minimum pretax return of 17% 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) %

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A potential investment requires an initial cash outlay of $675,000 and has a useful life of...
A potential investment requires an initial cash outlay of $675,000 and has a useful life of 10 years. Annual cash receipts from the investment are expected to be $185,000. The salvage value of the investment is expected to be $60,000. The company’s tax rate is 30%. The entire initial cash outlay (without any reduction for salvage value) will be depreciated over 10 years. Assume a discount rate of 21%. Show your Excel input and calculated net present value after-tax. (If...
Major Corp. is considering the purchase of a new piece of equipment. The cost savings from...
Major 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 $114,000. The equipment will have an initial cost of $577,000 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...
. Provide the structure of the Excel commands to calculate pv(present value), fv(future value), rate(interest rate),...
. Provide the structure of the Excel commands to calculate pv(present value), fv(future value), rate(interest rate), pmt(payment), nper(number of periods).
Grady Corp. is considering the purchase of a new piece of equipment. The equipment costs $51,500,...
Grady Corp. is considering the purchase of a new piece of equipment. The equipment costs $51,500, and will have a salvage value of $5,040 after six years. Using the new piece of equipment will increase Grady’s annual cash flows by $6,190. Grady has a hurdle rate of 12%. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor from the PV tables.) a. What is the present value of...
XYZ Company is considering the purchase of new equipment that will cost $130,000. The equipment will...
XYZ Company is considering the purchase of new equipment that will cost $130,000. The equipment will save the company $38,000 per year in cash operating costs. The equipment has an estimated useful life of five years and a zero expected salvage value. The company's cost of capital is 10%. Required: 1) Ignoring income taxes, compute the net present value and internal rate of return. Round net present value to the nearest dollar and round internal rate of return to the...
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,900. The equipment will have an initial cost of $1,200,900 and have an 8 year life. The salvage value of the equipment is estimated to be $200,900. The hurdle rate is 10%. Ignore income taxes. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of...
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 attached printout of an Excel spreadsheet shows the use of six financial formulas related to...
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial. You will submit your spreadsheet through D2L, and...
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 $54,000. The equipment will have an initial cost of $622,000 and have an 8 year life. The salvage value of the equipment is estimated to be $94,000. If the hurdle rate is 11%, what is the approximate net present value? (Future Value of $1, Present Value of $1, Future Value...
What would be the future value of $15,555 invested now if it earns interest at 14.5...
What would be the future value of $15,555 invested now if it earns interest at 14.5 percent for seven years? Using a financial calculator, enter 15555 and press PV, enter 14.5 and press %i, and enter 7 and press N. Then, press CPT and FV which gives an answer of 40133.63 or $40,133.63. Using Excel, click financial wizard, then FV, enter 0.14 for rate, 7 for nper, 0 for pmt, 15,555 for PV, 0 for type. Press enter answer is...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT