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?
Correct Answer
A) $1,127,560
This requires calculating the present value of an escalating annuity. Year 1 rent = $150,000 (5,000 × $30), escalating at 3% annually, discounted at 7%. Using the present value formula for growing annuities: PV = $150,000 × [(1-(1.03/1.07)^10)/(0.07-0.03)] = $1,127,560.
Why This Is the Correct Answer
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.
Why the Other Options Are Wrong
Option B: $1,284,730
This amount likely results from using an incorrect discount rate or growth rate in the calculation. It may reflect using a lower discount rate or failing to properly account for the escalation factor, resulting in an overvaluation of the lease payments' present value.
Option C: $1,456,890
This figure suggests a calculation error, possibly from using simple rather than compound escalation, or applying an incorrect present value formula. It significantly overvalues the lease stream by not properly discounting future payments or miscalculating the growth factor.
Option D: $1,500,000
This represents the total nominal value of Year 1 rent multiplied by 10 years without any escalation or discounting. It ignores both the time value of money and the 3% annual rent increases, making it an inappropriate valuation method.
Deep Analysis of This Commercial Real Estate Question
This question tests understanding of present value calculations for escalating commercial lease payments, a critical skill for commercial real estate valuation and investment analysis. The calculation involves determining the present value of a growing annuity where rent increases annually at a fixed percentage. This concept is fundamental in commercial real estate as most long-term leases include escalation clauses to protect landlords against inflation. The discount rate reflects the investor's required rate of return and market risk assessment. Understanding this calculation is essential for commercial practitioners who must evaluate lease terms, compare investment opportunities, and advise clients on lease negotiations. The tenant's BBB credit rating provides context for risk assessment but doesn't directly affect the mathematical calculation. This type of analysis supports informed decision-making in commercial transactions and helps determine fair market values for income-producing properties.
Background Knowledge for Commercial Real Estate
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.
Memory Technique
The GRAPE MethodRemember 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.
Exam Tip for Commercial Real Estate
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.
Real World Application in Commercial Real Estate
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.
Common Mistakes to Avoid on Commercial Real Estate Questions
- •Using simple interest instead of compound escalation
- •Forgetting to discount future payments to present value
- •Confusing the growth rate with the discount rate in the formula
Key Terms
More Commercial Real Estate Questions
What type of commercial lease requires the tenant to pay a base rent plus a percentage of their gross sales?
In a triple net lease (NNN), which of the following expenses is the tenant typically responsible for?
What does NOI stand for in commercial real estate investment analysis?
Which commercial property type is typically characterized by anchor tenants and percentage rent clauses?
A commercial property generates $180,000 in annual rental income and has operating expenses of $45,000. If the capitalization rate is 8%, what is the estimated property value?
- → In Ontario, what is the typical notice period required for a commercial tenant to terminate a lease at the end of the term?
- → What is the primary difference between a gross lease and a net lease?
- → A retail tenant's lease includes a percentage rent clause of 6% of gross sales above a natural breakpoint. If the base rent is $48,000 annually and the tenant's gross sales are $950,000, what is the total annual rent?
- → In British Columbia, which legislation primarily governs the relationship between commercial landlords and tenants?
- → An investor is analyzing two similar office buildings. Building A has a cap rate of 6.5% and Building B has a cap rate of 8.0%. Assuming all other factors are equal, what does this difference most likely indicate?
- → An office building generates $200,000 in gross rental income with operating expenses of $75,000. If the property was purchased for $1,250,000, what is the capitalization rate?
- → What is the primary difference between a gross lease and a net lease in commercial real estate?
- → Which type of commercial property would most likely use a percentage lease structure?
- → What does NOI stand for in commercial real estate investment analysis?
- → A commercial property generates $120,000 in annual rental income and has operating expenses of $35,000. If the capitalization rate is 8%, what is the estimated property value?
People Also Study
Real Property Law
60 questions
Contracts & Agreements
60 questions
Agency & Professional Ethics
60 questions
Mortgage & Real Estate Finance
60 questions
Helpful Resources
Previous Question
A commercial property investment analysis shows an IRR of 12% and an NPV of $150,000 using a 10% discount rate. An investor requires a minimum 15% return. What should the investor's decision be?
Next Question
A commercial property investor is analyzing two similar properties: Property A has a 7% cap rate and Property B has a 9% cap rate. Assuming similar NOI, what does this difference primarily indicate?