Question

In: Accounting

Financial statement analysis is the process of analyzing a company's financial statements to make better economic...

Financial statement analysis is the process of analyzing a company's financial statements to make better economic decisions. The process for financial statement analysis includes specific techniques for evaluating risks, performance, and future prospects of an organization.

Directions

This Assessment is separated into four parts. In Part 1 of this Assessment, you will begin by researching and summarizing four of the benefits of financial analysis and indicating which is the most significant to you. In Part 2 of this Assessment, you will define the ratios listed. In Part 3 of this Assessment, you will classify, calculate, and explain the significance of Liquidity, Profitability, and Market Value financial ratios, and provide a year to year comparison of assessed financial trends. In Part 4 of this Assessment, you will compose an analytical essay in a minimum of 350 words reporting the one financial measurement trend you find to be most significant and actions necessary to improve results.

Use this Word template provided to complete your Assessment.

Questions

Part 1.

Locate and read the following article located from the Library:

Faello, J. (2015). Understanding the limitations of financial ratios. Academy of Accounting & Financial Studies Journal, 19(3), 75–85.

Refer to pages 75 and 76 of Faello’s (2015) work. In four separate paragraphs (one for each question), summarize four of the benefits of financial analysis mentioned in the journal article. In one paragraph, describe which one of the four benefits you consider to be most significant.

Review the following financial data, and then answer the questions below.

Company X Income Statement

FYE 2014 and 2015

Period Ending

31-Jan-15

31-Jan-14

Total Sales

$ 485,651,000

$ 476,294,000

Cost of Goods

365,086,000

358,069,000

Gross Profit

120,565,000

118,225,000

Selling General and Administrative

93,418,000

91,353,000

Operating Profit

27,147,000

26,872,000

Total Other Income/Expenses Net

113,000

119,000

Earnings Before Interest And Taxes

27,034,000

26,753,000

Interest Expense

2,461,000

2,335,000

Income Before Tax

24,573,000

24,418,000

Income Tax Expense

7,985,000

8,105,000

Net Income From Continuing Ops

16,588,000

16,313,000

Discontinued Operations

285,000

144,000

Net Income (Net Profit)

$   16,303,000

$   16,169,000

14,000,000 shares outstanding

Market Share price per share

$10.00

$9.00

Company X Balance Sheet

FYE 2014 and 2015

Period Ending

31-Jan-15

31-Jan-14

Assets

Current Assets

Cash and Cash Equivalents

$9,135,000

$7,281,000

Net Receivables

6,778,000

6,677,000

Inventory

45,141,000

44,858,000

Other Current Assets

2,224,000

2,369,000

Total Current Assets

63,278,000

61,185,000

Property Plant and Equipment

116,655,000

117,907,000

Goodwill

18,102,000

19,510,000

Other Assets

5,671,000

6,149,000

Total Assets

203,706,000

204,751,000

Liabilities

Current Liabilities

Accounts Payable

58,583,000

57,174,000

Short/Current Long Term Debt

6,689,000

12,082,000

Other Current Liabilities

-

89,000

Total Current Liabilities

65,272,000

69,345,000

Long Term Debt

43,692,000

44,559,000

Deferred Long Term Liability Charges

8,805,000

8,017,000

Minority Interest

4,543,000

5,084,000

Total Liabilities

122,312,000

127,005,000

Miscellaneous Stocks Options Warrants

0

0

Common Stock

323,000

323,000

Retained Earnings

85,777,000

76,566,000

Capital Surplus

2,462,000

2,362,000

Other Stockholders Equity

-7,168,000

-1,505,000

Total Stockholders’ Equity

81,394,000

77,746,000

Total Liabilities + Stockholders’ Equity

$ 203,706,000

$ 204,751,000

Number of Shares Outstanding

14,000,000

14,000,000

Market Share price per share

$10.00

$9.00

Part 2.

Define the ten financial ratios below.

Financial Ratios:

Financial Ratios:

Current Ratio is equal to Current assets / Current Liability

2014: 61,185,000 / 69,345,000 = 96.95%

Quick Ratio) (Cash and cash equivalents + Current receivable) / Current Liability

2014: 7,281,000 + 6,677,000 / 69,345,000 = 20.13%

2015: 9,135,000 = 6,778,000 / 65,272,000 = 24.38%

Accounts Receivable Turns) Net Credit Sales / Average Accounts Receivable

485651000 / 6,727,500 = 72.19

Accounts Payable Turns

Return on Equity) Net Income / Shareholder’s equity

16,303,000/81,394,000 = 20.03%

Return on Assets

Operating Profit Margin

Net Profit (after tax) Margin

Earnings per Share

Price to Earnings

Solutions

Expert Solution

2015 2014
1 Return on assets = net income / total assets
Net income 16303000 16169000
Total assets 203706000 204751000
Return on assets 8.0% 7.9%
2 Operating Profit margin = Operating profit / net sales
Operating profit 27147000 26872000
Net sales 485651000 476294000
Operating profit margin 5.6% 5.6%
3 Profit margin = net income / net sales
Net income (after tax) 16588000 16313000
Net sales 485651000 476294000
Profit margin 3.4% 3.4%
4 Net income 16303000 16169000
Loss on discontinued operations 285000 144000
Net income from continued operations 16588000 16313000
Number of shares 14000000 14000000
Earning per share = 2,890,000 / 1,477,158 1.18 1.17
5 Price to earnings ratio = Price per share / Earning per share
Price per share 10 9
Earning per share 1.18 1.17
Price to earning ratio 8.44 7.72

Related Solutions

Financial Statement Analysis The financial statements of Gelato Corporation show the following information: Statement of Financial...
Financial Statement Analysis The financial statements of Gelato Corporation show the following information: Statement of Financial Position December 31, 2020 Assets 2020 2019 Cash $257,000 $263,000 Accounts receivable 128,000 163,000 Fair value through net income investments 120,000 119,000 Inventory 320,000 361,000 Plant assets (net) 398,000 418,500 Intangible assets 102,000 128,500 Total Assets $1,325,000 $1,453,000 Liabilities and Equity Accounts payable $240,000 $303,500 Long-term debt 60,000 137,500 Share capital 293,000 293,000 Retained earnings 732,000 719,000 Total Liabilities and equity $1,325,000 $ 1,453,000...
Ratio analysis is an important analytical tool to use when analyzing the financial statements and there...
Ratio analysis is an important analytical tool to use when analyzing the financial statements and there are a lot of ratios when it comes to this type of analysis. You need to understand each one in order to make better decisions about the business and evaluate its overall financial health. If you were analyzing a business and they had: A current ratio of 1.4 Debt ratio of .8 Number of days’ sales in inventory of 20 Return on equity of...
Explain the role of ratio analysis in analyzing and interpreting a firm's financial statement with suitable...
Explain the role of ratio analysis in analyzing and interpreting a firm's financial statement with suitable examples. Consider an appropriate example in your analysis. simple & not too long answer
With a Microsoft's financial statement (any sources are accept!) please make Financial analysis with ·      Trend analysis...
With a Microsoft's financial statement (any sources are accept!) please make Financial analysis with ·      Trend analysis ·      Common size analysis ·      Ratio analysis ·      Dupond analysis (long-answer)
Financial statement analysis is an integral part of business analysis. In addition, explain why financial statements...
Financial statement analysis is an integral part of business analysis. In addition, explain why financial statements are important to the decision-making process in financial analysis. Also, identify and discuss some of their limitations for analysis purposes.
Income Statement The goal of a business is to make a profit. Financial statements such as...
Income Statement The goal of a business is to make a profit. Financial statements such as income statements and balance sheets report how successful a business has been in achieving this goal. 1.    Use spreadsheet software to create an income statement for Sweet Treats using the data shown below step 8. Format the income statement similar to the one shown in Figure 1-2.2. Use appropriate number formats and rules under numbers as shown in Figure 1-2.2. 2.    Enter the appropriate...
How financial analysts classify the ratios used during an analysis of a company's financial statements. What...
How financial analysts classify the ratios used during an analysis of a company's financial statements. What does each type of ratio tell us and provide a single example of each and why it is classified in that manner.
The Scope and Environment of Financial Management Financial Statements and Financial Statement Analysis Directions: Look for...
The Scope and Environment of Financial Management Financial Statements and Financial Statement Analysis Directions: Look for a company that is publicly listed in Bahrain Bourse. Secure a copy of their Financial Report (Latest). Please do not forget to attach the copy of the financial statements (Income Statement, Balance Sheet). Using the Financial Report, provide the following ; Requirements; Compute and provide the general interpretation for the following Financial Ratio; Current Ratio Quick Ratio Average Collection Period Debt Ratio Net Profit...
In analysis of current assets on a company's financial statements, we often focus on the turnover...
In analysis of current assets on a company's financial statements, we often focus on the turnover of recievables, inventory, and accounts payable as a measure of the financial health of a business. explain how these calculations can help identify favourable or disturbing trends.
The controller of the Red Wing Corporation is in the process of preparing the company's 2021 financial statements
The controller of the Red Wing Corporation is in the process of preparing the company's 2021 financial statements. She is trying to determine the correct balance of cash and cash equivalents to be reported as a current asset in the balance sheet. The following items are being considered: a. Balances in the company's accounts at the First National Bank, checking $15,000, savings $23,600. b. Undeposited customer checks of $6,700. c. Currency and coins on hand of $730. d. Savings account at the East Bay...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT