Question

In: Finance

One of your Client wants to buy a Rental Property, with estimated Net Operating Income (NOI)...

One of your Client wants to buy a Rental Property, with estimated Net Operating Income (NOI) for the next year of 80,000, using a (L/V) Ratio of 85%, amortized at a Mortgage Rate of 6.5% over 25 years. Your Client wants to have a Return on Equity (ROE) of 12%. You have decide to use a Band of Width Investment Method to estimate the Cap Rate and then apply this Cap Rate to Calculate Value of the Rental Property. According to your Calculation, the Value of the Rental Property is approximately is:

a.

$ 921,000

b.

$ 583,000

c.

$ 700,800

d.

$ 727,300

Solutions

Expert Solution

Cap Rate = F+E

Here F = Financing component

E = Equity component

Calculation of Financing component:-

the Financing component means annual mortgage constant multiplied by the loan to value ratio

Annual mortgage constant:-

Annual mortgage constant = 12 * i / [ 1 - ( 1 / (1+i)n )]

Where i = annual interest rate divided by 12 = 6.5%/12 = 0.54167%

n = term of loans in months = 25 years *12 = 300 months

Annual mortgage constant = 12* 0.54167% / [ 1 - ( 1/ (1.0054167)300)] =12* 0.54167% / [ 1 - ( 1/ 5.56197844)]

= 12* 0.0054167 / [ 1 - 0.197777071] = 0.065 / 0.802222929

Annual mortgage constant = 0.08102486

Financing component = Annual mortgage constant * loan to value ratio

= 0.08102486 * 85%

Financing component = 0.06887113

Calculation of Equity Component :-

Equity component means is the investors required equity yield rate multipled by the equity value rato

Equity to value ratio = 100- loan to value ratio = 100 - 85 =15%

Equity component = 12% * 15% = 0.12 * 0.15 = 0.018

Calculation of cap rate :-

Cap Rate = F+E

Here F = Financing component

E = Equity component

Cap rate = 0.06887113 + 0.018 = 0.08687113

Cap rate = 8.687%

Calculation of the Value of property :-

Value of Property using cap rate = Net operating income / Cap rate

=80,000 / 8.687%

Value of property = $ 920,916.31 = $ 921,000 (approximately)

option A is correct


Related Solutions

You have been asked to provide an estimate for the net operating income (NOI) of the...
You have been asked to provide an estimate for the net operating income (NOI) of the Shared Office Space Building. The building consists of 16 suites evenly distributed in 4 floors (4 suites per floor). Today, the offices in the first-floor lease for $2,100 per month, while the rest of the offices lease for $1,600 per month. The market study reveals that the average vacancy in the market is 8% per year; the expected operating expenses are 41% of the...
You are interested in purchasing an apartment complex for $2,000,000 that has Net Operating Income (NOI)...
You are interested in purchasing an apartment complex for $2,000,000 that has Net Operating Income (NOI) of $120,000 and is financed with an 80% LTV mortgage at 4% 1. What is the Cap Rate? 2. What is the ROA? 3. What is the leverage ratio? 4. Approximate the ROE
what is the difference between a rental property and one that is not a rental property...
what is the difference between a rental property and one that is not a rental property (used for personal purposes)?
Kimberly has a retail clothing store that makes a net operating income (NOI) of $300,000. She...
Kimberly has a retail clothing store that makes a net operating income (NOI) of $300,000. She originally purchased the property for $2,500,000 and places $500 a month into escrow for replacement reserves. She estimates the land value to be $400,000. She received a mortgage for $1,625,000. The payments each month include principal and interest during year 2 of $45,909 and $88,229 and during year 1 of $56,843 and $99,651 respectively. What is the depreciation for year 1 and 2?
Ann wants to buy a building. The annual NOI will be $100,000 She wants a 30...
Ann wants to buy a building. The annual NOI will be $100,000 She wants a 30 year fully amortizing fixed rate mortgage at an annual rate of 5% with compounding monthly payments. The lender has a minimum DSCR of 1.2. If Ann gets a 50% LTV loan for $500,000 what is her DCSR?
1.     What is Schedule E depreciation (Rental property)? 2.     What is Schedule E net income (Rental...
1.     What is Schedule E depreciation (Rental property)? 2.     What is Schedule E net income (Rental income & Sub-S income)? Paul Turner is single and has two children, Allen and Lee Ann, from his previous marriage. Allen lives with Paul and Paul provides more than half of his support. In the current year, Allen earned $300 of interest income and $5,000 working at a fast-food restaurant. Allen graduated from high-school in December 2017 and was not a registered student during...
QUESTION 25 Ann wants to buy a building. The annual NOI for the building will be...
QUESTION 25 Ann wants to buy a building. The annual NOI for the building will be $100,000. She wants to get a 30 year, fully amortizing, fixed rate mortgage at an annual rate of 5% with monthly compounding and monthly payments to buy the building. The lender has a minimum Debt Service Coverage Ratio (DSCR) of 1.20. If Ann gets a 50% LTV loan for $500,000, what is her DSCR? A. 4.00 B. There is not enough information to compute...
Your company's MARR is 9%.. Your boss wants to buy a new piece of rental equipment...
Your company's MARR is 9%.. Your boss wants to buy a new piece of rental equipment - a snow making machine - which she plans to rent to local ski clubs. The estimated cost of the machine is $55,000 and the annual O&M is $6000. She expects to rent the machine at $16,000 per season for 7 seasons, at which time Global Warming will end the ski industry. However the snow machine can be sold as an antique at an...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value Strip shopping center $800,000 $448,000 $136,016 $7,692 $912,000 Small apartment complex $650,000 $292,500 $91,281 $8,273 $685,100 The first potential investment consists of a seven-store shopping center, which has a current market price of $800,000. Of this amount, $200,000 represents the cost of the land, and the balance, $600,000, is attributable to buildings on the property. The second possible investment, which costs $650,000, consists of...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value Strip shopping center $800,000 $448,000 $136,016 $7,692 $912,000 Small apartment complex $650,000 $292,500 $91,281 $8,273 $685,100 The first potential investment consists of a seven-store shopping center, which has a current market price of $800,000. Of this amount, $200,000 represents the cost of the land, and the balance, $600,000, is attributable to buildings on the property. The second possible investment, which costs $650,000, consists of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT