Ask Basic Finance Expert

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:

1) Select a publicly held company: unliever

2) Select a benchmark firm to compare your company against. The benchmark firm is typically the largest competitor. Johnson & Johnson

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

4) Go to: http://www.sec.gov/edgar/searchedgar/webusers.htm

Research EDGAR's database for additional SEC report filings: 8-k, 10-Q.

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

6) To validate your research, 5 years of data should be analyzed. This means that you compute ratios for 5 years for both your selected company and your benchmark company.

7) The financial analysis report must be written properly. They must include a title page, a table of contents, and a reference page. For both midterm and 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 6. Your project should include:

a. An overview of the corporation.

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

b. The latest financial statements

i. Get the income statement, balance sheet, cash flow statement, and the statement of owners' equity for the past fiscal year. Do not forget to cite the source under each statement.

ii. If you cannot cut and paste them, you may have to type in the information in a table in your report.

c. A summary of each financial statement

i. 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."

d. Ratio calculation (include 5 major types of ratios. Refer to chapter 3, Analysis of Financial Statements)

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

ii. Present your results following the five types of ratios discussed in part d. Since the backbone of this paper is a rigorous financial analysis, you need to carefully analyze the company (compare to both past years looking for trends and to your benchmark company).

iii. A table with both corporation and industry ratios is required;

e. Discussion of key statistics provided by sources like Yahoo finance.

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

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

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

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

iv. You must address the question, "Is this forecast reasonable?"  Must you amend your analysis to get a more reasonable forecast? 

g. Other information pertinent to the corporation that could affect its future performance and stock price. 

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

h. Recommendation regarding the future of this corporation. 

i. Is the stock a good buy, average buy, or a poor buy (implying a good sell)? 

ii. Include a justification of your recommendation based on your analysis and research.

Attachment:- Research Paper Example.rar

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91994338

Have any Question?


Related Questions in Basic Finance

Question utilizing the concepts learned throughout the

Question: Utilizing the concepts learned throughout the course, write a Final Paper on one of the following scenarios: • Option One: You are a consultant with 10 years experience in the health care insurance industry. A ...

Discussion your initial discussion thread is due on day 3

Discussion: Your initial discussion thread is due on Day 3 (Thursday) and you have until Day 7 (Monday) to respond to your classmates. Your grade will reflect both the quality of your initial post and the depth of your r ...

Question financial ratios analysis and comparison

Question: Financial Ratios Analysis and Comparison Paper Prior to completing this assignment, review Chapter 10 and 12 in your course text. You are a mid-level manager in a health care organization and you have been aske ...

Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs $300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

You are planning to make annual deposits of 4440 into a

You are planning to make annual deposits of $4,440 into a retirement account that pays 9 percent interest compounded monthly. How large will your account balance be in 32 years?  (Do not round intermediate calculations a ...

One year ago you bought a put option on 125000 euros with

One year ago, you bought a put option on 125,000 euros with an expiration date of one year. You paid a premium on the put option of $.05 per unit. The exercise price was $1.36. Assume that one year ago, the spot rate of ...

Common stock versus warrant investment tom baldwin can

Common stock versus warrant investment Tom Baldwin can invest $6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for $30 per share. Its warrants, which provide f ...

Call optionnbspcarol krebs is considering buying 100 shares

Call option  Carol Krebs is considering buying 100 shares of Sooner Products, Inc., at $62 per share. Because she has read that the firm will probably soon receive certain large orders from abroad, she expects the price ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As