Question

A developer is proposing to build and operate an 8 store strip mall. Each unit would rent for $3,500 per month. It is expected that vacancy would run at 15% and that the expenses would be 17.5%. The loan is to be 75% of the capitalized value. The developer has an MARR of 12.5%, the bank is charging 8.5% interest, and the Long Term Debt Service is a constant 9%. To assess the financial worth of this endeavor, determine the following:

a. CAP Rate
b. Capitalized value
c. Loan amount
d. Debt Service Coverage Ratio
e. Loan per unit

Answer 1

Requirement A: CAP Rate is 12.5%

Requirement B: Capitalized Value of the Property is $1,884,960

Requirement C: Loan Amount is $1,413,720

Requirement D: Debt Service Coverage Ratio is 1.85

Requirement E: Loan per unit is $176,715 Per Unit

Step-by-step explanation:

Requirement A: Find the CAP Rate

The CAP Rate will be calculated using the following formula:

CAP Rate = Annual Net Operating Income (NOI) (Step1) / Property Capitalized Value (Step2)

Here

Operating Income is $235,620 (Step1)

Property Capitalized Value (Step2)

Now, by putting values we have:

CAP Rate = $235,620 / $1,884,960 = 12.5%

Step1: Find Annual Net Operating Income (NOI)

As we know that:

Operating Income = Expected Revenue - Operating Expense

Here

Expected Revenue from 8 Strip Malls = Rent / Month * 12 Months * (1 - Vacancy Ratio) * 8 Strips Malls

= $3,500 * 12 * (1 - 15%) * 8

= $285,600

Operating Expenses = Expected Revenue * 17.5%

= $285,600 * 17.5% = $49,980

Now by putting value in the above Operating Income equation, we have:

Annual Operating Income = $285,600 - $49,980 = $235,620

Step2: Find Property Capitalized Value (It is also Requirement B)

Property Capitalized Value = Annual Operating Income / Minimum Accepted Rate of Return (MARR)

Here

Annual Operating Income is $235,620 from Step1

MARR is 12.5%

By putting values, we have:

Capitalized Value of the Property = $235,620 / 12.5% = $1,884,960

Requirement C. Find Loan Amount

It is given in the question that the Loan Amount is 75% of Property Capitalized Cost. This implies:

Loan Amount = $1,884,960 * 75% = $1,413,720

Requirement D. Debt Service Coverage Ratio

Debt Service Coverage Ratio (DSCR) = Annual Net Operating Income / Total Debt Service for the Year

Here

Annual Net Operating Income is $235,620 from Step1

Total Debt Service for the Year $127,235 (See Step3 below)

By putting values, we have:

Debt Service Coverage Ratio = $235,620 / $127,235 = 1.85

Step3: Total Debt Service for the year

Total Debt Service for the year = Loan Amount * Debt Service Rate

Here

Loan Amount is $1,413,720

Debt Service Rate is 9%

By putting values, we have:

Total Debt Service for the year = $1,413,720 * 9% = $127,235

Requirement E. Find Loan Amount

We can find loan per unit by simply dividing the loan amount by number of strip mall. Here total number of strip mall are 8. This implies that:

Loan Per Unit = $1,413,720 / 8 Units = $176,715 Per Unit