Complete the excel based component profit loss

Assignment Help Portfolio Management

Reference no: EM131490610

INTRODUCTION -

You have been provided with data on the expected performance of a listed property company.

This performance information includes data on individual property assets and on the corporation as a single investment entity.

Each Portfolio has 12 assets, Read Year 0 as being 2017 and your analysis is to be based on a 10 year forecast period, i.e. results to Year 10.

The only additional financial data that you will need to account for that is not included in the spread sheet is:

In the fourth year of the projections, you must spend CAPITAL on a new Air-conditioning plant, AT THE START OF THE PERIOD.

This capital expenditure applies to asset FOUR only. You upgrade the air con for asset four in year 4.

This plant is to be debt funded and paid for in full at the start of the year. The cost of the air-conditioning plant is 10% of the value of this asset at that time.

This assignment is to test your ability to work accurately and to comply with instructions. There are significant penalties if you ignore instructions. The intent is also that you should be able to apply theory learnt to property investments and their analysis.

Office	Asset Number	Ranges
Prime buildings	400	429
A grade	500	529
B and C Grade	600	629

Retail
Super and Major Regional	1200	1229
Sub Regional	1300	1329
Neighbourhood	1500	1529

Industrial
Warehouse	800	829
Hi Tech	830	859
Distribution	860	889

REQUIRED -

Complete the excel based component of the assignment.

You are required to use the data provided on the portfolio and complete the spread sheets in their existing format.

You must provide the material in the correct cells as marked and shown in the file.

The spread sheets you have connect to a separate automatic correction Spread sheet.

You will need to exercise extreme care to ensure you place the correct figure in the correct cell.

DO NOT TYPE in your figures, rounding errors will result in inaccuracies in your calculations, Link your outputs to the raw data calculations.

Attachment:- Assignment File.rar

Reference no: EM131490610

Questions Cloud

Absolute pressure inside each balloon : The absolute pressure inside each balloon should be 1.2 atm.

How much memory has the program used : ow much memory has the program used when reaching the point where it cannot proceed anymore? What is the physical address space size

How much money would he have in either option : You will need a calculator for this problem. Sam earns $4,000, and he wants to save it for retirement, which is 10 yeas away.

Calculate the voltage across the capacitor : Calculate the voltage across the capacitor after 1.5 seconds.

Complete the excel based component profit loss : You have been provided with data on the expected performance of a listed property company. Complete the excel based component of the assignment

Charging capacitor and a discharging capacitor : Draw two current versus time curves for (a) a charging capacitor and (b) a discharging capacitor.

What is the real after-tax rate of interest : Suppose that a typical taxpayer has a marginal personal income tax rate of 35 percent The nominal interest rate is 13 percent and the expected inflation rate.

Find the rotational inertia of the thin rod : Find the rotational inertia of the thin rod about the pivot point P.

What effect do you think these changes will have on behavior : Austins marginal tax rate is 35 percent, and he itemizes his tax deductions. How much is a $500 deducdon worth to him? How much is a $500 tax credit worth.

Reviews

len1490610

5/10/2017 3:19:15 AM

I’m currently working on assignment for Uni and I need some assistance. Are you able to assist with the theory for the assignment? If so what is the process I need to follow. I’m from Australia. You are required to use the data provided on the portfolio and complete the spread sheets in their existing format. You will need to exercise extreme care to ensure you place the correct figure in the correct cell. DO NOT TYPE in your figures, rounding errors will result in inaccuracies in your calculations, Link your outputs to the raw data calculations.

len1490610

5/10/2017 3:19:09 AM

Unless advised otherwise, students are to assume that late submissions will not be accepted for assessment and a "nil" mark will result. In some courses a late submission may be accepted with penalties applied as determined by the course lecturer, but this will be the exception rather than the rule. Applications for the extension of a due date for assignment and/or project work may be considered, and must be made to the relevant lecturer in writing prior to the occurrence of the due date. The reasons for such application must be given, and any supporting documentary evidence must be included. Notification of any extension granted will be in writing. Submission dates contained in a course guide may be altered by a course lecturer with the agreement of a majority of the students enrolled in the class concerned. Any alteration so agreed to will be notified to all students concerned on blackboard and an announcement will be made in class.

Write a Review

Required(*) Message

Portfolio Management Questions & Answers

Any reason not to buy a wristwatch for dressy occasions

Revise the sentences to convey an appropriately confident attitude.- Can you think of any reason not to buy a wristwatch for dressy occasions?

Company might experience two-stage growth

A company might experience two-stage growth for which of the following reasons?

What is the marginal tax rate for a single individual

What is the marginal tax rate for a single individual if her taxable income is $20,000? $40,000? 60,000? What is her tax bill for each of these income levels? What is her average tax rate for each of these income levels?

Identify and briefly explain two cfa institute standards

Briefly describe two CFA Institute Standards of Professional Conduct that apply to Clark. Identify and briefly explain two CFA Institute Standards of Professional Conduct that apply to this situation.

Describe steps involved in applying binomial option pricing

Briefly describe the steps involved in applying binomial option pricing model to value the call option in this situation. What is this fair market value for the call option under these conditions?

Calculate the variance of an equally weighted portfolio

Calculate the variance of an equally weighted portfolio. - Calculate the covariance of a portfolio that has 10% in asset 1, 80% in asset 2, and 10% in asset 3 with a second portfolio that has 125% in asset 1, - 10% in asset 2, and -15% in asset 3.

Which mutually exclusive project would you select

Which mutually exclusive project would you select, if both are priced at $1,000 and your required return is 15%:

Student number to generate data for portfolio

You have been put in charge of the Quality Control systems for the resistor produc- tion line that your company has developed.Run PF4NumberGen.m in MATLAB with your student number to generate your data for this portfolio. The code will output the dat..

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!

Submit Assignment

User Account

All Pages