A commercial property investor is analyzing a 10-year lease with annual rent escalations of 3% and a tenant with a credit rating of BBB. The base rent is $30 per square foot for 5,000 square feet. What is the present value of the lease payments using a 7% discount rate?

Q: What is the correct answer to: A commercial property investor is analyzing a 10-year lease with annual rent escalations of 3% and a tenant with a credit rating of BBB. The base rent is $30 per square foot for 5,000 square feet. What is the present value of the lease payments using a 7% discount rate?

The correct answer is $1,127,560. Option A correctly applies the present value formula for a growing annuity. The calculation starts with Year 1 rent of $150,000 (5,000 sq ft × $30/sq ft), escalating at 3% annually for 10 years, discounted at 7%. Using the formula PV = PMT × [(1-(1+g)/(1+r))^n]/(r-g), where PMT=$150,000, g=3%, r=7%, n=10 years, yields $1,127,560. This formula accounts for both the growth in payments and the time value of money, providing the accurate present value of the entire lease stream.

Q: What background knowledge is needed for this Commercial Real Estate question?

Present value analysis is fundamental in commercial real estate investment. The growing annuity formula accounts for regular payments that increase at a constant rate over time, discounted back to present value using an appropriate discount rate. Commercial leases typically include escalation clauses (often 2-4% annually) to protect against inflation. The discount rate reflects investor risk tolerance and market conditions. Credit ratings (like BBB) indicate tenant creditworthiness and default risk. Under provincial regulations like TRESA and RESA, commercial practitioners must provide competent service, which includes understanding financial analysis methods for investment properties and lease valuations.

Q: What is a good way to remember the answer to this Commercial Real Estate question?

Remember GRAPE for growing annuity calculations: G-Growth rate (3%), R-Required return (7%), A-Annual payment ($150K), P-Present value formula, E-Escalating payments over time. Visualize grapes growing on a vine - each year the vine produces more grapes (escalating rent), but grapes harvested later are worth less today (discounting). When you see escalating lease payments, think GRAPE. Identify the growth rate, discount rate, and base payment, then apply the growing annuity formula. The grape analogy reminds you that future payments grow but are worth less in present value terms.

Q: What exam tip applies to this Commercial Real Estate question?

For escalating lease questions, immediately identify: base rent, escalation rate, discount rate, and time period. Use the growing annuity formula: PV = PMT × [(1-(1+g)/(1+r))^n]/(r-g). Double-check that growth rate is less than discount rate.

Q: How does this Commercial Real Estate concept apply in real world practice?

A commercial broker represents an investor evaluating a retail plaza lease opportunity. The tenant is a national pharmacy chain with BBB credit rating seeking a 10-year lease at $30/sq ft base rent with 3% annual increases. The investor requires 7% return given current market conditions and tenant risk. Using present value analysis, the broker calculates the lease value at $1,127,560, helping the investor compare this opportunity against other investments and determine an appropriate purchase price for the property based on the income stream.

Question

Commercial Real EstateInvestment AnalysisHARD

A commercial property investor is analyzing a 10-year lease with annual rent escalations of 3% and a tenant with a credit rating of BBB. The base rent is $30 per square foot for 5,000 square feet. What is the present value of the lease payments using a 7% discount rate?

Answer Options

A

$1,127,560

B

$1,284,730

C

$1,456,890

D

$1,500,000