Nodhead College needs a new computer. It can either buy it for $295,000 or lease it from Compulease. The lease terms require Nodhead to make six annual payments (prepaid) of $71,000. Nodhead pays no tax. Compulease pays tax at 35%. Compulease can depreciate the computer for tax purposes straight-line over five years. The computer will have no residual value at the end of year 5. The interest rate is 6%.

a. What is the NPV of the lease for Nodhead College?

b. What is the NPV for Compulease?

c. What is the overall gain from leasing?

PLEASE HELP ME SOLVE ONLY (b) NPV for Compulease. Please solve using excel formulas if possible.