Prepare an executive level financial report

Assignment Help Finance Basics
Reference no: EM13835449

SITUATION:

OBJECTIVE

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, publicly-traded, company. 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 (company selected by instructor).

Alternatively, you can request me to approve another publicly traded company. This request must be submitted before the end of the first week of the course. The request must include

a.         identification of the company by ticker symbol and name

b.         a reasonable and appropriate explanation of why you want to examine the alternative company

c.         the source of the analyst's report that will be used in the analysis (which must be submitted to me)

d.         acknowledgement by you that all of the specific elements of the assignment (see below) will be prepared by you and included in the final research project report

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 THE COMPANY THAT IS TO BE ANALYZED FOR THIS PROJECT (COMPANY SELECTED BY INSTRUCTOR) (a real publicly-traded company) is the best potential candidate for a long-term commitment.  THE COMPANY (COMPANY SELECTED BY INSTRUCTOR) 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 THE COMPANY (COMPANY SELECTED BY INSTRUCTOR) 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 question is: will THE COMPANY 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 THE COMPANY THAT IS TO BE ANALYZED FOR THIS PROJECT (COMPANY SELECTED BY INSTRUCTOR.  In addition to reviewing the traditional financial performance indicators, you are also to review THE COMPANY'S past and current stock performance. Your report includes three parts:

(1)        An evaluation of THE COMPANY'S financial performance for the last year. DuPont analysis and analysis of significant financial performance results are required for the last three years. (See detailed description below) 

(2)        An evaluation of THE COMPANY'S stock performance for the last one year.

(3)        Finally, a specific recommendation, with supporting rationale, as to whether or not THE COMPANY'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 THE COMPANY'S financial and stock performance trends against its Industry.

You may wish to include all necessary and relevant financial performance and stock information, trends, and projections in supporting your recommendation. These factors may include, financial ratio trends and industry comparatives, capital spending, stock growth, Beta values, credit rating service valuations, bond rating valuations, and management and investment reports - when these documents are available.

REPORT REQUIREMENTS

YOUR SPECIFIC ASSIGNMENT

Research and analyze the following information for THE COMPANY (SELECTED BY INSTRUCTOR).

--Annual Balance Sheets for THE COMPANY for the last three years.

--The Income Statements for THE COMPANY the last three years.

-- Annual reports, 10K or 10Q------

 --Industry norms -----------

---Analysts' reports on performance

-- Management reports or press releases                                 

Using this information the students have to develop evaluation of the financial performance for THE COMPANY (SELECTED BY INSTRUCTOR). (Totally 85% of the assignment grade) 

-1-Background and Industry (one short paragraph). 

-2-Select of most significant financial performance results for the company: Compare Revenue, net income, working capital, total assets for the last three years and other results of your choice of the company against the industry or main competitor. Present the table with this information in your report. Write about 1 page of the analysis of these financial performance results. (15% of the project grade)

-3-Find financial ratios for the company and its major competitor in the Internet. Write about 1-2 pages of analysis of the ratio results you received. (15% of the project grade). Compare the ratio results against the industry or main competitor.

-4- Evaluate Return on Equity for the company for the last three years using the DuPont analysis. (10% of the project grade). Compare the company's results to a major competitor.

Taking the information from the Income statements and the Balance sheets, calculate the company's return on equity using the DuPont technique for the company for three years. Show your calculation!

Write about 1 page of analysis of the results that you received. Compare the results to main competitor. 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, stock growth, Beta values, credit rating service valuations (if possible), bond rating valuations (if possible), etc. Make an overall conclusion about financial performance of the company during the last years. Compare the results that you received against the industry or main competitor.  Summarize the results that you received in 1 page. What are the firm's financial strengths and weaknesses? (10% of the project grade)

-6- Collect and evaluate the data about stock performance of the assigned company's for the last one year. Compare the results that you received against the industry or main competitor.

Write about 1-2 pages of analysis of the ratio results you received. (20% of the project grade).

-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 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 THE COMPANY THAT IS TO BE ANALYZED FOR THIS PROJECT (COMPANY SELECTED BY INSTRUCTOR) 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.

The Individual Research Report must be posted to the D2L 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 and graded.

If these formats are not available, use the following option:

File - Save As - in the bottom of the window for saving file you see "save as type" - choose type Rich Text Format for doc. file, and previous option of Excel for Excel file. 

 Pdf. files will not be accepted and graded.

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).   

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). 

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.

Reference no: EM13835449

Questions Cloud

Consistent with the law of supply : Problem 1: Which of the following is consistent with the law of supply? Check all that apply.
What is the probability that those horses finish first : A horse race has 13 entries one person owns 3 of those horses. Assuming no ties, what is the probability that those horses finish first, second and third
Discuss the role of birds in one or both plays : Discuss the role of birds in one or both plays. What do birds suggest about the characters or their differing levels of freedom? Consider the use of birdcages as well. In what ways are the characters limited by their gender, social status, and/or ..
Find the percentile that corresponds to each life span : (a) The life spans of three randomly selected fruit flies are 34 days, 30 days, and 42 days. Find the z-score that corresponds to each life span. Determine whether any of these life spans are unusual. (b) The life spans of three randomly selected fru..
Prepare an executive level financial report : 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..
Analyze internal factor influencing consumer decision making : The Consumer Journal Report requires you to analyse the internal and external factors influencing the consumer decision making process for a major purchase - e.g. a car or a holiday.
Element on which you are focusing line by line : Include a thesis statement that states the element you are analyzing and why. Follow a systematic writing pattern by analyzing the element on which you are focusing line by line or stanza by stanza
State three common terms used in toxicology : State three common terms used in toxicology. Give a brief discussion for each one and include at least two examples. Describe the contributions to toxicology that were made by early toxicologists. Be specific and include examples.
What are the concerns regarding hydrogen limiting it : What are the concerns regarding hydrogen that are currently limiting its widespread use throughout the world? Discuss your thoughts from a socioeconomic, chemical reactions, and safety perspective.

Reviews

Write a Review

Finance Basics Questions & Answers

  What must the expected return on this stock be

A stock has a beta of 1.32, the expected return on the market is 10 percent, and the risk-free rate is 3.5 percent. What must the expected return on this stock be?

  What yield did melissa earn on her investment

A year ago, Melissa purchased 50 shares of common stock for $20 per share. during the year, the value of her stock decreased to $18 per share. If the stock did not pay a dividend during the year, what yield did Melissa earn on her investment?

  What are the two definitions of cash and why do corporate

what are the two definitions of cash and why do corporate treasurers often use the second

  What is co. break even point in sales dollars

A co.has sales revenue of 20xx was$144,000. co. product sells for $5.50 and has %30 contribution margin. co. has fixed costs of $33,000. What is co. break even point in sales dollars?

  For each of the following cases compute the total taxes

for each of the following cases compute the total taxes resulting from the sale of the asset. assume a 34 percent

  What is your average accounts receivable balance

On average your firm sells $32,600 of items on credit each day. Your average inventory period is 30 days and your operating cycle is 50 days. What is your average accounts receivable balance?

  Compute effective annual interest rate

A bank offers your Corporation a revolving credit arrangement for up to $60 million at an interest rate of 1.52% per quarter. The bank also needs you to maintain a compensating balance of 6% against the unused portion of credit line.

  Involved in destructive conflict.

Describe a situation in which you were involved in destructive conflict. How could it have been managed differently?

  Its profit margin on sales is 6 and 40 of earnings will be

at year-end 2010 bertin inc.s total assets were 1.2 million and its accounts payable were 375000. sales which in 2010

  Describes expected property losses

1. Terry is a small business entrepreneur and owns 6 buildings for business use. The probability distribution below describes expected property losses for the group of 6 buildings. Assume that the property exposures are independent of each other.

  Superannuation-defined benefit

Write down difference between inflation and the 'time value of money'? Please describe what issues relating to concept of 'time value of money' might be significant when choosing between a defined benefit or an accumulation super fund.

  Prepare a bank reconciliation

The following are summary financial information for Parker Corporation, and Boulder, Corporation, for three recent years:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd