Solved by verified expert:I have already finished the whole parts of Final milestone. Please help me to follow the requirement to make adjustment about that. I posted my own milestone and pls check the files. I need a completed whole final. Thanks a lot.Your final submission should be 7–11 pages in length. The Investment Analysis Report should include a spreadsheet of your compiled
data, a complete portfolio, and a 2- to 3-page executive summary. The total page length includes the executive summary but does not include title, reference
pages, or the spreadsheet. It should be written in 12-point Times New Roman font, double-spaced, following the most recent APA standards for formatting and
referencing.
fin640_final_project_guidelines_and_rubric.pdf
milestone_fianl_640_original.docx
fin640_portfolio_analysis_template_2.2.xlsx
Unformatted Attachment Preview
FIN 640 Final Project Guidelines and Rubric
Overview
For the final project, you will submit an investment analysis report for a hypothetical company, based on provided constraints and research of market and
industry trends. You will need to utilize the topics covered throughout the course in order to demonstrate mastery of the knowledge and skill required of a
corporate investment manager. Through research and calculations, you will be analyzing the company’s place in the financial market, constructing a portfolio,
and compiling your findings in an executive summary to justify your investment strategies and decisions, along with evaluating the investment performances.
As a corporate investment manager, it is your responsibility to construct an investment portfolio that will generate the maximum rate of return within a given
risk class. In order to be successful in this, you need to synthesize your knowledge of your company’s industry and its place in the wider financial markets and of
the modern portfolio theory, along with utilizing both qualitative and quantitative skills.
This project addresses the following course outcomes:
Evaluate financial market conditions in order to assess impact on companies and their portfolios
Calculate rates of return for shareholders utilizing the dividend discount model and market multiples
Determine appropriate balance between risk and return when constructing company portfolios
Justify how securities in a portfolio reflect stakeholders’ investment objectives and meet professional standards
Analyze industry trends in relation to company valuation on an absolute and relative basis for informing investment decisions
Implement portfolio management strategies that meet the investment objectives of a corporation
Prompt
You are a new investment manager of XYZ Tech Company. The CEO has asked you to produce an investment analysis report. Using the provided information and
investment parameters for the company along with your own financial database research, prepare an investment analysis report for the company. Your analysis
report should include compiled data spreadsheets, a complete portfolio, and a justification of your investment strategies in an executive summary.
Specifically, the following critical elements must be addressed:
I.
Company and Market Analysis: In this section, you will analyze the company and its position in the financial markets.
A. Financial Markets
i.
Analyze the five-year performance of the domestic economy relative to the financial markets.
ii.
Explain specific market performance data based on compiled asset valuation model inputs supported by database research of five-year
sector and industry performance and current trends.
iii.
Evaluate the impact of the five-year and current macroeconomic data on asset prices.
B. Company Valuation
i.
ii.
Analyze the company’s financial items and key ratios in order to demonstrate a comparison to peers and industry.
Determine the intrinsic value of assets by inputting data into the various asset valuation models, and explain how each model was
applied.
C. Industry Trends
i.
Compile historic industry microeconomic data from database research for relative comparisons and inputs into asset valuation models.
ii.
Analyze quantitative data across sectors and industries to measure absolute and relative performance.
D. Stakeholders
i.
Identify five key stakeholders and their needs in relation to the company’s portfolio.
ii.
Identify the common stockholders’ primary objective and their required return on equity.
II.
Portfolio: With your company and market analysis in mind, construct a complete portfolio that includes the following:
A. Assets
i.
Explain the inclusion of specific asset classes for the portfolio, considering the portfolio’s risk/return trade-offs and the company’s
investment objectives.
ii.
Apply the asset allocation weightings across asset classes, sectors, and industries.
B. Securities
i.
Analyze the company’s historical revenue and earnings growth in order to demonstrate a comparison to that of peers in the industry.
ii.
Determine the intrinsic value of assets utilizing the asset valuation models.
C. Rates of Return
i.
Analyze the assets’ historical risk and rates of return, utilizing a comparison of the assets’ rates of return to similar securities or
benchmarks for support.
ii.
Calculate required rates of return, utilizing various asset valuation models (e.g. stock valuation models, bond valuation models, real
estate valuation models, etc.).
D. Compare the risk/return trade-off on the investments.
III.
Executive Summary: Justify your investment strategies in a summary, utilizing your company and market analysis and portfolio for support. Include the
following in your justification:
A. Describe how making these investments will position the company within its industry in the market. Support with examples.
B. Explain the benefits of the investments to stakeholders.
C. Assess investment performance utilizing specific performance measurements.
D. Assess investment performance based on risk/return metrics, citing specific examples.
E. Explain how the strategies implemented in the portfolio meet the company’s investment objectives.
Milestones
Milestone One: Company Profile
In Module Three, you will submit your company profile. Using the investment parameters for XYZ Tech Company along with your own financial database
research, you will complete several Excel spreadsheets and write a brief 1- to 2-page paper briefly outlining the securities and bonds that your company might
possibly invest in to create a well-diversified investment portfolio. You will analyze each company and its performance in the financial markets over the past five
years, include a company valuation for each firm, and identify stakeholders in the company. This milestone will be graded with the Milestone One Rubric.
Milestone Two: Portfolio
In Module Five, you will first complete the Company and Market Analysis portion of your final project. Using historic and quantitative data, you will provide a
brief discussion of the absolute and relative performance of the chosen companies in terms of industry trends. Next, with your completed company and market
analysis in mind, you will begin to construct an investment portfolio that includes a consideration of assets, securities, and rates of return for each of the
companies that you will be including in the portfolio. This milestone will be graded with the Milestone Two Rubric.
Milestone Three: Portfolio Performance Analysis
In Module Seven, you will first complete your portfolio by comparing the risk/return trade-off on the investments you are compiling. Then, as part of the
beginning of your executive summary, you will describe how your investments performed on both an absolute and a relative basis. You will also assess
investment performance for the seven securities by calculating the portfolio’s overall investment performance and briefly note how each security contributed to
the portfolio’s performance. This milestone will be graded with the Milestone Three Rubric.
Final Submission: Investment Analysis Report and Executive Summary
In Module Nine, you will submit your final project, the Investment Analysis Report, which should include data spreadsheets, a complete portfolio, and an
executive summary. Note: Your executive summary must include the Section III critical elements B, D, and E as outlined in this document (you completed Critical
Elements A and C in Milestone Three). This submission will be graded with the Final Project Rubric.
Deliverables
Milestone
One
Two
Three
Deliverable
Company Profile
Module Due
Three
Grading
Graded separately; Milestone One Rubric
Five
Graded separately; Milestone Two Rubric
Portfolio Performance Analysis
Seven
Graded separately; Milestone Three Rubric
Final Submission: Investment Analysis
Report and Executive Summary
Nine
Graded separately; Final Project Rubric
Portfolio
Final Project Rubric
Guidelines for Submission: Your final submission should be 7–11 pages in length. The Investment Analysis Report should include a spreadsheet of your compiled
data, a complete portfolio, and a 2- to 3-page executive summary. The total page length includes the executive summary but does not include title, reference
pages, or the spreadsheet. It should be written in 12-point Times New Roman font, double-spaced, following the most recent APA standards for formatting and
referencing.
Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information,
review these instructions.
Critical Elements
Company and Market
Analysis: Financial
Markets: Domestic
Economy
Exemplary
Meets “Proficient” criteria, and
analysis demonstrates keen
insight into the relation of
economic performance to
financial markets
(100%)
Proficient
Analyzes the five-year
performance of the domestic
economy relative to the
financial markets
(90%)
Company and Market
Analysis: Financial
Markets: Asset
Valuation Model
Inputs
Meets “Proficient” criteria, and
the database research used
exemplifies advanced
knowledge of performance and
trends
(100%)
Explains specific market
performance data based on
compiled asset valuation model
inputs supported by database
research of five-year sector and
industry performance and
current trends
(90%)
Company and Market
Analysis: Financial
Markets:
Macroeconomic Data
Meets “Proficient” criteria, and
evaluation demonstrates keen
insight into the impact of
macroeconomic data on asset
pricing
(100%)
Evaluates the impact of the
five-year and current
macroeconomic data on asset
prices
(90%)
Needs Improvement
Analyzes the five-year
performance of the domestic
economy relative to the
financial markets, but analysis
is cursory or contains
inaccuracies
(70%)
Explains specific market
performance data based on
compiled asset valuation model
inputs, but explanation is
cursory, is not supported by
database research of five-year
sector and industry
performance and current
trends, or contains inaccuracies
(70%)
Evaluates the impact of the
five-year and current
macroeconomic data on asset
prices, but evaluation is cursory
or contains inaccuracies
(70%)
Not Evident
Does not analyze the
performance of the domestic
economy
(0%)
Value
5.28
Does not explain specific
market performance data
based on compiled asset
valuation model inputs
(0%)
5.28
Does not evaluate the impact
of the macroeconomic data on
asset prices
(0%)
5.28
Company and Market
Analysis: Company
Valuation: Financial
Items an Key Ratios
Meets “Proficient” criteria, and
comparisons demonstrate keen
insight into the relation of the
company to industry peers in
terms of key financial ratios
(100%)
Analyzes the company’s
financial items and key ratios in
order to demonstrate a
comparison to peers and
industry
(90%)
Company and Market
Analysis: Company
Valuation: Intrinsic
Value
Meets “Proficient” criteria, and
explanations demonstrate
advanced knowledge of how
asset valuation models are
used for determining intrinsic
value of assets
(100%)
Determines the intrinsic value
of assets by inputting data into
the various asset valuation
models and explains how each
model was applied
(90%)
Company and Market
Analysis: Industry
Trends:
Microeconomic Data
Meets “Proficient” criteria, and
compilation demonstrates keen
insight into the microeconomic
data needed for asset valuation
models
(100%)
Compiles historic industry
microeconomic data from
database research for relative
comparisons and inputs into
asset valuation models
(90%)
Company and Market
Analysis: Industry
Trends: Absolute and
Relative Performance
Meets “Proficient” criteria, and
analysis demonstrates keen
insight into how data can
measure absolute and relative
performance
(100%)
Analyzes quantitative data
across sectors and industries to
measure absolute and relative
performance
(90%)
Analyzes the company’s
financial items and key ratios in
order to demonstrate a
comparison to peers and
industry, but analysis is
cursory, comparison is
incomplete, or response
contains inaccuracies
(70%)
Determines the intrinsic value
of assets by inputting data into
the various asset valuation
models, but determination
contains inaccuracies, or asset
valuation models are not used
correctly, or lacks explanation
(70%)
Compiles historic industry
microeconomic data from
database research for relative
comparisons and inputs into
asset valuation models, but
compilation is incomplete or
contains inaccuracies
(70%)
Analyzes quantitative data
across sectors and industries to
measure absolute and relative
performance, but analysis is
cursory, contains inaccuracies,
or is not used to measure
absolute and relative
performance
(70%)
Does not analyze the
company’s financial items and
key ratios in order to
demonstrate a comparison to
peers and industry
(0%)
5.28
Does not determine the
intrinsic value of assets
(0%)
5.28
Does not compile historic
industry microeconomic data
(0%)
5.28
Does not analyze quantitative
data across sectors and
industries
(0%)
5.28
Company and Market
Analysis:
Stakeholders: Key
Stakeholders
Meets “Proficient” criteria, and
identification demonstrates
keen insight into the needs of
company stakeholders
(100%)
Identifies five key stakeholders
and their needs in relation to
the company’s portfolio
(90%)
Company and Market
Analysis:
Stakeholders:
Common
Stockholders
Meets “Proficient” criteria, and
identification demonstrates
keen insight into objectives of
common stockholders
(100%)
Identifies the common
stockholders’ primary objective
and their required return on
equity
(90%)
Portfolio: Assets:
Asset Classes
Meets “Proficient” criteria, and
explanation demonstrates keen
insight into the relationship
between the risk/return tradeoff, investment objectives, and
asset classes
(100%)
Explains the inclusion of
specific asset classes for the
portfolio, considering the
portfolio’s risk/return tradeoffs and the company’s
investment objectives
(90%)
Portfolio: Assets:
Allocation Weightings
Portfolio: Securities:
Historical
Applies the asset allocation
weightings across asset classes,
sectors, and industries
(100%)
Meets “Proficient” criteria, and
analysis demonstrates keen
insight into how the company’s
growth relates to its peers’
(100%)
Analyzes the company’s
historical revenue and earnings
growth in order to
demonstrate a comparison to
that of peers in the industry
(90%)
Identifies key stakeholders and
their needs in relation to the
company’s portfolio, but does
not identify five stakeholders,
needs are inappropriately
identified in relation to the
portfolio, or response contains
inaccuracies
(70%)
Identifies the common
stockholders’ primary objective
and their required return on
equity, but identification is
inaccurate or does not take
into account either the
objective or return on equity
(70%)
Explains the inclusion of
specific asset classes for the
portfolio, but does not consider
risk/return trade-offs or
investment objectives,
explanation is cursory, or
contains inaccuracies
(70%)
Applies the asset allocation
weightings across asset classes,
sectors, and industries, but
application is incomplete or
contains inaccuracies
(70%)
Does not identify key
stakeholders and their needs in
relation to the company’s
portfolio
(0%)
5.28
Does not identify the common
stockholders’ primary objective
or their required return on
equity
(0%)
5.28
Does not explain the inclusion
of specific asset classes for the
portfolio
(0%)
3.17
Does not apply the asset
allocation weightings across
asset classes, sectors, or
industries
(0%)
3.17
Analyzes the company’s
historical revenue and earnings
growth, but analysis is
incomplete, does not
demonstrate a comparison to
peers, or contains inaccuracies
(70%)
Does not analyze the
company’s historical revenue
or earnings growth
(0%)
3.96
Portfolio: Securities:
Intrinsic Value
Portfolio: Rates of
Return: Historical
Meets “Proficient” criteria and
demonstrates advanced
knowledge of using asset
valuation models in relation to
intrinsic value
(100%)
Meets “Proficient” criteria, and
analysis masterfully uses the
comparison of assets’ rates of
return to similar securities or
benchmarks for support
(100%)
Portfolio: Rates of
Return: Calculate
Portfolio:
Risks/Return
Executive Summary:
Position
Executive Summary:
Benefits to
Stakeholders
Meets “Proficient” criteria, and
comparison demonstrates keen
insight into trade-off on
investments
(100%)
Meets “Proficient” criteria, and
support used demonstrates
keen insight into how
investments can position a
company in its industry and the
market
(100%)
Meets “Proficient” criteria, and
explanation demonstrates keen
insight into how the
stakeholders will benefit from
the investments
(100%)
Determines the intrinsic value
of assets, utilizing the asset
valuation models
(90%)
Analyzes the assets’ historical
risk and rates of return,
utilizing a comparison of the
assets’ rates of return to similar
securities or benchmarks for
support
(90%)
Calculates required rates of
return, utilizing various asset
valuation models
(100%)
Compares the risk/return
trade-off on the investments
(90%)
Describes how making these
investments will position the
company within its industry in
the market, supported with
examples
(90%)
Explains the benefits of the
investments to stakeholders
(90%)
Determines the intrinsic value
of assets, but determination
does not utilize asset valuation
models, is incomplete, or
contains inaccuracies
(70%)
Analyzes the assets’ historical
risk and rates of return,
utilizing a comparison of the
assets’ rates of return to similar
securities or benchmarks, but
analysis is cursory, is
insufficiently supported, or
contains inaccuracies
(70%)
Calculates rates of return, but
calculations are incomplete or
contain inaccuracies
(70%)
Compares the risk/return
trade-off on the investments,
but comparison is incomplete
or contains inaccuracies
(70%)
Describes how making these
investments will position the
company within its industry in
the market, but description is
cursory, is insufficiently
supported, or contains
inaccuracies
(70%)
Explains the benefits of the
investments to stakeholders,
but explanation is cursory or
contains inaccuracies
(70%)
Does not determine the
intrinsic value of assets
(0%)
3.96
Does not analyze the assets’
historical risk and rates of
return, utilizing a comparison
of the assets’ rates of return to
similar securities or
benchmarks
(0%)
3.96
Does not calculate rates of
return
(0%)
5.28
Does not compare the
risk/return trade-off on the
investments
(0%)
3.96
Does not describe how making
these investments will position
the company within its industry
in the market
(0%)
5.28
Does not explain the benefits
of the investments to
stakeholders
(0%)
5.28
Executive Summary:
Investment
Performance
Meets “Proficient” criteria, and
the performance
measurements utilized
demonstrate advanced
knowledge into assessing
performance
(100%)
Assesses investment
performance, utilizing specific
performance measurements
(90%)
Executive Summary:
Risk/Return Metrics
Meets “Proficient” criteria, and
examples used demonstrate
keen insight into how
risk/return metrics can be used
to assess performance
(100%)
Assesses investment
performance based on
risk/return metrics, citing
specific examples
(90%)
Executive Summary:
Investment
Objectives
Meets “Proficient” criteria, and
explanation demonstrates keen
insight into the company’s
investment objectives
(100%)
Explains how the strategies
implemented in the portfolio
meet the company’s
investment objectives
(90%)
Submission is free of errors
related to citations, grammar,
spelling, syntax, and
organization and is presented
in a professional and easy-to …
Purchase answer to see full
attachment
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more