Create a spreadsheet to calculate the net present value

Assignment Help Accounting Basics

Reference no: EM131307465

Learning outcomes

Code Description

A1 in-depth and systematic understanding of key investment concepts to facilitate strategic real estate investment decision-making
A4 critical awareness and understanding of the evolving investment environment and emerging investment concepts.
B1 evaluate and make logical and reasoned investment judgements in the
absence of complete data.
B2 research, collect and synthesize complex investment information.
C1 systematically evaluate complex issues and information to aid investment
decision-making.
D1 act autonomously in real estate investment decision making

Scenario

You are an investment surveyor working in-house for a private high net worth individual.

As part of your remit, you are responsible for the management of a mixed portfolio of investments, which is currently valued at approximately £50m. The portfolio holds £5m worth of shares in the UK- REIT Redefine International PLC, which is listed on both the London Stock Exchange (LSE: see Ticker RDI) and Jersey Stock Exchange (JSE see Ticker RPL).

Your employer is a long-term investor and generally risk-averse with regards to its real estate investments.

Funds of £10m will shortly become available within the portfolio to invest directly/indirectly into real estate.

Your employer has asked you to assess the following two investment opportunities:

Investment Option 1:

Springfield House, Station Approach Business Park

- A modern two-storey office building.
- Located in a suburban office park.
- Floor area: approx. 1,858 sq m (20,000 sq ft) (measured in accordance with IPMS Office 3).
- 40 car parking spaces.
- The tenancy schedule is attached in Appendix 1.
- Annual rent: £400,000 p.a. exclusive of service charge, rates, insurance, etc.
- Asking price: £4.35m.

Assumptions for Investment Option 1:

- For the purposes of your calculations, the appraisal date is 1 January 2017.
- Reliable information on the local office market has shown that there has been an annual rental growth rate of 5% p.a. over the last three years. This trend is set to continue for the foreseeable future.
- There is no rental growth evident in rents for suburban car spaces.
- Client's target rate of return is 9%.
- The holding period for this investment is 10 years, after which the investment will be sold.

- The disposal value will be assessed on the basis of the expected rental value at the date of the disposal and subject to a capitalisation rate, which would reflect the age and obsolescence of the building.
- Rents are collected annually in arrears. Rent reviews occur at the end of the specified periods and affect rental levels thereafter.
- Both leases in the investment are on a full repairing and insuring (FRI) basis.
- You should assume a vacancy period of one year when the first floor of Springfield House becomes vacant. The annual service charge, rates and insurance liabilities for the first floor are
£35,000.
- Choose a real estate market which you are familiar with and assume that this investment is located within this market.
- Acquisition fees will be at 5.8%.
- Disposal fees will be at 2.4%.
- Letting fees will be at 10% of the rent achieved.
- Rent review fees will be at 7.5% of the revised rent.
- The exit yield can be set at the net initial yield.

Investment Option 2:

A block of shares worth £5m in Green REIT plc which is listed on both the London Stock Exchange (LSE: see Ticker GRN) and Irish Stock Exchange (ISE: see Ticker GN1).

Task
Prepare a client style professional report with recommendations/conclusions to present to your employer on the possible purchase of Springfield House and the shares in Green REIT plc. Analyse both investment opportunities before concluding whether or not to purchase one or both.

In your analysis of Springfield House, create a spreadsheet to calculate the net present value (NPV) and internal rate of return (IRR) using Microsoft Excel (or an equivalent). Your analysis of this property investment should incorporate quantitative measures to assess the potential risks associated with each investment.

In your analysis of Green REIT plc, you should include a risk appraisal of the property portfolio in Green REIT under the following headings:

1. Asset concentration
2. Location concentration
3. Company concentration
4. Segment volatility exposure
5. Income return
6. Development exposure
7. Vacancy rate
8. Unexpired lease term
9. Risky covenants

In your REIT analysis, you should also make comparisons between the property portfolios of Green REIT plc and Redefine International PLC.

Reference no: EM131307465

Questions Cloud

Describe importance of the reversal phase in the abab design : Describe how changes in level and trend can each be used to evaluate data in a single-subject design.- Describe the importance of the reversal phase in the ABAB design.

Has the sender calculated a checksum for this packet : A client uses UDP to send data to a server. The data length is 16 bytes. Calculate the efficiency of this transmission at the UDP level (ratio of useful bytes to total bytes).

Should these students retroactively be given credit : Later scientific investigation has shown that the rings are, in fact, composed of solid matter. Did the truth change? Should these students retroactively be given credit? Which group of students originally knew the correct answer?

Evaluate the treatment of one behavior in two participants : Describe how the multiple-baseline design can be used to evaluate the treatment of one behavior in two participants.

Create a spreadsheet to calculate the net present value : Prepare a client style professional report with recommendations/conclusions to present to your employer on the possible purchase of Springfield House and the shares in Green REIT plc.

Prepare a presentation on training on diversity trends : Prepare a presentation on Training on Diversity Trends. Include detailed speaker notes with your presentation that fully explain each point and justification for your recommendations.

Draw a graph for an abab research design : Draw a graph for an ABAB research design showing the data that would be obtained from a treatment with a permanent or long-lasting effect.

What is the minimum size of a udp user datagram : In SCTP, the value of the cumulative TSN in a SACK is 23. The value of the previous cumulative TSN in the SACK was 29. What is the problem?

Write each term on a separate index card or paper : Explain that you are trying to learn something about the culture of this person. You will be interviewing the person about some topic that is familiar to him or her, so you can learn about this topic.Find out something that this person knows some..

Reviews

len1307465

12/10/2016 5:50:01 AM

1. STRUCTURE, PRESENTATION and GRAMMAR The assessed work must be clearly structured and presented and where appropriate make best use of the identified word count. The assessed work must be in a style and format appropriate to the audience and/or industry protocols. The assessed work will present a logical and well-sequenced response to the question which balances main and subsidiaryarguments to lead the reader to a referenced and justified conclusion. Content of the assessed work will be clearly referenced to reading from a range of scholarlyand professional sources. Balanced and appropriate use of citations. Structure is logical and sections are clearly linked. Presentation enhances content. Word count adhered to and well used. Style and format explicitly appropriate for audience and/or industryprotocol. The line of argument is explicit and easy to follow culminating in a well justified and referenced conclusion. Reference to reading fits seamlesslywith arguments made and points justified with the most appropriate reference. Well-chosen citations placed confidentlyin the assessed work to support argument.

Write a Review

Required(*) Message

User Account

All Pages