Question

In: Finance

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 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

Year Cashflows Discounting factor for 8% Present value@8% Discounting factor for 13% Present value@13% Discounting factor for 8.9% Present [email protected]%
0 -20250 1 -20250 1 -20250 1 -20250
1 4500          0.93 4,166.67          0.88 3,982.30          0.92 4,132.23
2 4500          0.86 3,858.02          0.78 3,524.16          0.84 3,794.52
3 4500          0.79 3,572.25          0.69 3,118.73          0.77 3,484.41
4 4500          0.74 3,307.63          0.61 2,759.93          0.71 3,199.64
5 4500          0.68 3,062.62          0.54 2,442.42          0.65 2,938.14
6 4500          0.63 2,835.76          0.48 2,161.43          0.60 2,698.02
NPV      552.96 -2,261.03         -3.04
IRR 8.89%
Ans a. At rate of return of 8%, we get NPV of $552.96 and hence the system is worth installing.
Ans b. At rate of return of 13%, we get NPV of -$2261.03 and hence the system is not worth installing.
NPV is the present value of cash inflows less present value of cash outflows
IRR Explaination:-
Internal rate of return is the rate where NPV of the project is zero. To calculate IRR, we should set NPV is equal to zero and solve for discount rate which is the IRR.
Using trial and error method we guessed the discounting rate to be 8.89% .
Ans c. Internal Rate of Return is the rate at which NPV is zero i.e. no profit no loss. So at IRR of 8.89% the NPV will be zero and anything above this rate will give negative npv as also evident from the calculations above (i.e. Return of 13% gives negative npv). One should not accept the project with negative npv and hence IRR i.e. 8.89 is the highest rate after which one will start rejecting the project.
Also see at return of 8.90% as calculated above we have started getting negative NPV

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 $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...
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