I’m working on a real estate case study and need support to help me learn.

I’m working on a real estate report and need support to help me learn.

Please Complete assignment follow all guideline include completed excel files and Case report .

Instructions:

The key requirement is to convert and modify Exhibit 4 into a spreadsheet based DCF model. The written report should contain, but not limited to, the following sections:

1. Description of Property, Location, Condition, and Usage

Read the case thoroughly to extract relevant information and summarize it in this section. Provide a brief description of the the project, the investor, and task.

2. Market condition

Examine table 1 – 4 for market information and summarize it in this section. Provide a description of the market condition, noticeable trends, and competing projects in terms of rent, vacancy, absorption, etc. These information provides the base for key assumptions in your DCF model.

3. Financial Analysis
This is the main body of your report. Provide a detail discussion on how you build the DCF model. Create additional exhibits to separately show the set-up, the assumptions, the operating cashflow analysis, the amortization schedule, the tax calculation, and NPV, IRR, etc. Then provide discussions about how you made the assumptions and why, how you conduct the calculations in the exhibits.

4. Conclusions and Recommendations

Based on your analysis, provide a brief conclusion of your assessment of this investment opportunity and main reasons as to whether this is an acceptable investment, or under what conditions this will become acceptable.

5. Things Learned

Briefly discuss the interesting things you have learned from working on this case.

Written report should be about 5-10 pages (double spaced). This is an independent assignment. Each student must submit a written report and an excel DCF model.

Please Complete assignment follow all guideline include completed excel files and Case report .