Question

In: Finance

Property Assumptions: Purchase Price:                                    &n

Property Assumptions:

Purchase Price:                                                  $4,000000

Year 1 PGI:                                                      $600,000

PGI Growth Rate (Annual):                                3%

Annual Vacancy and Collection Loss (VCL):      5%

Operating Expenses (OER):                               35%

Terminal Capitalization Rate for Sales Price        .09                        Capitalize NOI (Year 4)

Anticipated Holding Period:                               3 Years

Maximum LTV:                                                70%

Interest Rate:                                                     5%

Amortization Period:                                           30 Years

Payments Per Year:                                                  12

Discount (Hurdle) Rate (Unleveraged & levered):       15%

  1. What is the Unleveraged IRR and NPV?
  2. What is the leveraged IRR and NPV?
  3. What is the DCR for Years 1-3?
  4. What is the NOI for Years 1-4?
  5. What is the “Going In” (aka overall) Capitalization Rate?
  6. What is the Cash on Cash (BTCF) for Years 1-3?
  7. What is the Mortgage Constant?
  8. Based on the NPV’s and IRR’s (unleveraged and leveraged, hurdle rates), do you recommend purchasing this property? Please explain.

Solutions

Expert Solution

You have asked a question with multiple sub parts. I have addressed the first four of them. Please post the balance sub parts separately.

Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.

All the vaues below have been calculated in the table above. pleae locate them.

What is the Unleveraged IRR and NPV?

Unleveraged IRR = -12.46%

Unleveraged NPV = - 2,036,833

What is the leveraged IRR and NPV?

Leveraged IRR = -13.62%

Leveraged NPV = -  563,700

What is the DCR for Years 1-3?

Year 1 2 3
NOI         360,000             370,800                  381,924
Mortgage payment (12 x monthly payment)         180,372             180,372                  180,372
DCR (NOI / mortgage payment) 2.00 2.06 2.12

What is the NOI for Years 1-4?

NOI has been calculated in the table above for year 1 to 3. NOI for year 4 = NOI for year 3 x (1 + 3%)

Year, n 1 2 3 4
NOI     360,000     370,800        381,924 393,382

Related Solutions

Property Assumptions Purchase Price:                                    &nb
Property Assumptions Purchase Price:                                                                        $12,500,000 Year 1 Potential Rental Income (PRI):                                    $1,650,000 PGI annual growth rate:                                                          3% Annual Vacancy and Credit Loss (VCL):                               5%             Over next 6yrs. Year 1 operating expenses (OER): (Oper. Expense Ratio)     35% OPEX annual growth rate (after year 1):                                 2% Sales Price :     Terminal Cap Rate                                           .09 Capitalize 6th yr. NOI Sales Costs: Commissions                                                      3% of Sales Price Anticipated holding period                                                      5 years Maximum loan-to-value (LTV) ratio:                                      75% Interest Rate:                                                                           5.25% Amortization Period:                                                               20 years...
Your client has been offered the opportunity to purchase a property investment.  Given the following assumptions: Holding...
Your client has been offered the opportunity to purchase a property investment.  Given the following assumptions: Holding period 5 years Cost $50,000,000 Rental income $4,000,000(receivable annually in arrears and linked to inflation) Inflation forecast 3% Exit yield forecast 6% Target rate of return 10% Transaction costs 3% i. Advise your client of the Net Present Value of the investment opportunity. ii. Annotate your calculations with an appropriate commentary.
You are considering the purchase of a distressed property. The price is $115,000, and you believe...
You are considering the purchase of a distressed property. The price is $115,000, and you believe that you can complete the required repairs and renovation and re-sell the property in twelve months. You can finance the purchase with a $97,750, 6.5% interest-only loan. The costs associated with acquiring the property include legal fees of $950, an inspection fee of $600, $5,500 to pay off an existing lien, and loan closing costs of $3,500. A thorough and careful assessment of the...
Sales price: $500,000 Property taxes attributable to period before purchase: 8,000 Property taxes attributable to period...
Sales price: $500,000 Property taxes attributable to period before purchase: 8,000 Property taxes attributable to period between purchase and year-end: 2,500 Title insurance: 500 Total amount spent: $511,000 What is the total cost of the property for tax purposes?
3. A personal property asset has a purchase price of $50,000 and an installation cost of...
3. A personal property asset has a purchase price of $50,000 and an installation cost of $10,000. Book depreciation method is the sum-of-years-digits method with a 6-year depreciable life and a $3,000 salvage value. Which one of the following values is correct (rounded to the nearest integer)? (a) D3 = $11,429 (b) B4 = $8,571 (c) B5 = $5,429 (d) D6 = $2,714 4. On January 1st 2009, a company purchased a machine for $14,000, which is a 7-year MACRS...
The purchase price of Property and Building was of 50 million (100 single rooms and restaurants...
The purchase price of Property and Building was of 50 million (100 single rooms and restaurants with a total of 200 seats) purchased 10 years ago. Each year, 250,000 have been recorded as depreciation cost. • The present value of Capital Stock is 14 millions, Retained Earnings 3.5 millions, Mortgage 30 millions, Other long term loan 3 millions, Working Capital 3 millions. • We plan a refurbishment plan over the next 3 years of 2 million a year; the planned...
(Please show all work)      1.The following assumptions are made: The purchase price is $1,100,000. Potential...
(Please show all work)      1.The following assumptions are made: The purchase price is $1,100,000. Potential gross income (PGI) for the first year of operations is projected to be $171,000. PGI is expected to increase at 4 percent peryear. No vacancies areexpected. Operating expenses are estimated at 35 % of effective gross income. Ignore capital expenditures. The market value of the investment is expected to increase 4 percent peryear. Selling expenses will be 4 percent. The holding period is 4...
The purchase price of a property, land and improvement, was $1,625,000. you put 20% down payment...
The purchase price of a property, land and improvement, was $1,625,000. you put 20% down payment and the rest was financed. the mortgage is a 30 year loan at 6.5% principal-interest payment. taxes and insurance at the time of purchase are $18,000 each year. the vacancy rate is 8%, while the repair expenses averaged is $8,500 every year. you spend annually about $2,000 for miscellaneous and advertising costs. you manage the property yourself. determine the monthly cash flow from 30...
The specifics of the opportunity are as follows: Assume 100% occupancy Property purchase price $2,250,000. Loan...
The specifics of the opportunity are as follows: Assume 100% occupancy Property purchase price $2,250,000. Loan to Value Ratio (LTV) 80% Loan Terms: fully amortized over 30 years at 4.25% APR (nominal rate) paid monthly The property offers six recently updated “luxury” apartments. Each apartment has 3 bedrooms and 2.5 baths in 1,800 square feet of living space. Rents are $1,690 per month per apartment. All six units are leased but one of the units only receives half rent because...
The specifics of the opportunity are as follows: Assume 100% occupancy Property purchase price $2,250,000. Loan...
The specifics of the opportunity are as follows: Assume 100% occupancy Property purchase price $2,250,000. Loan to Value Ratio (LTV) 80% Loan Terms: fully amortized over 30 years at 4.25% APR paid monthly The property offers six recently updated “luxury” apartments. Each apartment has 3 bedrooms and 2.5 baths in 1,800 square feet of living space. Rents are $1,690 per month per apartment. All six units are leased but one of the units only receives half rent because the tenants...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT