CRECI Commercial Property Financials Questions and Answers 1 — Questions and Answers
Question 1: An investor is analyzing a commercial property with a Net Operating Income (NOI) of $150,000 and an annual debt service of $120,000. The property's lender requires a minimum Debt Service Coverage Ratio (DSCR) of 1.20x. Based on these figures, what is the property's DSCR, and does it meet the lender's requirement?
- 1.15x; it does not meet the requirement.
- 1.25x; it meets the requirement. (Correct answer)
- 0.80x; it does not meet the requirement.
- 1.20x; it just meets the requirement.
Correct answer: 1.25x; it meets the requirement.
The Debt Service Coverage Ratio (DSCR) is calculated by dividing the Net Operating Income (NOI) by the total annual debt service. In this scenario, $150,000 (NOI) / $120,000 (Debt Service) = 1.25. Since 1.25 is greater than the lender's minimum requirement of 1.20, the property meets the requirement.
Question 2: Which of the following is excluded from the calculation of a property's Net Operating Income (NOI)?
- Property Management Fees
- Annual Debt Service (Correct answer)
- Utilities
- Property Taxes
Correct answer: Annual Debt Service
Net Operating Income (NOI) represents a property's income-generating ability from its operations. It is calculated before subtracting financing and tax-related costs. Therefore, annual debt service (principal and interest payments), capital expenditures, and income taxes are excluded from the NOI calculation. Property taxes, insurance, utilities, and management fees are considered operating expenses and are deducted from the Effective Gross Income to arrive at NOI.
Question 3: A real estate analyst is preparing a financial projection for a potential acquisition. This document estimates future income and expenses over a ten-year holding period, incorporating assumptions about rent growth, vacancy rates, and operating cost inflation. What is this type of financial statement called?
- Trailing 12-Month Operating Statement
- Balance Sheet
- Rent Roll
- Pro Forma (Correct answer)
Correct answer: Pro Forma
A pro forma is a forward-looking financial projection used to estimate a property's future cash flows and profitability. Unlike a historical or trailing operating statement which shows past performance, a pro forma is based on assumptions about the future.
Question 4: An investor purchases a property for $2,000,000, paying $500,000 in cash and financing the rest. The property generates an annual pre-tax cash flow of $40,000 after all expenses, including debt service, have been paid. What is the investor's cash-on-cash return?
- 2.0%
- 2.5%
- 8.0% (Correct answer)
- 10.0%
Correct answer: 8.0%
The cash-on-cash return measures the annual pre-tax cash flow relative to the total cash invested. The formula is: (Annual Pre-Tax Cash Flow / Total Cash Invested). In this case, $40,000 / $500,000 = 0.08, or 8.0%.
Question 5: Two properties are for sale in the same submarket. Property A has a capitalization rate of 5.5%, while Property B has a capitalization rate of 7.5%. Which of the following statements is most likely true?
- Property A has a higher Net Operating Income than Property B.
- Property B is perceived by the market as a higher-risk investment than Property A. (Correct answer)
- Property A is a more profitable investment than Property B.
- Property B has a lower valuation for a similar NOI compared to Property A.
Correct answer: Property B is perceived by the market as a higher-risk investment than Property A.
The capitalization (cap) rate is calculated as NOI / Property Value. A higher cap rate generally implies a higher potential return but also greater perceived risk by the market. Investors demand a higher return to compensate for risks such as an older building, less stable tenants, or a less desirable location. A lower cap rate suggests a lower-risk, more stable asset, for which investors are willing to pay a higher price relative to its income.
Question 6: An analyst is calculating the value of a stabilized office building. If the Net Operating Income (NOI) is $250,000 and the prevailing market capitalization rate for similar properties is 6.25%, what is the estimated value of the property?
- $3,125,000
- $4,500,000
- $4,000,000 (Correct answer)
- $1,562,500
Correct answer: $4,000,000
The capitalization rate formula (Cap Rate = NOI / Value) can be rearranged to solve for the property's value (Value = NOI / Cap Rate). By dividing the Net Operating Income by the market cap rate, you can estimate the property's value. Calculation: $250,000 / 0.0625 = $4,000,000.
An investor is analyzing a commercial property with a Net Operating Income (NOI) of $150,000 and an annual debt service of $120,000.
The property's lender requires a minimum Debt Service Coverage Ratio (DSCR) of 1.20x.
Based on these figures, what is the property's DSCR, and does it meet the lender's requirement?