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 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
1. Why methods and tools of the statistics are so important in investment decision making.
2. Explain, why doesn’t an estimated absolute covariance number tell the investor much about the relationship between the returns on the two assets?
arrow_forward
Describe the major steps in the construction of an investment portfolio.
plz give the point wise deep explaination.
arrow_forward
Asset pricing Models provide a logical basis for computing the risk premiums anddetermining the asset price. Describe using CAPM and APT. Also differentiatebetween CAPM & APT. Also discuss its assumptions.
This question is related to
Investment Analysis and Portfolio Management
arrow_forward
What is the MOST important variable of the financial planning process?
Select one:
a. The costs
b. The capacity of the fixed asset
c. The pro forma income statement
d. The sales forecast
arrow_forward
Describe the principles of asset valuation. Distinguish between the required rate of return and expected rate of return. Based on the asset valuation, how do the investors make investment decisions using the required rate of return?
arrow_forward
describe the stages in the financial process and discuss the advantages of a process driving approach to investment decision making. a- discuss the theory of efficient markets with specific reference to its applicability in investment decision-making.
b- Discuss the issues surrounding the PE-based value of investment valuation.
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
Compare and contrast the MPT with the CAPM with reference to the following aspects:
Risk measurement;
Risk-return graphical presentation – Capital Market Line (CML) versus Security Market Line (SML);
Usage in portfolio management.
arrow_forward
Whenever you make an investment decision, you need to consider its impacts on the diversification of your portfolio and the allocation of your assets.
a. false
b. depends
c. maybe
d. true
arrow_forward
Explain why income, budget, age, holging period and risk taking capacity helps in making the best options for investment selections and manage a portfolio. Include examples.
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
Demonstrate the link between net present value and internal rate of return and how they may be used in conjunction with one another to evaluate investments.
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
1. How important is risk to returns?
2. What are the key elements that must be analyzed in this regard before an investment decision is made?
arrow_forward
How We use quantitative data to manage risk and create investment vehicles?
arrow_forward
(b) Discuss and distinguish the following concepts
a. Money markets and capital markets
b. Asset Allocation and Asset Selection
c Active and passive Investment strategies
d. Technical and Fundamental Analysis
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
why net present value is considered to be superior to internal rate of return as an investment appraisal method? Critically evaluate and give an example if possible
arrow_forward
Using the data generated in the previous question (Question 1)
Plot the Security Market Line (SML)
b) Superimpose the CAPM’s required return on the SML
c) Indicate which investments will plot on, above and below the SML?
arrow_forward
Which of the followings is NOT in the scope of investment planning?
a. To develop a risk-free investment portfolio for the client by choosing different types of asset classes.
b. To analyse the risk appetite of the client
c. To assess the liquidity needs of the client
d. To analyse rhe financial objectives and lifestyles of the client
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
Describe Asset/Liability Models and explain why it is better than Value-at-Risk Models for Portfolio Management.
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_forward1. Why methods and tools of the statistics are so important in investment decision making. 2. Explain, why doesn’t an estimated absolute covariance number tell the investor much about the relationship between the returns on the two assets?arrow_forward
- Describe the major steps in the construction of an investment portfolio. plz give the point wise deep explaination.arrow_forwardAsset pricing Models provide a logical basis for computing the risk premiums anddetermining the asset price. Describe using CAPM and APT. Also differentiatebetween CAPM & APT. Also discuss its assumptions. This question is related to Investment Analysis and Portfolio Managementarrow_forwardWhat is the MOST important variable of the financial planning process? Select one: a. The costs b. The capacity of the fixed asset c. The pro forma income statement d. The sales forecastarrow_forward
- Describe the principles of asset valuation. Distinguish between the required rate of return and expected rate of return. Based on the asset valuation, how do the investors make investment decisions using the required rate of return?arrow_forwarddescribe the stages in the financial process and discuss the advantages of a process driving approach to investment decision making. a- discuss the theory of efficient markets with specific reference to its applicability in investment decision-making. b- Discuss the issues surrounding the PE-based value of investment valuation.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_forwardCompare and contrast the MPT with the CAPM with reference to the following aspects: Risk measurement; Risk-return graphical presentation – Capital Market Line (CML) versus Security Market Line (SML); Usage in portfolio management.arrow_forwardWhenever you make an investment decision, you need to consider its impacts on the diversification of your portfolio and the allocation of your assets. a. false b. depends c. maybe d. truearrow_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