Financial Research Project

Hello,I just have seen that you have done a financial research project which is very similar to my project. the only different is the company ( my company is Sprint). I just need one part of this project because this is our group project which my group mads will do the rest of work. My part is number 4 which I highlighted in the file attachment. I need this part in 2 pages by Saturday Dec 2nd. If you are interested to help me, Please let me know. Thank you in advance.Nicky
financial_research_project.docx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Financial Research Project
Just from $13/Page
Order Essay

— FINANCIAL RESEARCH PROJECT ——Worth 25% of the course grade.
Due date is stated in the course schedule.
THE PROJECT IS DESIGNED TO BE COMPLETED AS A GROUP
The specific objective of this graded written research exercise is to prepare an “executive level
financial report” to the Chief Financial Officer (CFO) of a mythical company in which you are
employed as a financial analyst. This report will pertain to the financial evaluation of a real, publiclytraded, company, SPRINT. It will require independent research (web-based or library), careful
financial analysis, and the proper application of key financial theories and formulas.
The company that is to be analyzed for this project is to be a company selected by instructor. For
our class, we will look at Sprint, the cellular provider.
SITUATION
You are a financial analyst with the mythical High Technology Corporation (“HTC”). HTC is an
established manufacturer of a line of electronic components, which services an international market.
HTC is currently a new fully-integrated wireless communication service for world-wide use. A
competitive technical and economic product evaluation has determined that Sprint is the best
potential candidate for a long-term cellular contract commitment.
Sprint is offering a competitively favorable deal. However, based on some serious general concerns
about the fallout of companies in the industry in general, the CEO has asked your CFO to conduct a
financial analysis of Sprint to determine if it is prudent to commit to this company’s communication
system. The cost of cutting over to the new communications system is significant and any
interruption in support during the next few years would adversely affect HTC’s performance and
profit.
Specifically, the primary question is: will Sprint be financially viable over the next two to three years?
YOUR SPECIFIC ASSIGNMENT
Your specific assignment is to research, analyze, and prepare a report for the CFO on the actual
financial performance of Sprint. In addition to reviewing the traditional financial performance
indicators, you are also to review Sprint’s past and current stock performance. Your report includes
three parts:
(1)
An evaluation of Sprint’s financial performance for the last three years. (See detailed
description below)
(2)
An evaluation of Sprint’s stock performance for the last one year. (See detailed description
below)
(3)
Finally, a specific recommendation, with supporting rationale, as to whether or not Sprint’s
recent trend in financial and stock performance is of sufficient financial strength to warrant entering
into a long-term commitment.
To assist you in your task, the CFO has provided the following general guidance. Since it is
recognized that the industry is undergoing a major contraction, it is very important to comparatively
evaluate Sprint’s financial and stock performance trends against its Industry or major competitor
(Verizon, AT&T Wireless, etc.).
SUGGESTED WEBSITES
www.marketwatch.com -To find the information for your company you need to type the stock symbol
in the Search window to get into the company’s page.
www.morningstar.com – To find the information for your company you need to type the stock symbol
in the Quotes window to get into the company’s page.
www.money.cnn.com -To find the information for your company you need to type the stock symbol
in the Search window to get into the company’s page.
www.finance.yahoo.com – To find the information for your company you need to type the stock
symbol in the Search window to get into the company’s page.
www.nyse.com – Click on Data, then click on Stocks (under Quotes), and type the name of the
company or the stock symbol in the window “Keyword or symbol” to get into the company’s page.
www.nasdaq.com – To find the information for your company you need to type the stock symbol in
the Search window to get into the company’s page.
Company’s websites
YOUR SPECIFIC ASSIGNMENT
Using the information from the websites the students have to develop evaluation of the financial and
stock performance for Sprint. (Totally 85% of the assignment grade)
-1—Background and Industry (one short paragraph).
-2—Analysis of the most significant financial performance results. (15% of the project grade)
a. Select of most significant financial performance results for the company. Create a table that
contains Sprint’s financial performance results for the last three yearsand for the major
competitor or industry for the last year: Revenue, net income, working capital, and other
financial performance results of your choice. Present the table with this information in your
report.
b. Write about 1 page of the trend analysis of these financial performance results.
-3— Financial ratio analysis. (15% of the project grade)
Find financial ratios for the company for the last 1-3 years and its major competitor for the last year
in the Internet.
a.
b.
Present the ratios as the table(s) in your project.
Write about 2 pages of analysis of the ratio results that you found. Compare the ratio
results against the industry or main competitor. In your analysis you should answer the
following questions:
•
•
•
How liquid is the company?
How is the company financing its assets?
Is management generating a substantial profit on the company’s assets?
-4- Evaluate Return on Equity for the company for the last three years using the DuPont
analysis. (10% of the project grade)
a. Taking the information from the Income statements and the Balance sheets, calculate the
company’s net profit margin, total assets turnover equity multiplier, and return on equity
using the DuPont formula for the company for three years. Show your calculation!
ROE = Net profit margin x Total assets turnover x Equity multiplier
= Net income/Sales x Sales/Total assets x Total assets/Common equity
You can use Revenue instead of Sales.
b. Compare the results to main competitor. For the major competitor you can use ratios from
the Internet or calculate them for the last year.
Write about 1 page of analysis of the results that you received. In your report please answer the
question: If the management of the company would like to improve their return on equity, what
should the management of these companies do?
-5- Evaluate other areas of financial analysis: capital spending, Beta values, credit rating
service valuations (if possible), bond rating valuations (if possible), etc. (10% of the project
grade)
1) Find the data for capital spending. How much did Sprint spend on research, development, and
engineering in the most recent year? How did this compare with the previous year?
2) Find the current beta for the company and its major competitor in the Internet.
a. Present beta results as the table in your project.
b. Write about 0.5 page of analysis of beta values that you found. Compare the beta values
against the main competitor. In your report please answer the question: How risky the
company is?
-6- Collect and evaluate the data about stock performance of the assigned company’s for the
last one year. (20% of the project grade).
1) Find the market ratios for the company for the last 1-3 years and its major competitor for the last
year in the Internet.
a. Present the market ratios as the table(s) in your project.
b. Write about 1 page of analysis of the market ratio results that you found. Compare the
market ratio results against the industry or main competitor. In your report please answer the
question: Are the common stockholders receiving an adequate return on their investment?
-2) Analysis of the historical stock prices trend for the last year.
a. Collect and evaluate the data about stock prices of the assigned company’s for the last one
year for the company and its major competitor.
b. Create the chart(s) using the stock price chart tools on the websites or Excel. Present the
chart(s) in your project.
c. Write about 0.5 page of analysis the historic stock prices trend for the last year.
3) Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required
return on Sprint’s stock. Note that you will need the risk-free rate and the market return. Show this
information in your project.
a. To get the current yield on 10-year Treasury securities go to Finance!Yahoo’s at
www.finance.yahoo.com -click on Market Data – Bonds. You will use the current yield on
10-year Treasury securities as the risk-free rate to estimate the required rate of return on
stocks. Show this information in your project.
b. To get the market return go to money.cnn.com , Click on Market, then click on S&P 500.You
will use 52-weeks change for S&P500 listed as “Year-to-Date” percentage change. Show this
information in your project.
c. Calculate the required return on Sprint’s stock using the Capital Asset Pricing Model (CAPM)
Security Market Line. Please show your work.
d. Find on the Internet the 52-weeks change of the stock price. Compare the required return on
the stock calculated using CAPM against it’s historical return over the last 52 weeks, found
on the Internet. Is there a difference between these returns? Is Sprint’s stock overvalued,
undervalued, or properly valued? Why? Explain your answer.
-7- Develop a specific recommendation, with supporting rationale, as to whether or not the
assigned company’s recent trend in financial and stock performance is of sufficient financial strength
to warrant entering into a long-term commitment (about 1 page) (15% of the project grade).
PRESENTATION OF PAPER AND WRITING (15%) of the project grade):
-Organization, Format and Presentation of Paper including the Title page, Introduction, Body, and
Summary (4% of the project grade)
Use of Tables, Figures and Other Graphics to Summarize and Support Analysis Presented in the
Paper (3% of the project grade)
Logical and Smooth Flowing Transitions and Relationships among Sections of the Written Report
(3% of the project grade)
Research Sources and Significance of Research Information and Data, Use of APA Citation
Methodology (5% of the project grade)
Your final report is to be an executive-level financial report, directed to the CFO. This report should
be about 8-10 double-spaced typewritten pages (without tables and graphs). Include suitable
comparative, quantitative and qualitative analyses and conclude with a specific and supported
recommendation on the projected financial viability of Sprint for the next several years.
Essential research data, financial calculations and other documentation as necessary to support
your recommendation should be referred to in summary form in your report and attached in detail as
enclosures. All major sources should be referenced. There is no set limit to the size of the
enclosures, but it is recommended that only essential enclosures be attached. You should use
references and bibliography to identify any remaining supporting documents you wish to include.
Format of the Research Project:
The Data Exercise must be posted to the LEO Student Assignments as a Attachments are limited to
a maximum two files in doc, docx., xls. xlsx., or rtf. formats. OTHER FORMATS ARE NOT
ACCEPTABLE, will not be reviewed or graded.
Please note that hand-written and scanned works, pdf. files, jpg. files, as well as files posted
in google drive, will not be accepted or graded.
The paper should be written in APA style Research Paper format.
Please note that Use of APA Citation Methodology is required for the assignment.
All works must be Word processed. Handwritten and scanned work will not be accepted and graded.
This report is an individual effort and must be researched, developed and prepared by you. All
questions related to this assignment, should be referred to the mythical CFO (i.e., your instructor).
In accordance with the UMUC Academic Policy, notes taken for papers and research projects
should accurately record sources of material to be cited, appropriately quoted, paraphrased
or summarized, and papers and research projects should acknowledge these sources in the
appropriate places in the text of the paper as well as in a reference list at the end of the
paper, in accordance with accepted citation practices. No more than 30% of the text of the
project should be made up of quotes.
*****************************************************
Evaluation Rubric for the Research Project.
An evaluation rubric is available for the research project. The evaluation rubric outlines the specific
requirements and elements of the project. It is suggested that the rubric be used as a guideline for
the content, preparation, and completion of the project.
The rubric will be used for the evaluation and grading of the final research project.
1. Financial
statements
analysis of the
assigned
company (15%)
Virtually no effort to
develop financial
statements analysis
of the assigned
company; not
worthy of credit.
Only a superficial
effort to develop
financial statements
analysis of the
assigned company
The project contains
some financial
statements analysis
of the assigned
company, but should
be considerably
more developed
Good effort is made
to develop financial
statements analysis
of the assigned
company
Excellent and very
development and a
of financial stateme
analysis of the assi
company
2. Financial ratio
trend analysis of
the assigned
company and
industry
comparatives.
(15%)
Virtually no effort to
develop financial
ratio trends analysis
of the assigned
company and
industry
comparatives; not
worthy of credit
Some effort made to
develop financial
Minimal effort to
ratio trends analysis
develop financial
of the assigned
ratio trends analysis
company and
of the assigned
industry
company and
comparatives,
industry
however the result
comparatives.
are not explained
and analyzed.
Good effort to
develop financial
ratio trends analysis
of the assigned
company and
industry
comparatives, the
result are well
explained and
analyzed
Excellent and succe
effort to implement
ratio trends analysi
assigned company
industry comparativ
clear linkages betw
financial retio result
and investment de
and recommendatio
3. DuPont
analysis of the
assigned
company.
Compare with
Virtually no effort to
develop DuPont
analysis of the
assigned
Minimal effort to
develop DuPont
analysis of the
assigned company.
Some effort made to
develop DuPont
analysis of the
assigned company,
however the result
Good effort to
develop DuPont
analysis of the
assigned company,
the result are well
Excellent and succe
effort to implement
analysis of the assi
company very clear
between DuPont an
main competitor.
(10%)
company not
worthy of credit
Virtually no effort to
develop the
4. Other areas of
analysis of the other
financial
areas of financial
analysis: capital
analysis: capital
spending, Beta
spending, Beta
values, credit
values, credit rating
rating service
service valuations,
valuations, bond
bond rating
rating valuations,
valuations;
etc. (10%)
unworthy of much
credit
are not explained
and analyzed.
Minimal effort
to analyze
other areas of
financial
performance:
capital
spending, Beta
values, credit
rating service
valuations, bond
rating valuations
Some effort
to analyze other
areas of financial
performance:
capital spending,
Beta values, credit
rating service
valuations, bond
rating valuations
explained and
analyzed
Very good effort
to analyze other
areas of financial
performance: capital
spending, Beta
values, credit rating
service valuations,
bond rating
valuations
and investment de
and recommendatio
Outstanding effort to to
other areas of financial
capital spending, Beta v
credit rating service valu
bond rating valuations
Some effort made
to develop
5. The evaluation No effort to develop
evaluation of the
of the assigned
the evaluation of
assigned
company’s stock the assigned
company’s stock
performance for company’s stock
performance for the
the last year.
performance for the
last year, but
(20%)
last year.
analysis is very
short and limited
Good effort made to
develop the
evaluation of the
assigned company’s
stock performance
for the last
year, however the
result are not
explained and
analyzed.
Good effort made to
develop the
evaluation of the
assigned
company’s stock
performance for the
last year, the result
are well explained
and analyzed
Excellent and
accurate evaluatio
assigned company’
performance for the
very clear linkages
stock performance
and investment de
and recommendatio
6.
The
student
developed
specific
recommendation,
with supporting
rationale, as to
whether or not
the assigned
company’s
recent trend in
financial and
stock
performance is of
sufficient
financial strength
to warrant
entering into a
long-term
commitment.
(15%)
Very good effort
made to explain
Some effort made to
relationships the
explain relationships
assigned
the assigned
company’s recent
company’s financial
trend in financial
and stock
and stock
performance to
performance to
warrant entering into
recommend
a long-term
entering into a longcommitment, but
term
there are significant
commitment. There
gaps in the analysis
are no significant
gaps in the analysis
Outstanding and ve
thorough effort to e
relationships the as
company’s recent tr
financial and stock
performance. The r
sufficient to warran
into a long-term com
Paper has some
blemishes in
Paper is extremely
has no blemishes; i
Some effort made
Little or no effort to to explain
explain linkages
relationships of the
between the
assigned
assigned
company’s financial
company’s financial and stock
and stock
performance to
performance to
warrant entering
warrant entering
into a long-term
into a long-term
commitment, the
commitment
analysis is poor and
incomplete.
PRESENTATION OF PAPER AND
WRITING
7. Organization,
Format and
There appears to
be no logical
Presentation has
numerous
Paper is neatly
presented without
Presentation of
Paper including
Introduction,
Body, and
Summary (4%)
organization of the
paper’s contents
blemishes and
there may be a
general lack of
organization
presentation and
may have some
weaknesses in
organization
Tables, figures and
other graphics
provide marginal
support for the
paper; some labels
may be incomplete;
there may be some
problems with the
numbering
sequence
Tables, figures and
other graphics are
descriptive and
provide solid
support for the
paper; they are
properly labeled
and numbered
Tables, figures and
graphics are very d
and provide except
strong support for t
there are no errors
in the numbering se
Some transitions
used in paper
Good transitions
used in most
sections
Very effective trans
used throughout the
analysis
8. Use of Tables,
Figures and
Other Graphics
to Summarize
and Support
Analysis
Presented in the
Paper (3%)
Use of tables,
figures and other
graphics in support
of paper is
unworthy of credit
Tables, figures and
other graphics do
not provide much
support for the
paper; they may
have inadequate
labels; and
numbering
sequence is
inadequate
9. Logical and
Smooth Flowing
Transitions and
Relationships
Among Sections
of the Written
Report (3%)
No effort made to
provide appropriate
transitions
Paper makes
minimal use of
transitions
major blemishes
and is generally
well-organized
organization is outs
and very easily follo
RESEARCH APPROACH AND USE OF APPROPRIATE PROFESSIONAL SOURCES OF
INFORMATION AND DATA
10. Research
Sources and
Significance of
Research
Information and
Data, Use of
APA Citation
Methodology,
use of double
spaced, with
one-inch
margins, and use
12-point Times
New Roman font.
(5%)
No obvious effort to
use professional
and supporting
research sources
Little effort made to
use appropriate
professional and
supporting research
sources which may
be accompanied by
inadequate
documentation
Some effort to
identify and use
appropriate and
professional and
supporting research
sources with some
documentation
Good effort to
identify and use
appropriate and
professional and
supporting research
sources;
appropriate and
professional use of
APA
documentation, use
of double space …
Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

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.

Money-back guarantee

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 more

Zero-plagiarism guarantee

Each 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 more

Free-revision policy

Thanks 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 more

Privacy policy

Your 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 more

Fair-cooperation guarantee

By 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

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP