Need answers in an excel spreadsheet, finance, Other Engineering

Assignment Help:
1
Scott Investors, Inc., is considering the purchase of a $447,000 computer with an economic life of five years. The computer will be fully depreciated over five years using the straight-line method. The market value of the computer will be $75,000 in five years. The computer will replace five office employees whose combined annual salaries are $155,000. The machine will also immediately lower the firm’s required net working capital by $87,000. This amount of net working capital will need to be replaced once the machine is sold. The corporate tax rate is 32 percent.

Required:
Calculate the NPV if the appropriate discount rate is 12 percent.

2

A firm is considering an investment in a new machine with a price of $12.6 million to replace its existing machine. The current machine has a book value of $4.6 million and a market value of $3.6 million. The new machine is expected to have a four-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save $5.1 million in operating costs each year over the next four years. Both machines will have no salvage value in four years. If the firm purchases the new machine, it will also need an investment of $310,000 in net working capital. The required return on the investment is 9 percent, and the tax rate is 39 percent.

Requirement 1:
(a) What is the NPV of the decision to purchase a new machine? (Do not include the dollar sign ($). Round your answer to 2 decimal places. (e.g., 1,234,567.89))

NPV $ n/r

(b) What is the IRR of the decision to purchase a new machine? (Do not include the percent sign (%). Round your answer to 2 decimal places. (e.g., 32.16))

IRR n/r %

Requirement 2:
(a)
What is the NPV of the decision to keep the old machine? (Do not include the dollar sign ($). Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places. (e.g., 1,234,567.89))

NPV $ n/r

(b)
What is the IRR of the decision to keep the old machine? (Do not include the percent sign (%). Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places. (e.g., 32.16))

IRR n/r %
3. 6.value:
4 points

Pilot Plus Pens is deciding when to replace its old machine. The machine’s current salvage value is $1.84 million. Its current book value is $1.21 million. If not sold, the old machine will require maintenance costs of $517,000 at the end of the year for the next five years. Depreciation on the old machine is $242,000 per year. At the end of five years, it will have a salvage value of $209,000 and a book value of $0. A replacement machine costs $3.1 million now and requires maintenance costs of $335,000 at the end of each year during its economic life of five years. At the end of the five years, the new machine will have a salvage value of $506,000. It will be fully depreciated by the straight-line method. In five years a replacement machine will cost $3,602,000 . Pilot will need to purchase this machine regardless of what choice it makes today. The corporate tax rate is 31 percent and the appropriate discount rate is 12 percent. The company is assumed to earn sufficient revenues to generate tax shields from depreciation. Should Pilot Plus Pens replace the old machine now or at the end of five years?

Requirement 1:
What is the NPV of the decision to purchase a new machine? (Do not include the dollar sign ($). Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places. (e.g., 1,234,567.89))

NPV $

Requirement 2:
What is the NPV of the decision to keep the old machine? (Do not include the dollar sign ($). Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places. (e.g., 1,234,567.89))

Related Discussions:- Need answers in an excel spreadsheet, finance

Mode iii interlaminar fracture toughness , Mode III Interlaminar Fracture T...

Mode III Interlaminar Fracture Toughness  The Mode III interlaminar fracture toughness of a composite can be measured using the split cantilever beam (SCB) geometry. Here, a c

Allowances for pattern, Allowances for pattern : A pattern is always made ...

Allowances for pattern : A pattern is always made larger than the required size of the casting in order to allow for various factor, such as shrinkage, machining, distortion and r

Electronics, how to make an amplifier circuit ?

how to make an amplifier circuit ?

Trade-offs in communications designs, Trade-offs in Communications Designs ...

Trade-offs in Communications Designs Satellite and Deep Space Communications               - Power is expensive to generate in space and transmission distances are eno

Effects of temperature and altitude on engine, Effects of Temperature and A...

Effects of Temperature and Altitude. Cold and/or Low On cold days the air density will increase. If the engine has a ‘part throttle rating' and the throttle is advanced to

Fire protection systems of aircraft, FIRE PROTECTION SYSTEMS A complete...

FIRE PROTECTION SYSTEMS A complete fire warning system consists of a detection system, an extinguisher system and a method of detecting that the fire is out. There are specifi

Smoke control - fire protection engineering, Smoke control - fire protectio...

Smoke control - fire protection engineering: Smoke control is a complex subject and requires a course of at least one whole week to begin to understand how it is used in build

Sustainability concepts associated with ubiquitous computing, Question: ...

Question: (a) Spreading the spectrum for signal transmission helps alleviate the narrow band interference problem. What is narrow band interference? State and describe 2 differ

Electron gun, Electron gun: The electron gun consists of the following:...

Electron gun: The electron gun consists of the following: 1.  Cathode:  An indirectly heated cathode (negatively biased w.r.t. the screen). 2.  Grid:          A cylindric

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd