Plot the daily returns for the year 2015

Assignment Help Financial Management

Reference no: EM131192329

Learning outcomes

a critical understanding of statistical methods used by managers to reduce data and estimate the risk of specific industry projects interpret and communicate statistical information and financial results to support strategic decisions independently identify, collect, record, manage and analyse financial and statistical data using appropriate methods

Case study A

Land Securities Group plc (see www.landsecurities.com) are the largest commercial property company in the UK and a member of the FTSE 100. Founded in 1944, they now own and manage more than 26 million square feet of property, from shopping centres to London offices.

You are provided with the following information:

1. The company website: www.landsecurities.com

2. Yahoo finance: https://uk.finance.yahoo.com/q?s=LAND.L

3. Historical prices for the company https://uk.finance.yahoo.com/q/hp?s=LAND.L (all websites accessed 25 May 2016)

Case study B

PKB Ltd is embarking on an expansionary phase, and is planning to invest in upgrading its manufacturing capacity.

The company manufactures a range of household tools for wholesale and retail distributors. Its latest summary balance sheet is shown below:

Balance Sheet at financial year-end 2015 / £000s

Non-current assets (net book value)	8,234
Net current assets	783
Net assets	9,017
Share capital	1,000
Other reserves	8,017

Other information regarding the financial position of PKB Ltd:

- There is no long-term debt. PKB Ltd has an overdraft facility which fluctuates throughout the year but averages at £1m overdrawn and is expected to be around this amount for the foreseeable future. The overdraft is included in net current assets in the balance sheet. Finance costs in the last year were £80,000.

- The cost of the investment is £5m in today's money. This investment will be funded by debt finance, a long-term bank loan.

- The new manufacturing plant and equipment will have a predicted useful life of four years and an estimated scrap (terminal) value of 15% of their original cost in real terms.

- Inflation is estimated at 3% per year.

- PKB Ltd can borrow funds at 1.5% above the risk-free rate of interest.

- For a project with this level of risk the Finance Director of PKB Ltd considers that a discount rate of 9% should be appropriate.

- The new plant will be paid for and commissioned at the start of the upgrading project.

- The fixed costs of operating the new plant and equipment will be £1.2m per year in today's money.

- The variable operating costs will be 60% of the sales value.

- The project is expected to generate new sales of £8.5m per year, in today's money, if no additional marketing is undertaken (see next point).

- If PKB Ltd were to launch an intensive marketing campaign to promote the additional products, new sales could be increased by 12%. Estimated annual costs of the marketing campaign for each of the next three years are £250,000 in today's money.

- All cash inflows and outflows are taxable at 28%.

- Tax is paid in the same year that the relevant taxable cash flows are generated (including the scrap value of the plant and equipment). PKB Ltd can use tax allowances of 25% on capital expenditure of this nature.

Task

You are required to complete a detailed analysis concerning the following issues:

Land Securities Group plc

a. Download the historical prices (https://uk.finance.yahoo.com/q/hp?s=LAND.L) for one year only, from 1 January 2015 to 31 December 2015, and then calculate the daily returns based on ‘close' prices (column E). The daily return is calculated as the close price at the end of the day minus the close price for the preceding day and this is then divided by the close price from the preceding day and expressed as a percentage. This can be expressed in an equation, or formula, as (P1 - P0) / P0, where P1 is the close price today and P0 the close price for the preceding day.

Plot the daily returns for the year 2015 (around 250 observations) and calculate the descriptive statistics (mean, mode, median, variance, covariance and frequency distribution). Also comment on the overall result.

PKB Limited

b. The case study relates to a company, PKB Ltd, that is currently considering an expansion of its product range and a possible marketing campaign. Prepare a report on the planned

investment that uses payback, NPV and IRR and also shows how the marketing campaign would affect the viability of this project.

c. Discuss how the risk in this project could be incorporated into your calculations and identify which of the assumptions made in the case study is the most critical for the viability of the project.

Reference no: EM131192329

Questions Cloud

Assurance and auditing processes : Describe the actions an organization needs to execute in order to improve their quality assurance and auditing processes within the organization. Create a list of at least five (5) auditing best practices for organizations to follow when implement..

Designing and implementing an effective compliance plan : The Office of Inspector General (OIG) has established a set of guidelines (e.g., auditing, monitoring, internal controls, sampling, due diligence, and standards of organizational and employee behavior, etc. Page 508 of the textbook) that physician..

Audit in a large corporate environment : Suggest the elements of change and patch management that are most difficult to audit in a large corporate environment with multiple IT issues and changes occurring every day. Provide a rationale for your suggestions

What would be the characteristics of your ideal manager : What would be the characteristics of your ideal manager? The answer to this question might depend on whether this manager is one you report to or one that is reporting to you.

Plot the daily returns for the year 2015 : MAN7MFI - Management Finance and Science - Plot the daily returns for the year 2015 (around 250 observations) and calculate the descriptive statistics (mean, mode, median, variance, covariance and frequency distribution). Also comment on the overal..

Smp and massively parallel processing : What are the components used in SMP and Massively Parallel Processing (MPP) machines?

Develop competitive compensation and benefits packages : Examine data from two (2) organizations listed in the BLS Website with packages similar to yours, focusing on salary, compensation, and benefits in order to convince upper management that your package should be accepted and implemented.

Protect planning-related information : To protect planning-related information from leaking outside Ken 7 Windows Limited domain, all ERP planning functions must require secure connections from the client's Web browser to the Ken 7 internal Web server. No other connections, except from..

Hard drive on a traditional tower computer : How do you replace a hard drive on a traditional tower computer? If someone could walk me through the steps to install and setup, that would be very helpful! Thank you in advance

User Account

All Pages