Estimate and report the project estimated value

Assignment Help Other Subject
Reference no: EM131537243 , Length: 5

REAL ESTATE INVESTMENT MIDTERM CASE

You are being asked to determine whether the lender should approve a permanent mortgage loan on the proposed development of an apartment project. Your task is to provide a preliminary analysis of the feasibility of the project (described below), answering the following questions within your report.

(1) What are the strengths and weaknesses of the proposed development, the market, and the project's expected financial performance (e.g., In your view, is there sufficient demand for this project? Does the developer have the needed expertise? Is the location appropriate? Does the project make sense financially from both the developer's and lender's perspectives?)

(2) Construct the expected annual cash flows (pro forma) assuming a 4-year holding period. Assume all development costs take place at the end of year 1; cash flows from operations occur in years 2, 3, and 4; and the property is sold at the end of year 4.

(3) Estimate and report the project's estimated value (PV), NPV, and IRR (both levered and unlevered) using DCF analysis.

(4) Estimate and report the follow key ratios for the project's first year of operations (yr. 2)

a. the implied cap rate, NOI/V, where V is the project's present value estimate from (3) above,

b. the implied cap rate, NOI/V, where V is the cost of developing the project (i.e., the land acquisition and building development costs),

c. the debt coverage ratio, DCR, in yr. 2,

d. the loan-to-value ratio, LTV, in yr. 2,

e. the equity dividend rate, EDR, in yr. 2.

(5) Finally, indicate if the project meets HGA's investment criteria and if you recommend that Commercial Real Estate Capital: (a) approve the application, (b) to reject the application, or (c) should propose a different loan amount?

You should limit your write up to a maximum of five type-written pages. This includes any tables or figures, which if used should be placed within the document, but does not include the title page. You can decide the format you wish to use (e.g., single or double space, font size and font type), but it should be consistent throughout the report.

Assignment Files -

https://www.dropbox.com/s/6z9vhonc2j6biqr/Assignment%20Files.rar?dl=0

Reference no: EM131537243

Questions Cloud

Discuss the accounting software packages : Accounting software packages can quickly print out volumes of journals, reports, and financial statements. The old adage "garbage in, garbage out".
True for the fixed income selections : The same holds true for the fixed income selections. A spreadsheet is provided in Doc Sharing to help you do the required computations.
Importance of the time value of money concepts : Define and discuss the importance of the time value of money concepts, including compounding (future value), discounting (present value), and annuities.
How does motivation influence learning : Literature Review- How does motivation influence learning? How will you use motivation to influence the learning of your students?
Estimate and report the project estimated value : REE 5305: REAL ESTATE INVESTMENT MIDTERM CASE. Estimate and report project's estimated value (PV), NPV, and IRR (both levered and unlevered) using DCF analysis
Discuss about the colonialism or post-colonialism : How does this document reflect the state of the world between 1950 (when it was first written) and 1956 (when the final edition was issued)?
Based on the annual worth method of study : You are an electrical engineer for a company that makes transformers. Based on the annual worth (AW) method of study,
Ethical dilemma-money-back guarantee : In addition to low prices, TradeSmart offers an extremely liberal product return policy. Customers are permitted to return products.
Experiencing rapid growth-stock price : Navel County Choppers Inc. is experiencing rapid growth. If the dividend per share just paid was $1.52, what is the stock price?

Reviews

len1537243

6/20/2017 1:25:34 AM

Attached is the Midterm case, also included are copies of the Tallahassee Statistical Digest which provides economic and demographic info for the Tallahassee area, the PwC Report which provides an overview of real estate market conditions for all real estate sectors, and the IREM report 2011 which provides income and expense information for apartment properties (note that because this report is from 2011 and does not explicitly report information for Tallahassee, it is most helpful in providing a gauge to determine reasonable expenses, stated as a percentage of Potential Gross Income (listed as % of GPI), based on apartments in the Southeast Region (pg. 124 and 125). Due 23 A maximum of five type-written pages.

len1537243

6/20/2017 1:25:28 AM

Your write-up should be presented as a professional report, not simply as type-written responses to a series of questions. Thus, you may find it helpful to organize the report as having the following sections: Introduction, Market Analysis, Property Analysis, Financial Analysis, and Conclusion; or something similar. Also, you may find it helpful to use bullet points—say, in the conclusion to highlight the key strengths/weaknesses of the project, and your recommendation.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd