Question

Question 3 15 pts Your manager is proposing a new investment. If the company pursues the investment, it will cost $300,000 today. It has an expected life of 10 years and no salvage value. An environmental impact fee of $25,000 must be paid to the government every five years, once at the end of year five and again to safely dispose of the investment at the end of year 10. As a result of the investment, annual revenue increases are estimated to be $70,000 per year. Your company must borrow 1/2 of the initial investment cost. The bank has agreed to four equal annual payments, with the first payment due at the end of year 1. The company's MARR is 10% compounded annually. The loan interest rate is 12% compounded annually. a) How much is the loan payment? b) What is the present worth of this investment opportunity? c) Based on the present worth analysis, should the company make the investment? Why or why not? [Create an .xls file to solve OR capture an image of your "by hand" work and upload here] Upload Choose a File Exam 2 Question 3.xlsx has been removed.

Answer 1

a. Loan amount = 300000 / 2 = 150000

Loan interest rate = 12%

Loan term = 4 yrs

Loan payment = 150000 * (A/P, 12%,4) = 150000 * 0.329234 = 49385.16

b. NPW of investment = -150000 - 49385.16 * (P/A, 10%,4) - 25000 *(P/F, 10%,5) - 25000 * (P/F, 10%,10) + 70000 * (P/A, 10%,10)

= -150000 - 49385.16 * 3.169865 - 25000 * 0.620921 - 25000 * 0.385543 + 70000 * 6.144567

= 98413.80

c. As NPW of project is positive, it should be selected