A retail lease for 10,000 square feet of rentable space is being negotiated for a five-year term. Option A calls for a base rent of $25 per square foot for the coming year with step-ups of $1 per year each year thereafter. CAM charges are expected to be $3 for the coming year and are forecasted to increase by 6 percent at the end of each year thereafter. Option B calls for a lower base rent of $23 per square foot with the same stepups and CAM charges, but the tenant must pay overage rents based on a percentage lease clause. The clause specifies that the tenant must pay 8 percent on gross sales over a breakpoint level of $900,000 per year. The owner believes that the tenant's gross sales will be $850,000 during the first year but should increase at a rate of 10 percent per year each year thereafter. a. If the property owner believes that 10 percent rate of return should be earned annually on this real estate investment, which option is best? What if sales are expected to increase by 20 percent per year? Option A Year 1 2 3 4 5 Base Rent CAM Net Rent Present Value Effective rent/square foot Option B Year 1 2 3 4 5 Base Rent CAM Net Rent Sales Overage Rent Overage Rent/sqft. Calculate Effective Rent: PV of Net Rent = NPV (10%, Rent_each_year) PV of Overage Rent = NPV (10%, Overage Rent) PV of Total Rent Revenue = Net Rent + Overage Rent Effective rent/square foot = Effective rent/Rentable_area) Option B with 20% increase in Sales Year 1 2 3 4 5 Base Rent CAM Net Rent Sales Overage Rent $ Overage Rent/saft. Calculate Effective Rent: PV of Net Rent = NPV (10%, Rent_each_year) PV of Overage Rent = NPV (10%, Overage Rent) PV of Total Rent Revenue = Net Rent + Overage Rent Effective rent/square foot = Effective rent/Rentable_area)