Millegan Creek Apartments

Millegan Creek Apartments- Financial Analysis Essay The Millegan Creek Apartment case is an example of a commercial loan. The parties involved in the commercial loan are JP Multifamily Inc. and Fleet Bank. Real Estate group at Fleet Bank want to find out whether or not to accept JPI’s proposed $15,715,000 loan for a 390-unit apartment project in Austin, Texas. The details about the each party, market and financial analysis of the project is outlined below. THE BORROWER -JP MULTIFAMILY INC. The Development Expertise JPI Multifamily Inc. (JPI) was founded in 1989 by John Carpenter and Frank Miller, who had worked together at Southland Financial. JPI, a first class developer, was known as a â€Å"merchant builder† meaning that they developed properties with the intention of selling rather than owning them. JPI had begun seriously investigate in Austin market in 1991. They purchased their first site in early 1992, which was a â€Å"trophy property†, 210-unit project, located in the Southwest part of Austin. The second property JPI purchased in Austin was located in the North Central Area which was a 342-unit project. And, finally the third apartment development in the Austin for JPI would be a 390 unit the Millegan Creek Apartments project. The investment Strategy JPI tried to achieve at least a 150 basis point spread between the initial yield and the current market capitalization rates. JPI was seeking development opportunities which provide a going-in cap rate (or cash on cash return) of at least 10% on the total project cost. They had developed approximately 2800 apartment units and 1,640 apartments. This record was in line their investment strategy of targeting a â€Å"holding period for development projects of two to three years. In 1994, they had eight properties with 2,700 units under construction, four of which were under agreement to be sold upon completion. THE LENDER-FLEET BANK Fleet Bank is being considered as a lender of the project. The Austin Market is a new market for Fleet Bank. Fleet wants to diversify its loan portfolio out of Northeast. Tom Hayden’s (a vice president in Commercial Real Estate at Fleet Bank) assignment was to seek financial opportunities in real estate in the State of Texas. Based on Tom’s research, JPI was an active developer who had survived the Texas real estate crash built a large number of apartments. SALIENT FACTS of MILLEGAN CREEK APARTMENTS PROJECT The Description of the Product: Jefferson at Millegan Creek Apartment would be a typical JPI luxury apartment complex. The apartment would target renters with high discretionary incomes who could probably afford a single-family home, but made a lifestyle choice to live in rental apartments. Site amenities included two swimming pools, a clubhouse, fitness center with sauna and steam rooms, and the laundry facilities. Standard features in each apartment included nine-foot ceilings, a security system, crown molding and upgrade white on white appliances. Location: The Millegan Creek site was located in Williamson County, adjacent to the city of limits of Austin and approximately 11 miles northwest of the central business district. The site was an irregular, rectangular shape consisting of about 21. 5 acres, with 904 feet of frontage along McNeil Road. Near Highways: Parmer Lane had recently been expanded from a two lane to a six-lane road and provided excellent north-south access. McNeil Road brought about 15,000 cars in an east west direction past the site each day and had recently been upgraded from a two lane to a five-lane road. In addition, McNeil Road was being extended three miles to connect to Wells Branch Parkway. Construction financing:The loan was being reviewed by Fleet Bank because the volume of deals JPI doing, their existing lenders (NationsBank, Guaranty Federal Savings Bank (in Dallas), BankOne, General Electric Credit Corporation had reached the limit of the exposure they wanted with any borrower. Construction problem:The site was level with no significant subsurface rocks, which would not create construction problem. Property Taxes :The site was outside the City of Austin which can provide lower property taxes and easy zoning approval. Total Project Cost: $19,644,000 Loan Amount: $15,715,000 Land Cost: $1,425,000 The holding period: Target holding period is two to three years MARKET ANALYSIS Regional Economic Drivers Austin housing market holds a comparative advantage and this advantage exists because; -it’s ranked sixth in the nation as a preferred location for a new manufacturing facility, Austin economy had always been universities and government as the state capital. Austin had a government workforce of over 110,000 including state, country and city employees and plus recently added 3,000 government sector jobs, -The location of project was close to many of Austin’s high tech companies. Texas Instruments had a big campus located across the street. Others in the area included: Abbott Laboratories, Tandem Computers, 3M, and State Farm Insurance. Apple Computers had also announced plans to build a new, $28 million, 300,000square foot facility to house its U. S. Customer support Service The other strength of Austin is that the city is filled with good universities. Companies were attractive to Austin economy by the presence of university –based research and its very desirable climate. Market demand Austin had experienced significant population growth and local economists expected these trends to continue. The average family size would continue to be about 2. 43 people per household. Job Growth Since the strength of the apartment market heavily dependent upon continued growth in the local market, local job market figures as follows; -As of September 1993, Austin’s employment totaled 425,800 and its unemployment rate was at 4. %. Austin added almost 30,000 jobs in the 1992-1993 periods. -The Texas Comptroller of Public Accounts projected job growth for the next two years to continue in the 3% to 3. 2% range. INVESTMENT DECISION I recommend Fleet Bank to approve the loan based on the market analysis outlined above and the attached financial analysis. The highlights of ratios listed in Exhibit 1 as follows; Cash on cash return 13. 70% , IRRe 5YR Hold 26. 48%, IRRo 5 YR Hold 16. 62% and Cap Rate (in) 10. 67%. In the loan calculations the interest rates is taken as 8%. Considering that nstitutional buyers in the region were paying cap rates in the 8% to 9% for the new apartments, JPI can achieve its investment strategy of obtaining at least 150 basis point for its investments. The debt service coverage ratio (DSCR) in commercial real estate finance refers to the primary measure to determine if a property will be able to sustain its debt based on cash flow. Typically most commercial banks require the ratio of 1. 15-1. 35 times (net operating income or NOI/annual debt service) to ensure cash flow sufficient to cover loan payments is on an ongoing basis. Building and planning a new club house EssayThe net investment in the property is the cost of the property minus the amount borrowed. One way to understand the ratio is to compare it to a return on a certificate of deposit. If the bank pays you an annual return of, say 5%, the 5% is the Cash on Cash return on the deposit. However, unless the property is owned free and clear, this is not a totally true comparison. The return you get is AFTER the mortgage and all other expenses have been paid. It can therefore fluctuate wildly. Whereas, if you put $200,000 in the bank in a CD you can be certain that you will get the return you expected. Please note that the Cash on Cash return does not include property appreciation which is a non-cash flow item until the year of sale. Therefore, if you are evaluating a property on a long-term basis, you need to focus more on the annual cash flow as it relates to your investment and focus less on property appreciation. CAPITALIZATION RATE (CAP RATE) The Cap Rate is a ratio that places a value on a property based on the net operating income (NOI) it generates which allows for a comparison of properties with different Fair Market Values (FMV). The Cap Rate is computed by taking the rental NOI and dividing it by the propertys FMV. The higher the Cap Rate, the better the property is said to be performing. Note that the Cap Rate is not a computation of an investment return but rather a way of understanding how a property will generate NOI so it can be compared to other properties. Cap Rate Practical Use #1 You can use the Cap Rate to value your property. Lets say that your property generates $30,000 of annual net operating income. Your real estate agent tells you that the Capitalization Rate in your area is approximately 10%. That would mean that the approximate fair market value of your property is $300,000 ($30,000 ? .10). Cap Rate Practical Use #2 Assume that you are comparing two properties. The first property has a projected NOI of $20,000 and an asking price of $500,000. The second property has a NOI of only $10,000 with an asking price of $110,000. Which one would the Cap Rate suggest is a better investment? The Cap Rate would suggest that the second property is a better investment since the Cap Rate is 9% ($10,000 ? $110,000) versus 4% ($20,000 ? $500,000). LOAN TO VALUE RATIO (LTV or LVR) The Loan-to-Value Ratio is the amount of a secured loan or mortgage divided by the fair market value of the property. For example, if your property is worth $100,000 and you have a mortgage balance of $50,000, the Loan-to-Value ratio on your home would be 50%. The LVR helps you quickly determine how leveraged your property is based on the fair market value of the property versus your cost. You can also use the LVR to determine the amount of your equity. If you have more than one loan secured against your property, add together the outstanding value of each loan in order to calculate the Loan-to-Value ratio. For example, if your home is worth $100,000 and you have a mortgage balance of $50,000, the Loan-to-Value ratio on your home would be 50%. However, if you also have a second secured loan on your home for $25,000, the Loan-to-Value ratio on your home would be 75% ((50,000 + 25,000) divided by 100,000). GROSS RENT MULTIPLIER (GRM) The Gross Rent Multiplier (GRM) is another way to value and compare properties. Used mostly in the apartment industry, the GRM is much like the Capitalization Rate except the gross rental income rather than the net operating income (NOI) is used to determine the value of a property. The GRM is calculated by dividing the fair market value of the property by the monthly gross rental income. EXAMPLE: If the sales price for a property is $200,000 and the monthly gross rental income for a property is $2,500, the GRM is equal to 80 ($200,000 ? $2,500). INTERNAL RATE OF RETURN (IRR) When an investment creates differing amounts of annual cash flow, a rate of return can be determined by calculating the Internal Rate of Return (IRR). The formula for computing the IRR is very complicated but essentially an IRR is the rate needed to convert (or discount) the future uneven cash flow to equal your initial investment or down payment. EXAMPLE: Assume a cash flow of $100 in the second year. Also, assume that in order to generate that $100, you had to invest $500. In this example, you have an outflow of $500 the first year and an inflow of $600 in the second year ($100 earnings plus the $500 return of your initial investment). To convert or discount the $600 back to todays dollars to equal your initial investment of $500, a discount rate of 20% is required. Thus, your IRR is 20%. In other words, IRR is the discount rate at which the net present value of all future cash flow is zero (discounted future cash flows = starting investment amount). The net meaning you subtract your initial investment. Leveraged vs. Unleveraged IRR When you use debt to purchase a property, you are using leverage. The program computes your IRR based on how debt impacts your cash flow. As a result, you can compare the leveraged and unleveraged IRR to determine how debt is helping or hurting your investment results. MODIFIED INTERNAL RATE OF RETURN (MIRR) The Modified Internal Rate of Return (MIRR) is used to correct a significant inherent problem with the IRR calculation. The IRR formula   assumes that you are reinvesting the annual cash flow at the same rate as calculated by the IRR. As a result, when you have a property that generates significant cash flow, the calculated IRR will overstate the likely financial return of the property. The MIRR allows you to enter a different rate that is applied to the propertys annual cash flow. Using the MIRR will more closely mimic the real rate of return since operating cash flow is rarely invested at a higher rate than a bank savings rate. The finance rate is the annual interest rate paid to borrow money during years the property experiences a negative cash flow. The reinvestment rate is the rate of return earned on the excess cash flow that is generated by the property.