In: Finance
The required rate of return is given. Let us assume it is 10%
Purchase option :
The present value of this option = present value of loan principal repayments + present value of interest payments - present value of interest tax shield - present value of depreciation tax shield
The loan payments, yearly depreciation, their tax shields, and the present value of tax shields are as below :
Interest in each year = (loan amount - cumulative principal repaid) * interest rate
interest tax shield = interest payment * tax rate
depreciation tax shield = depreciation * tax rate
NPV of purchase option is $49,119
Leasing option :
The NPV of leasing option is calculated using PV function in Excel with these inputs :
rate = 10%
nper = 10
pmt = 11,200 * (1 - 40%) (lease payments net of tax)
PV is calculated to be $41,291
The asset should be leased as the NPV of leasing option is lower than the NPV of purchasing option