[SOLVED] ACFI2070 Business Finance T324 SQL

ACFI2070 Business Finance T324

Individual Written Assignment

Weighting: 25%

Length: 2000 words maximum (excluding appendices)

Issue Date: Friday 25th October 12:00 (SGT)

Due Date: Friday 15th November 23:59 (SGT)

Submission Method: Online – Turnitin (via CANVAS).

Purpose

This task develops and evaluates student understanding and application of securities valuation, optimal investment decisions and modern portfolio theory

Description

Students apply critical thinking and problem solving to answer four problem questions that require numerical calculation and clear written communication of results.

Assessment Criteria

The assignment will be graded against the following five (5) criteria:

•    Correct calculations.

•    Depth and relevance of analysis.

•    Logic and coherence in information evaluation and organisation.

•    Demonstrated understanding of theory and relevant concepts

•    Clarity of written expression in communicating outcomes

Topics Covered: Module 3 (Modern Portfolio Theory)

Tasks: This assessment involves undertaking four (4) main tasks as follows:

Task 1: Calculating Equity Beta (8 marks)

Select a company (we shall call this Equity A) listed on a major stock exchange. Ensure that you can access and download historical share price data for the selected company and an appropriate benchmark (market) index. There are various sources of data available (for free) online, such as Yahoo Finance. Download the data (usually this downloads as a .csv file) and save it into an Excel Workbook.

a)    Using Excel, calculate the returns on your selected equity and the benchmark index over the last 4 years (2 marks).

b)   Calculate the Beta for your selected equity (2 marks).

c)    Comment on the performance of your chosen company and the implications of the estimated Beta (2 marks).

d)    Discuss potential problems associated with how you have calculated your Beta (2 marks).

Task 2: Calculating 3-Asset Portfolio Metrics (9 marks)

Select and download historical data (for the last 4-years) on the share prices of two additional companies (we shall call these Equity B and C) listed on the same stock exchange as Equity A. You now have data for three equities, which represent your 3-asset portfolio.

a)    Calculate the individual returns, variance and standard deviation of returns on your (three) selected equities (note: you have already calculated the returns on Equity A in Task 1) (3 marks).

b)   Calculate the covariances and correlation coefficients between your equities (3 marks).

c)    Assuming an equally-weighted portfolio, calculate the portfolio rate of return, variance and standard deviation (3 marks).

Task 3: Evaluating Portfolio Risk and Performance (5 marks)

a)    Calculate the Beta for your equally-weighted 3-asset portfolio (i.e. containing Equity A, B and C). (1 mark).

b)    Utilising appropriate measures of portfolio performance, comment on the performance of your portfolio and the implications of the estimated portfolio Beta (2 marks).

c)    If you believe the stock market will begin to drift downwards over the next year, explain how you might ‘fine-tune’ your 3-asset equity portfolio to help safeguard investors’ wealth under  your management? Assume that your fund can only invest in equities (2 marks).

Task 4: Individual Equity Selection (3 marks)

Based on the preceding analysis, if you are only allowed to pick one equity (A, B or C) for investment, which asset will you prefer as a rational investor? Explain your reason(s) (3 marks).