Question

Galvanized Products is considering purchasing a new computer system for their enterprise data management system. The vendor has quoted a purchase price of $130,000. Galvanized Products is planning to borrow 1/4th of the purchase price from a bank at 12.00 % compounded annually. The loan is to be repaid using equal annual payments over a 3-year period. The computer system is expected to last 5 years and has a salvage value of $5,200 at that time. Over the 5-year period, Galvanized Products expects to pay a technician $20,000 per year to maintain the system but will save $51,000 per year through increased efficiencies. Galvanized Products uses a MARR of 20.00 %/year to evaluate investments.
What is the present worth of this investment?

Answer 1

Answer:

The present worth of this investment = -$31,204.78

Explanation:

Note: See the attached excel file for the calculation of the present worth of this investment (in bold red color).

In the attached excel file, the following are used:

Loan from bank = Purchase price * (1 / 4) = $130,000 * (1 / 4) = $32,500

Initial cost = Purchase price - Loan from bank = $130,000 - $32,500 = $97,500

The annual required equal loan payments is calculated using the formula for calculating loan amortization as follows:

P = (A * (r * (1 + r)^n)) / (((1 + r)^n) - 1) .................................... (1)

Where,

P = Annual required equal loan payment = ?

A = Loan amount from bank = $32,500

r = interest rate = 12%, or 0.12

n = number of payment years = 3

Substituting all the figures into equation (1), we have:

P = Annual required equal loan payment = ($32,500 * (0.12 * (1 + 0.12)^3)) / (((1 + 0.12)^3) - 1) = $13,531.34

From the attached excl file, the present worth of this investment is equal to -$31,204.78

Download xlsx