Harbourline Logistics Inc. can move its warehouse: one-time costs of 210,000 at t = 0 (lease-break penalty 90,000, moving 60,000, lost transition contribution 35,000, retention bonuses 25,000) and a rent saving of 60,000 at the end of each of the next four years. Its required return is 10 %; the PV-of-an-annuity factor for 4 years at 10 % is 3.1699. Compute the discounted worksheet and the decision.
Harbourline Logistics Inc. can move its warehouse: one-time costs of 210,000 at t = 0 (lease-break penalty 90,000, moving 60,000, lost transition contribution 35,000, retention bonuses 25,000) and a rent saving of 60,000 at the end of each of the next four years. Its required return is 10 %; the PV-of-an-annuity factor for 4 years at 10 % is 3.1699. Compute the discounted worksheet and the decision.
Answer
PV of savings at 10 % → 190194 · NPV of the move → -19806 · Decision (1 for move, 0 for stay) → 0
Cells - PV of savings at 10 % · ±5 - NPV of the move · ±5 - Decision (1 for move, 0 for stay) · ±0 60,000 × 3.1699 = 190,194; less 210,000 of one-time costs at t0 (undiscounted) = −19,806 → NPV < 0 → stay. Excel: =PV(10%,4,-60000)-210000. The undiscounted +30,000 of lesson 12.5 was provisional; this is the answer to act on.
Hermanson Vol 2 ch 26; Heisinger & Hoyle §8.4