The goal of the Appraisal Project is to provide students with an opportunity to apply classroom knowledge to real world conditions in an analysis of the Water’s Edge Apartments case study.
The student will calculate the Net Project Cash Flows and then calculate the NPV and IRR based
on these cash flows. Use the Excel file: Appraisal Project Assignment – Case Study – Exhibit
1 For your calculations
In your report, include a written analysis of the Water’s Edge Apartments calculations as well as a discussion of the strengths and weaknesses of the NPV and IRR as valuation measures. Your report will need to be 1,000 words including an APA formatted title page and references page, and at least 5 scholarly references (e.g., peer-reviewed journal articles). You may also use non-scholarly references such as trade publications in addition to your 5 scholarly sources. Include a section in your report on a biblical integration of the topics.
THE WATER’S EDGE APARTMENTS
The Opportunity In early 2008, John Francis and Donald White met to discuss a potential real estate development opportunity. The Water’s Edge property was created through the purchase of eight individual properties to create a single 9.66 acre footprint on the banks of the Mohawk River in Cohoes NY. When complete, the development would contain 132 individual units in two mirrored buildings with a private street separating them. The current developer of the project was experiencing financial difficulties and was seeking a buyer for the partially complete project. John Francis is President of Francis Properties (FP), a real estate development and management firm specializing in multiple occupant facilities in the greater Capital District of New York. FP’s projects include Greystone, a 38-unit senior living property and Windy Pointe, a 51-unit facility.
Donald White is Managing Director of Alliance Venture Partners (AVP) and is a seed-stage investor in early stage technology companies. AVP also invests in commercial and residential real estate projects in metropolitan Boston and in the Capital Region of upstate New York. Friends since childhood, John and Donald agreed to evaluate the acquisition of Water’s Edge property as a joint venture between FP and AVP. Their first concern is to evaluate the potential value of the opportunity.
The Senior Housing Movement
America is a quickly graying country, with nearly 8,000 Americans turning 60 each day according to the US Census Bureau. The fastest growing segment of the US population is those over 85, with those of traditional retirement age (65) being the second fastest growth segment. Immediately behind them come the Baby Boomers, a two-decade spanning group of over 70 million individuals with more wealth and inclination to spend it than any other time in US history. The Albany region has a shortage of attractive senior living alternatives. Currently, senior living facilities in the area represent a total of less than 500 units. Potential customers prefer to
Page 2 of 4
Relocate nearby their homes in order to retain connections to their local communities.
Unfortunately, there are a limited number of appropriate undeveloped spaces in proximity to the population centers. Only one other major project has been announced locally, a $14M project of roughly 100 units to be started in early 2009 in nearby Saratoga Springs.
Acquisition Cash Flows
The partnership would to acquire the property for $9.5 million, 70% of which would be financed through an interest-only bank loan. Once acquired, the group anticipates investing an additional $5.5 million (equity) in year 0 to complete construction. The partnership intends to sell the property after twenty years.
Anticipated Project Cash Inflows
The cash inflows for the project are dominated by the monthly rents. The maximum monthly rents for Water’s Edge would be $980 per unit per month by the end of Fiscal Year 2008.
Assume no discounts for rent in Year 1 (2009, $1,500 per unit) and beyond, with rents increasing at 5% per annually. Completion schedule 31-Aug-08 31-Aug-09 31-Aug-10
Building 1 units 30 66 66
Building 2 units 33 66
Secondary cash flow comes from an arrangement with Time Warner Cable to purchase internet, cable TV, and digital phone services at a discount and resell these services to the residents for a profit. The current cost is $52 per month per unit. The services are resold at $100. The partners expect that 75% of the residents will purchase this service and that these costs and revenues will increase at 5% per year.
Based on his previous experience, Francis estimates that Water’s Edge will require one full time employee acting as property manager. In the Capital District an appropriate individual for the demographics of Water’s Edge (45-55 year old, college educated, good communication skills) would be about $4,500 per month for salary, with employee benefits and taxes adding $1,500 for a total of $6,000 per month. This number will increase at 5% annually for the term of holding of the property.
Initially, Water’s Edge will require little maintenance ($50,000, year 0). Annual maintenance will increase in year 1 (2009) to $65,000. This value will increase $32,000 per year until the end of the holding period.
Due to the design of Water’s Edge, insurance costs are not as much of a burden as to be expected with a facility this size. The previous developer installed hydrants outside the buildings and sprinklers on every floor. There are Fire Control Panels and full monitoring, and relatively close proximity to both fire and police. The current policy on Water’s Edge pre-completion is $45,000
Page 3 of 4
Per year, based on a $9 million value. Using a full value of $15 million, the estimated insurance cost is $75,000 for the year. Insurance costs are expected to increase at a 5% annual rate. Depreciation Calculations Normally a building is straight line depreciated over its usable life of 30 years. While the simplest manner, it is not nearly the most tax efficient as components other than the building itself (carpets, light fixtures, etc) can be depreciated in as little as five years. Based on preliminary estimates, Water’s Edge enjoys $750,000 a year of accelerated depreciation each year for the first ten years of the project’s life. After that time, normal depreciation of the structures and other long-lived components gives $300,000 for the remaining years of ownership.
Expected annual depreciation expenses are shown in Table 1.
Table 1: Annual Depreciation Expenses
Years of ownership Annual Depreciation
Taxes for Water’s Edge are on a per unit basis. As Water’s Edge is not 100% completed at this point, it does not carry the full tax burden, and the Pilot Tax Program is not yet in effect. This tax incentive plan will go into effect upon assessment following completion and will last for ten years from that point.
The tax rate for the next two years is projected to be $8,333 per month until September 2009, when full assessment will be in effect. This number shall be used for Year 1 calculations. 75% of this ($6,248) shall be used in Year 0. Full assessment shall be used thereafter.
At full assessment, the tax rate is $1,100 per unit per year, for a full value of $145,200 per year. Due to the fiscal constraints of the current economy, 5% per annum tax rate growth will be utilized annually from full assessment.
The Pilot Tax Program (PTP) is built into the deed of Water’s Edge. The PTP is a tax credit for 50% of the property tax bill in the first year of full assessment, decreasing at 5% per year until it has been eliminated in year 11. Tax calculations for the purpose of this analysis will take into account the PTP.
Due to the tax schedule, September 1st shall be used as the start of the fiscal year for all calculations and projections for Water’s Edge. Annual tax estimates are shown in Exhibit 2.
Given the current credit markets, it is assumed that only 70% of the purchase value of Water’s Edge can be leveraged via mortgage. An 8% assumption is used for interest only with a balloon beyond the holding time horizon.
As the partners sat down to evaluate the project, White raised some of his concerns. “In order to determine the value of this opportunity, we’ll need to clearly understand all the cash inflows and outflows. Is this project really worth the $15 million price tag? Our overall cost of capital on this project is 14%. Will the investment create value? I am sure that our lender will want to see our estimates.” Francis replied, “I agree that we need to value the project for the full twenty years, but I am concerned about the expiration of the Pilot Tax Program incentives. Should we consider selling after ten years instead? I am also concerned about keeping the apartments filled throughout the project. Let’s plan on ninety percent occupancy in our calculations. We can use this format (Exhibit 1) as our guide.”
Francis replied, “I agree that we need to value the project for the full twenty years, but I am concerned about the expiration of the Pilot Tax Program incentives. Should we consider selling after ten years instead? I am also concerned about keeping the apartments filled throughout the project. Let’s plan on ninety percent occupancy in our calculations.
Why Choose Us
Top Quality and Well-Researched Papers
We ensure that all your instructions are followed to the letter. You are able to choose the level of interest; professional, college, or high school. We will assign a writer who will cover all your specifications.
Professional and Experienced Academic Writers
We have a team of well trained and experiences assignment writers who are PhD and master’s holders. Our writers are can handle more than 91 disciplines.
Free Unlimited Revisions
If your assignment is not covered to your expectation, you can send your order for revision. The order should be submitted before 10 days elapses for review You can contact our support team or login to your personal account to submit your request.
We ensure on-time delivery of your papers. For clarification purpose, we may contact you regarding deadline extension. In case you cannot provide us with more time, we guarantee a 100% refund.
Originality & Confidentiality
We use professional tools to ensure all assignment help documents you receive are free of plagiarism. Our editors ensure optimum review of all quotations in the text. We also ensure confidentiality in our service delivery.
24/7 Customer Support
Our team of experts is available 24/7 to ensure that you are provided with the top customer experience. Any time you need assignment help, you can reach us and get the best experience with ours services.
You don’t have to struggle with your papers. You need ample sleep; our writers will cover you. We provide writing services in all disciplines.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission and Business Papers
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Editing and Proofreading
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.