Assume that you have recently inherited $500,000 that you would like to invest in an income producing commercial real estate investment. Assume that local commercial real estate lenders are typically loaning up to 75% debt of an income producing property’s valuation. That means your equity investment would represent 25% of the valuation. What would be the maximum amount that you could pay for your investment property?
Assume that you have recently inherited $500,000 that you would like to invest in an income producing commercial real estate investment. Assume that local commercial real estate lenders are typically loaning up to 75% debt of an income producing property’s valuation. That means your equity investment would represent 25% of the valuation. What would be the maximum amount that you could pay for your investment property?
How much would that mean you could borrow in this scenario?
Assume that you find a small 10-unit apartment complex containing only 1-bedroom efficiency units that are leasing at $2,000/month in rent for a total annual potential gross income (PGI) of $24,000/year per unit or $240,000 overall. Assume that over a typical year, there is a 10% vacancy and collection loss (VCL) for this complex. Assume that it generates $3,000/year in other income (OI) from vending machines, laundry machines, etc. Calculate the annual effective gross income (EGI) for this property. Assume that annual total operating expenses (TOE) for this property are 35% of effective gross income (EGI). Calculate the annual net operating income (NOI) for this property.
PGI
-VCL
+OI
=EGI
-TOE
=NOI
Assume that the standard “going-in” capitalization rate (cap rate) for this type of property is 7%, what is the implied value of this property.
Using the amount to be borrowed from Question # 1, calculate the monthly payment for the loan assuming a 25-year term with a 5-year balloon and a 7% interest rate.
How much would you still owe on the loan in Question # 5 when the balloon payment becomes due at the end of 5-years (60 months)?
Calculate the IRR (Internal Rate of Return) percentage for this investment using the equity investment of $500,000 from Question # 1 as the initial cash flow and the annual BTCF (Before Tax Cash Flow) for each of the five years of the loan, and the amount above and beyond the outstanding mortgage payment as the terminal (reversion) value at the end of year 5 by using IRV (Income/Rate=Value) to compute the sales price using the year 6 NOI assuming a 5% “terminal cap rate.”
Calculate the NPV (Net Present Value) dollar amount for this investment assuming an 8% required rate of return for yourself.
Recalculate the IRR (Internal Rate of Return) percentage for this investment assuming that you had all of the funds necessary to initially pay cash for this investment without the need for any loan financing. (Hint: Use the initial maximum purchase price of $2,000,000 for initial cash outlay, the annual NOI for 5 years as the cash flows, and entire sales price added to year 5 cash flow, but derived by using a “terminal cap rate” of 5% applied to year 6 NOI.)
Recalculate the NPV (Net Present Value) dollar amount for this investment assuming an all-cash deal (no loan) as in Question # 9 and an 8% required rate of return for yourself.
Requirements: step by step process using the hp10b11+ Calculator
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
