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
Which of the following statements is true regarding the sensitivity analysis approach to
investment appraisal?
a. It involves changing many factors at the same time
b. It provides an indication of the likelihood of changes in the key factors
c. It provides managers with clear guidance concerning the investment decision
d. It is commonly called ‘how-now’ analysis
e. Noneoftheabovearetrue
arrow_forward
The following are investment criteria: net present value, payback, profitability index, average accounting return, and the internal rate of return.
Question: Which one of these is the most valuable from a financial point of view, and why? (Answer the question correctly and in-depth.)
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
Which of the following best explains the role of diversification as part of an investment strategy?
a.Choosing investment vehicles with varying levels of risk/reward
b.Spreading investments out over time
c.Balancing investment amounts with debt amounts
d.Soliciting the opinions of multiple financial planners
arrow_forward
Your client is evaluating the upside and downside of a potential investment. What
stage of the Financial Planning process is this?
O Routine
Allocation
O Indemnification
O Assessment
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
- Which of the following statements is true regarding the sensitivity analysis approach to investment appraisal? a. It involves changing many factors at the same time b. It provides an indication of the likelihood of changes in the key factors c. It provides managers with clear guidance concerning the investment decision d. It is commonly called ‘how-now’ analysis e. Noneoftheabovearetruearrow_forwardThe following are investment criteria: net present value, payback, profitability index, average accounting return, and the internal rate of return. Question: Which one of these is the most valuable from a financial point of view, and why? (Answer the question correctly and in-depth.)arrow_forwardPrepare 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_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_forwardWhile 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_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_forwardWhich of the following best explains the role of diversification as part of an investment strategy? a.Choosing investment vehicles with varying levels of risk/reward b.Spreading investments out over time c.Balancing investment amounts with debt amounts d.Soliciting the opinions of multiple financial plannersarrow_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