Question

In: Finance

A new computer system will require an initial outlay of $18,750, but it will increase the...

A new computer system will require an initial outlay of $18,750, but it will increase the firm’s cash flows by $4,200 a year for each of the next 6 years.

a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.)

b. Calculate the NPV and decide if the system is worth installing if the required rate of return is 13%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.)

c. How high can the discount rate be before you would reject the project? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

Solutions

Expert Solution

For part (c), to check the discount rate, we can use Goal seek function in excel. Let's see how.

In order to calculate the discount rate beyond which we reject the project. We need to understand that the moment our NPV becomes zero, We can decide the rate beyond which we will reject the project.

Thus, we will use the goal seek function like this:

1. Go to Goal Seek in What if analysis in the Data tab

2. When Goal Seek will open, In the Set cell, select the column of NPV.(In the figure below, E11 has been written which contrains value of NPV). Set it to 0 & change the discount rate column which is G3.The answer is 9.162% as calculated by Goal seek below(yellow portion below)


Related Solutions

A new computer system will require an initial outlay of $20,000, but it will increase the...
A new computer system will require an initial outlay of $20,000, but it will increase the firm’s cash flows by $4,300 a year for each of the next 8 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $24,500, but it will increase the...
A new computer system will require an initial outlay of $24,500, but it will increase the firm's cash flows by $4,900 a year for each of the next 8 years. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. Calculate the NPV and decide if the system is worth installing if the required rate of return is 14%. How high can the discount rate be before you would reject the...
A new computer system will require an initial outlay of $17,500, but it will increase the...
A new computer system will require an initial outlay of $17,500, but it will increase the firm’s cash flows by $3,500 a year for each of the next 8 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $24,000, but it will increase the...
A new computer system will require an initial outlay of $24,000, but it will increase the firm’s cash flows by $4,800 a year for each of the next 6 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%. What if it is 13%? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Rate of Return NPV...
A new computer system will require an initial outlay of $21,500, but it will increase the...
A new computer system will require an initial outlay of $21,500, but it will increase the firm’s cash flows by $4,600 a year for each of the next 8 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 9%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $20,250, but it will increase the...
A new computer system will require an initial outlay of $20,250, but it will increase the firm’s cash flows by $4,500 a year for each of the next 6 years. A) Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) B) Calculate the NPV and decide if the system...
A new computer system will require an initial outlay of $17,000, but it will increase the...
A new computer system will require an initial outlay of $17,000, but it will increase the firm’s cash flows by $3,400 a year for each of the next 7 years. a. Calculate the NPV and decide if the system is worth installing if the required rate of return is 10%. b. Calculate the NPV and decide if the system is worth installing if the required rate of return is 15%.
A new computer system will require an initial outlay of $19,250, but it increase the firm's...
A new computer system will require an initial outlay of $19,250, but it increase the firm's cash flows by $4,100 a year for the next 7 years. A. Calculate the NPV and decide if the system is worth installing if the required rate of return is 10%. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the NPV and decide if the system is worth installing...
You are considering buying new PACS hardware/software that will require an initial outlay of $54,200. The...
You are considering buying new PACS hardware/software that will require an initial outlay of $54,200. The system has an expected useful life of 5 years and will generate free cash flows to the hospital as a whole of $20,608 at the end of each year over its 5 year life. In addition, the salvage value of the system is expected to be $13,200 based on current market conditions. Given a required rate of return of 15 percent, determine the following:...
1. A new hog investment requires an initial outlay of $130,000 and is expected to increase...
1. A new hog investment requires an initial outlay of $130,000 and is expected to increase operating receipts by 87,000 but will also increase operating expenses by 23,000. The investment will be depreciated over 15 years and will have a $0 salvage value. The marginal tax rate is 30%. The investment will be analyzed over 7 years and the terminal value of the hog investment after 7 years will be $45,000. The pre-tax discount rate is 13.5%. What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT