Tutorial 2 Solutions
pdf
keyboard_arrow_up
School
Swinburne University of Technology *
*We aren’t endorsed by this school
Course
FIN30020
Subject
Finance
Date
Jun 1, 2024
Type
Pages
2
Uploaded by ElderCat3253
Q1: Which of the following statements reflects the importance of the asset allocation decision to the investment process? The asset allocation decision:
A.
helps the investor decide on realistic investment goals.
B.
identifies the specific securities to include in a portfolio.
C.
determines most of the portfolio’s returns and volatility over time.
D.
creates a standard by which to establish an appropriate investment time horizon. Q2: Use data provided
, consider the following tasks: Data preparation:
1.
Inspect the data and firstly compute the monthly log returns based on the formula below: ret_t = log(adj_price_t/adj_price_(t
-1)) See the Excel workings. 2.
Compute the monthly average returns for each asset given
and annualise by multiplying by 12.
Which asset has delivered the best return?
See the Excel workings. 3.
Compute the monthly standard deviation for each asset given and annualise by multiplying by sqrt(12).
Which asset has delivered the least risk?
See the Excel workings. 4.
Prepare the correlation matrix (exclude the IVV) and comments on how each asset return is correlated?
Are there any benefits of adding Bitcoin into equities? Use the correlation function within the Data Analysis Add
-in. Based on the correlation, it seems that Bitcoin has relatively low correlations with equities, therefore there is a diversification benefits by including Bitcoin.
5.
Examine the return distributions of each asset over the sample period using histograms, do they look normal to you? Which asset stands out in terms of non-
normal behaviour and how skewed is the return?
All individual equity returns are not normal
(not bell-
shaped). BHP – Left Skewed (negative skewness) CSL – Left Skewed (negative skewness) DIS – Right Skewed (positive skewness)
AAPL – Left Skewed (negative skewness) AMZN - Left Skewed (negative skewness) TSLA - Right Skewed (positive skewness) NVDA - Left Skewed (negative skewness) BTC - Left Skewed (negative skewness) NVDA is mostly skewed
Asset allocation: 6.
Construct two 1/n strategy portfolios based on the Australian shares and U.S shares and evaluate the performance of these portfolio
over the sample period
. How much will you get by the end of the sample period if you invested $10,
000 at the beginning? See the Excel workings. 7.
Compute the Sharpe Ratio for each portfolio
. See the Excel workings. 8.
Based on the Sharpe Ratio, which portfolio is the best choice from the mean-
variance optimal perspective?
Based on the results from Q5, is the Sharpe Ratio the best decision criteria? See the Excel workings. See the lecture slides and discussions on how skewness and kurtosis should also be considered when looking at the risks of assets. Q3: Construct a diversified portfolio consisting of three stocks, and one market index. Please refer to the spreadsheet for detailed Questions
. See the Excel workings.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
1. How to compare different assets in investment selection process?
2. What are the quantitative characteristics of the assets and how to measure them?
3. How does one asset in the same portfolio influence the other one in the same portfolio?
4. And what could be the influence of this relationship to the investor’s portfolio?
5. What is relationship between the returns on an asset and returns in the whole market (market portfolio)?
arrow_forward
Which of the following are the key factors when determining asset allocation for an investment?
I. Time an investor has until he needs to use the money from the investment (time horizon)
II. Risk preferences (tolerance for risk)
III. Current financial situation
a.
I., II., & III.
b.
I. & III.
c.
II. & III.
d.
I. & II.
arrow_forward
Can you help me with this please?
explanation of the characteristics of investment appraisal decisions and theadvantages and disadvantages of the IRR.
arrow_forward
Prepare a detailed analytical report that encompasses the following areas.
Nature of investment markets, the Primary and secondary investment markets. Also brief discussion on the money market and capital market providing key differences between the two.
Five stages of the investment management process providing key points that will ensure the success of the investment decision.
arrow_forward
Explain why risk and uncertainty should be considered in the investment appraisal process.
arrow_forward
Which approach to investment analysis is "best" in terms of accounting for both the timing and amount of revenue streams from a potential investment?
A. the payback period
B. the simple rate of return
C. the net present value
D. the internal rate of return
arrow_forward
While comparing investment returns is an important starting point in evaluating investment performance, it represents which part of the analysis?
arrow_forward
What text and supplemental information, is there a best choice for using any one specific method of investment valuation, or do you have more than one?
arrow_forward
Which of the following tools is sometimes used to rank investment
proposals?
01.
02.
03.
04.
05.
Project assessment guide (PAG).
Investment opportunity index.
Annuity index.
Profitability index.
Capital ranking index.
arrow_forward
The strategy that is used to determine the long-term policy asset weights in a portfolio is called O a. strategic asset allocation. O b. tactical asset allocation. O c. integrated asset allocation. O d. sector rotation. O e. insured asset allocation.
arrow_forward
Asset allocation is performed to
A) reduce the load that intermediaries charge
maximize the earning potential of an
B)
investment vehicle
C) maximize the earning potential of a portfolio
protect against significant declines in any
D)
one investment vehicle
O E) maximize the returns from any one vehicle
arrow_forward
An NPV analysis is one part of a complete captial investment analysis. What is the second part that must be completed if the first part is positive?
arrow_forward
What does it mean that portfolio diversification can reduce risk, and how does the efficient frontier logically fit into this discussion? include correlation, asset allocation, and asset classes or benchmarks in your answer.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- 1. How to compare different assets in investment selection process? 2. What are the quantitative characteristics of the assets and how to measure them? 3. How does one asset in the same portfolio influence the other one in the same portfolio? 4. And what could be the influence of this relationship to the investor’s portfolio? 5. What is relationship between the returns on an asset and returns in the whole market (market portfolio)?arrow_forwardWhich of the following are the key factors when determining asset allocation for an investment? I. Time an investor has until he needs to use the money from the investment (time horizon) II. Risk preferences (tolerance for risk) III. Current financial situation a. I., II., & III. b. I. & III. c. II. & III. d. I. & II.arrow_forwardCan you help me with this please? explanation of the characteristics of investment appraisal decisions and theadvantages and disadvantages of the IRR.arrow_forward
- Prepare a detailed analytical report that encompasses the following areas. Nature of investment markets, the Primary and secondary investment markets. Also brief discussion on the money market and capital market providing key differences between the two. Five stages of the investment management process providing key points that will ensure the success of the investment decision.arrow_forwardExplain why risk and uncertainty should be considered in the investment appraisal process.arrow_forwardWhich approach to investment analysis is "best" in terms of accounting for both the timing and amount of revenue streams from a potential investment? A. the payback period B. the simple rate of return C. the net present value D. the internal rate of returnarrow_forward
- While comparing investment returns is an important starting point in evaluating investment performance, it represents which part of the analysis?arrow_forwardWhat text and supplemental information, is there a best choice for using any one specific method of investment valuation, or do you have more than one?arrow_forwardWhich of the following tools is sometimes used to rank investment proposals? 01. 02. 03. 04. 05. Project assessment guide (PAG). Investment opportunity index. Annuity index. Profitability index. Capital ranking index.arrow_forward
- The strategy that is used to determine the long-term policy asset weights in a portfolio is called O a. strategic asset allocation. O b. tactical asset allocation. O c. integrated asset allocation. O d. sector rotation. O e. insured asset allocation.arrow_forwardAsset allocation is performed to A) reduce the load that intermediaries charge maximize the earning potential of an B) investment vehicle C) maximize the earning potential of a portfolio protect against significant declines in any D) one investment vehicle O E) maximize the returns from any one vehiclearrow_forwardAn NPV analysis is one part of a complete captial investment analysis. What is the second part that must be completed if the first part is positive?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning