Financial Analysis Report Project

December 14, 2022

Financial Analysis Report Project

Order Number	636738393092
Type of Project	ESSAY
Writer Level	PHD VERIFIED
Format	APA
Academic Sources	10
Page Count	3-12 PAGES

Instructions/Descriptions

Financial Analysis Report Project

Financial, Analysis, Report, Project

[Order Now]

Make sure that you label each part clearly and that you complete all parts (a-h). The qualitative parts of your paper should be at least 2100 words. The most important part of your paper is the final recommendation (part h) which should be supported by the discussion of key statistics such as ratios, market value, beta, and diluted EPS and the forecast of several key variables (parts e and f).

You grade will be mostly determined by your performance on these sections. Use interior titles to separate your work. Present your financial statements as an appendix. Include a reference page of at least 6 references in APA style.

Overview of your corporation. (300 words)
The latest financial statements. (You can present these as an appendix to your report)
A summary of each financial statement. Take each statement and state the key parts in words. (300-500 words)
Ratio calculations (presented in a table)
Discussion of key statistics such as ratios, market value, beta, and diluted EPS. (600 words)
Forecast several key variables, including the stock price. Use regression analysis, and/or moving average, etc. to create your forecast. Create a graph from the historical data and show your forecast on the same graph. Say specifically what the forecasted value of the stock price is. Address the question, “Is this forecast reasonable?” (300 words)
Other information pertinent to the corporation that could affect its future performance and stock price, including dividend policy, capital structure, bond ratings, expert opinions, new projects, litigation, regulation, etc. (300-500 words)
Recommendation regarding the future of this corporation. Is the stock a good buy, average buy, or a poor buy (implying a good sell)? Include a justification of your recommendation based on your analysis and research. (300-500 words)

The research paper assignment is worth 140 points of the course grade.

The objectives/purpose of the research paper project are to enable you to do a comprehensive financial analysis of a publicly traded corporation; and provide you with substantial information for you to make recommendations regarding investing in this corporation.

Your financial analysis report will be driven by a rigorous ratio analysis, and aggressively supplemented with your written analysis, interpretation, and evaluation of the data.

Your research should be strategically driven by two probing questions:

-Would you invest your financial capital in the selected firm as a shareholder?

-Would you invest your human and intellectual capital in the firm as an employee?

Steps in preparation of financial analysis report:

Select a publicly held company
Select a benchmark firm to compare your company against. The benchmark firm is typically the largest competitor.
Obtain the firm’s balance sheet, income statement, and statement of cash flows for the past 5 years. Download or read the firm’s annual report.
Go to the U.S. Securities and Exchange Commission website (Links to an external site.)and research EDGAR’s database for additional SEC report filings: 8-k, 10-Q.
The following table is the type of Excel or Word table that should be used to gather and report your ratio and financial performance data. Note the 5 financial diagnostic categories that should be used in your analysis.

Financial diagnostic categories

Chosen company vs.

Benchmark competitor

1.) Liquidity of short-term assets

-Current ratio

-Cash ratio

-Quick ratio

-Current ratio

-Cash ratio

-Quick ratio

2.) Long-term debt-paying ability

-Debt ratio

-Debt-equity ratio

-Times interest earned

-Debt ratio

-Debt-equity ratio

-Times interest earned

3.) Profitability

-Net income/sales (profit margin)

-Net income/assets (ROA)

-Net income/shareholder equity (ROE)

-Net income/sales (profit margin)

-Net income/assets (ROA)

-Net income/shareholder equity (ROE)

4.) Asset utilization/ management efficiency

-Total asset turnover

-Inventory turnover measures

-Accounts receivable turnover

-Total asset turnover

-Inventory turnover measures

-Accounts receivable turnover

5.) Market measures

-Price/earnings ratio

-Earnings per common share

-Dividend payout

-Price/earnings ratio

-Earnings per common share

-Dividend payout

Use 2-3 ratios per diagnostic category. Place your ratio calculations in the table for your selected companies—primary company and benchmark competitor. Using 5 diagnostic categories, and 3 ratios to assess each category, results in 15 ratio measures per company that will be compared side by side.

To validate your research, 5 years of data should be analyzed.
The financial analysis report must be written properly. They must include a title page, a table of contents, and a reference page. Your final report, information sources from the web, etc. must be cited properly, using APA style.

This means that every table that you cut and pasted or typed from the web must have a source at the bottom of the table AND that citing must also be included in a reference page at the end of the report.

The parts of the research paper are discussed below. The completed report (parts a through h) is due day 7 of week 7. Your project should include:

An overview of the corporation.
Provide general information regarding the type of business, products and/or services, location of headquarters, name of CEO, number of employees, and countries of operation, etc.
The latest financial statements
Get the income statement, balance sheet, cash flow statement, and the statement of owners’ equity for the past fiscal year. Create Turnitin-friendly versions of the financial statements; do not just ‘cut and paste’ them in your report. Do not forget to cite the source under each statement.
If you cannot cut and paste them, you may have to type in the information in a table in your report.
A summary of each financial statement
Take each statement and state the key parts in words. Tell a story from each of the financial statements. For example, for the income statement, the story starts like, “Total Revenues in 2015 were $10 billion, while Cost of Goods Sold were $8 billion, leaving a gross profit margin of $2 billion, or 20 percent of total revenues….After taking out interest and taxes from EBIT, the net income was $0.5 billion, or 5 percent of total revenues.”
Ratio calculation (include 5 major types of ratios. Refer to chapter 3, Analysis of Financial Statements)
Organization of this section is based on the FIVE types of ratios listed in the text book. Calculate the ratios from the financial statements in part c above using Excel or your calculator and present them in a table.
Find industry financial ratios online (e.g. Yahoo.com) and compare your corporation’s ratios to these industry ratios.

iii. Present your results following the five types of ratios discussed in part d.

A table with both corporation and industry ratios is required;
Discussion of key statistics provided by sources like Yahoo finance.
There are many different other statistics available for your corporation. These include market value, beta, and diluted EPS, etc. Discuss some of the key statistics that you think can assist you to determine if this corporation is a good buy or sell.
For you to decide if a corporation’s stock is a good buy or sell, you must forecast several key variables, including the stock price.
Use historical prices (5 years of monthly data recommended) and forecast the stock price for the next year. Use regression analysis, and/or moving average, etc. to create your forecast.
Create a graph from the historical data and show your forecast on the same graph. You can add a trend line to the graph to help you with a forecast. Include the graph in your report.

iii. You need to say specifically what the forecasted value of the stock price is.

You must address the question, “Is this forecast reasonable?” Must you amend your analysis to get a more reasonable forecast?
Other information pertinent to the corporation that could affect its future performance and stock price.
This could include dividend policy, capital structure, bond ratings, expert opinions on TV, new projects, litigation, regulation, etc. Search for information on the web regarding this corporation. Look at company complaint blogs, etc.
Recommendation regarding the future of this corporation.
Is the stock a good buy, average buy, or a poor buy (implying a good sell)?
Include a justification of your recommendation based on your analysis and research.

[Order Now]

Financial Analysis Report Project

RUBRIC

Excellent Quality

95-100%

Introduction

45-41 points

The context and relevance of the issue, as well as a clear description of the study aim, are presented. The history of searches is discussed.

Literature Support

91-84 points

The context and relevance of the issue, as well as a clear description of the study aim, are presented. The history of searches is discussed.

Methodology

58-53 points

With titles for each slide as well as bulleted sections to group relevant information as required, the content is well-organized. Excellent use of typeface, color, images, effects, and so on to improve readability and presenting content. The minimum length criterion of 10 slides/pages is reached.

Average Score

50-85%

40-38 points

More depth/information is required for the context and importance, otherwise the study detail will be unclear. There is no search history information supplied.

83-76 points

There is a review of important theoretical literature, however there is limited integration of research into problem-related ideas. The review is just partly focused and arranged. There is research that both supports and opposes. A summary of the material given is provided. The conclusion may or may not include a biblical integration.

52-49 points

The content is somewhat ordered, but there is no discernible organization. The use of typeface, color, graphics, effects, and so on may sometimes distract from the presenting substance. It is possible that the length criteria will not be reached.

Poor Quality

0-45%

37-1 points

The context and/or importance are lacking. There is no search history information supplied.

75-1 points

There has been an examination of relevant theoretical literature, but still no research concerning problem-related concepts has been synthesized. The review is just somewhat focused and organized. The provided overview of content does not include any supporting or opposing research. The conclusion has no scriptural references.

48-1 points

There is no logical or apparent organizational structure. There is no discernible logical sequence. The use of typeface, color, graphics, effects, and so on often detracts from the presenting substance. It is possible that the length criteria will not be reached.