微信客服：xiaoxionga100
微信客服：ITCS521
程序代写案例-FINC 2011
时间：2022-04-30
FINC 2011 Corporate Finance I, Semester 1, 2022
Due Date: 11:59 pm 11 May 2022
Major Assignment (20% of total mark)
You have just started an internship at a large investment fund called “Alpha Animals”.
Your manager has tasked you to write a report for a client that have two stocks in her
portfolio: Apple Inc (Nasdaq code: AAPL) and Woolworths Group Ltd (ASX code:
WOW). Given the uncertainty with current financial markets, this client is considering
investing only for the medium term (approximately 5 years). The investment fund is
thinking whether this client’s existing portfolio is a well-diversified or limited
diversification strategy. You expect that extra returns could be generated as
compensation for bearing more risk. Please write this report as on January 3rd, 2020
and do not use any information on and after this date.
Required:
1. Using Yahoo Finance, obtain market index and stock price data for your client’s
portfolio companies to estimate their equity betas (https://au.finance.yahoo.com). To
estimate the equity betas for your proxy companies:
- Use an ordinary least squares regression under the Capital Asset Pricing Model
(CAPM).
Explain and justify your methodology, including: how key variables are measured, time
horizon, measurement intervals, market index, and risk-free rate.
NOTE: for the risk-free rate data, use the information on the US Treasury page
(https://home.treasury.gov/policy-issues/financing-the-government/interest-rate-
statistics) and the RBA webpage: https://www.rba.gov.au/statistics/tables/#interest-
rates. Choose relevant government bond rates.
2. Estimate annualized expected return of each stock and the annualized standard
deviation of each stock using information or data from the above step.
3. Apple Inc has a weight of 70% and Woolworths Group Ltd has a weight of 30% in
in your client’s portfolio. What is your client’s portfolio risk in annualized terms?
4. Given the historical outperformance of Apple Inc, your client wants to increase the
exposure to AAPL to 130% by short-selling WOW to a -30% weight. Using portfolio
theory, explain to your client why this is a good or bad idea. Assuming you can borrow
and lend at the risk-free rate.
5. Your colleague Brad Damon is worried about the upcoming market turmoil and
would like to recommend the client constructing a portfolio with least possible portfolio
risk while fully invested as he is constrained by the investment mandate of his fund.
Please advise the client what portfolio weights are allocated to AAPL and WOW that
results lowest portfolio variance (or standard deviation), and explain why this is a good
or bad idea.
Assessment Criteria:
1. Conforming with instructions (e.g. word length, font, other instructions)
2. Presentation, communication & style (written)
3. Clarity of expression (incl. accuracy, spelling, grammar, punctuation)
4. Referencing
5. Use of literature/knowledge of theory
6. Data/information gathering/processing
7. Conclusions
8. Analysis
9. Problem solving
10. Reflection/evaluation
Formatting and Presentation:
1. The assignment report should be no more than 8 pages. This page limit excludes 1
title page, a reference list, appendices, and your group formation form (a formation
form is only required for groups with 2-5 members). Use 1.5 line spacing and size 12
Times New Roman or Arial Font. Please number the pages of your report. Marks will
be reduced by 10% for each page you exceed the page limit. Hence your mark will be
reduced to zero if the assignment exceeds 18 pages. Brevity and conciseness are key
ingredients of a highly successful report. You will be penalised for inappropriate
formatting.
2. Make sure you use proper referencing in your assignment. All assignments must
include a list of references in academic form using the APA method. The APA
referencing style can be found here: https://libguides.library.usyd.edu.au/citation/apa7
You will be penalised if you use inappropriate referencing.
3. Pay particular attention to presentation. A component of your mark will be based on
presentation. Avoid overdoing formatting, and ensure that the assignment is very
clear, concise, well-structured/logical and professional. Pay particular attention to
grammar as well. Every part of the assignment should somehow add to the end result
– determining an appropriate share price - otherwise it is superfluous and distracting.
4. Supportive data tables and regression outputs should be posted in a supplementary
Appendix in your report of maximum 15 pages in length. Appendix does not count
toward the 8-page limit.
5. If you have questions about your assignment, please post them on the Ed
discussion board. Do NOT email your tutor/lecturer/coordinator for assignment-related
enquiries.
6. Only administrative/procedural questions will be answered. This assignment
requires you to carry out your own independent research and thus a substantial
component of your marks will be attributable to your justifications (i.e., we are not
looking for any exact numerical answers!).
7. The report must be submitted as a PDF document. You must submit the report
electronically via the Turnitin link on canvas. Excel spreadsheets containing all
calculations must be submitted as a .xlsx workbook. You must submit two files
electronically via the link on Canvas.
Page limit for assignment – 8 pages
What is included in the 8 page limit?
• Report body
• Tables
• Diagrams
What is excluded from the 8 page limit?
• Title page
• Group formation form (only required for groups with 2-5 members)
• Table of contents
• Executive summary
• Reference list
• Appendices (Appendices should be used sparingly and only used to provide
information to the reader, where appropriate)
Marking Guide:
Selection and justification of data /4 marks
Calculation of betas /4 marks
Calculation of the CAPM return /4 marks
Portfolio construction /3 marks
Final recommendation /3 marks
Presentation and style of report /2 marks
Penalties
Inappropriate use of financial models - up to 6 marks
Incorrect referencing - up to 4 marks
Failure to comply with formatting requirements - up to 2 marks
Each page over the page limit -2 marks per page
TOTAL MARKS /20 marks
Due Date: 11:59 pm 11 May 2022
Major Assignment (20% of total mark)
You have just started an internship at a large investment fund called “Alpha Animals”.
Your manager has tasked you to write a report for a client that have two stocks in her
portfolio: Apple Inc (Nasdaq code: AAPL) and Woolworths Group Ltd (ASX code:
WOW). Given the uncertainty with current financial markets, this client is considering
investing only for the medium term (approximately 5 years). The investment fund is
thinking whether this client’s existing portfolio is a well-diversified or limited
diversification strategy. You expect that extra returns could be generated as
compensation for bearing more risk. Please write this report as on January 3rd, 2020
and do not use any information on and after this date.
Required:
1. Using Yahoo Finance, obtain market index and stock price data for your client’s
portfolio companies to estimate their equity betas (https://au.finance.yahoo.com). To
estimate the equity betas for your proxy companies:
- Use an ordinary least squares regression under the Capital Asset Pricing Model
(CAPM).
Explain and justify your methodology, including: how key variables are measured, time
horizon, measurement intervals, market index, and risk-free rate.
NOTE: for the risk-free rate data, use the information on the US Treasury page
(https://home.treasury.gov/policy-issues/financing-the-government/interest-rate-
statistics) and the RBA webpage: https://www.rba.gov.au/statistics/tables/#interest-
rates. Choose relevant government bond rates.
2. Estimate annualized expected return of each stock and the annualized standard
deviation of each stock using information or data from the above step.
3. Apple Inc has a weight of 70% and Woolworths Group Ltd has a weight of 30% in
in your client’s portfolio. What is your client’s portfolio risk in annualized terms?
4. Given the historical outperformance of Apple Inc, your client wants to increase the
exposure to AAPL to 130% by short-selling WOW to a -30% weight. Using portfolio
theory, explain to your client why this is a good or bad idea. Assuming you can borrow
and lend at the risk-free rate.
5. Your colleague Brad Damon is worried about the upcoming market turmoil and
would like to recommend the client constructing a portfolio with least possible portfolio
risk while fully invested as he is constrained by the investment mandate of his fund.
Please advise the client what portfolio weights are allocated to AAPL and WOW that
results lowest portfolio variance (or standard deviation), and explain why this is a good
or bad idea.
Assessment Criteria:
1. Conforming with instructions (e.g. word length, font, other instructions)
2. Presentation, communication & style (written)
3. Clarity of expression (incl. accuracy, spelling, grammar, punctuation)
4. Referencing
5. Use of literature/knowledge of theory
6. Data/information gathering/processing
7. Conclusions
8. Analysis
9. Problem solving
10. Reflection/evaluation
Formatting and Presentation:
1. The assignment report should be no more than 8 pages. This page limit excludes 1
title page, a reference list, appendices, and your group formation form (a formation
form is only required for groups with 2-5 members). Use 1.5 line spacing and size 12
Times New Roman or Arial Font. Please number the pages of your report. Marks will
be reduced by 10% for each page you exceed the page limit. Hence your mark will be
reduced to zero if the assignment exceeds 18 pages. Brevity and conciseness are key
ingredients of a highly successful report. You will be penalised for inappropriate
formatting.
2. Make sure you use proper referencing in your assignment. All assignments must
include a list of references in academic form using the APA method. The APA
referencing style can be found here: https://libguides.library.usyd.edu.au/citation/apa7
You will be penalised if you use inappropriate referencing.
3. Pay particular attention to presentation. A component of your mark will be based on
presentation. Avoid overdoing formatting, and ensure that the assignment is very
clear, concise, well-structured/logical and professional. Pay particular attention to
grammar as well. Every part of the assignment should somehow add to the end result
– determining an appropriate share price - otherwise it is superfluous and distracting.
4. Supportive data tables and regression outputs should be posted in a supplementary
Appendix in your report of maximum 15 pages in length. Appendix does not count
toward the 8-page limit.
5. If you have questions about your assignment, please post them on the Ed
discussion board. Do NOT email your tutor/lecturer/coordinator for assignment-related
enquiries.
6. Only administrative/procedural questions will be answered. This assignment
requires you to carry out your own independent research and thus a substantial
component of your marks will be attributable to your justifications (i.e., we are not
looking for any exact numerical answers!).
7. The report must be submitted as a PDF document. You must submit the report
electronically via the Turnitin link on canvas. Excel spreadsheets containing all
calculations must be submitted as a .xlsx workbook. You must submit two files
electronically via the link on Canvas.
Page limit for assignment – 8 pages
What is included in the 8 page limit?
• Report body
• Tables
• Diagrams
What is excluded from the 8 page limit?
• Title page
• Group formation form (only required for groups with 2-5 members)
• Table of contents
• Executive summary
• Reference list
• Appendices (Appendices should be used sparingly and only used to provide
information to the reader, where appropriate)
Marking Guide:
Selection and justification of data /4 marks
Calculation of betas /4 marks
Calculation of the CAPM return /4 marks
Portfolio construction /3 marks
Final recommendation /3 marks
Presentation and style of report /2 marks
Penalties
Inappropriate use of financial models - up to 6 marks
Incorrect referencing - up to 4 marks
Failure to comply with formatting requirements - up to 2 marks
Each page over the page limit -2 marks per page
TOTAL MARKS /20 marks
