An investor agreed to sell a warehouse five years from now to the tenant who currently rents the space. The tenant will continue to pay $120,000 rent at the end of each year including year 5 in which he will purchase the building for an additional $3,550,000. Assuming the investor's required rate of return is 15%, how much is this deal presently worth to the investor who was willing to sell?

Using Excel