Question

In: Accounting

After identifying 2 competing public companies you will do research to obtain the necessary financial statements...

After identifying 2 competing public companies you will do research to obtain the necessary financial statements (2 years) on each firm.

Most important is your “personal assessment” of what you found / learned about the two companies.

Required preparation and analysis:
A.         Common Size Statements and Analysis - Vertical and Horizontal Analysis

B.         Ratio Analysis and Analysis - Commentary based upon
            Liquidity, Solvency, Efficiency, Profitability, Market, Financial Leverage, and Coverage.           

C.        A DuPont analysis that compares the 3 DuPont identities (ratios) as a trend or as a comparison to your
            competitor – industry. This will be reviewed in class.

Solutions

Expert Solution

Vertical and Horizontal Analysis.

such types of analysis involves compare the profit statement/ income statement to each other in rupees and dollars and in %.

If we wants to do some some ratio analysis the best way is to do vertical and horizontal analysis.

horizontal analysis and vertical is good for internal and external stakeholder.learning of horizontal and vertical is useful for managerial accounting and other purposes.if such types of analysis founds any unexpected changes in income statement then accounting staff should find the reasons and take action on time.such types of analysis is also used for balance sheet.

Horizontal analysis.

income statement of xyz analysis. 2008 2009 changes

Sales $ 10000 $ 9200 - 8%

cost of goods sold. $ 5500 $ 5390 - 2%

Gross profit $ 4500. $ 3810 - 0.15%

wages $ 700 $ 679 -3 %

rent $ 500 $ 450 - 10%

other expenses $ 2000 $ 2100 5%

* income $ 1300 $ 581 - 44.69%

Horizontal analysis compares balances and ratio over different periods.

we compare company s sales in 2008 to 2009.

from above we can say that net income drop to 44.69% as compared to 2008 sales

wages declined by 3 % also the sales declined by 8 &.

on the other side the sales decline was $ 800.and declined the sales has huge impact on net income.

vertical analysis.

such types of analysis gives the company so much problem if cost of goods and any other expenses is too big compared to sales.

The following is example of such vertical analysis.

XYZ comapny

Particulars 2008 2009

Sales $ 1000 100% $ 750 100%

cost of goods sold $ 520 52% $ 405 54%

Gross profit $ 480 48% $ 345 46%

Wages $ 300 30% $ 217.5 29%

Rent $ 20 2 % $ 22.5 3 %

Other expenses. $ 100 10 % $ 60 8 %

Net income $ 80 $ 8% $ 45 6 %

From above analysis we can conclude that there is declined of income by 2 % as compared to sales.

Commentary based upon.

Financial leverage analysis:

such types of leverage ratio is very good for company that gives company rely on equity and debt to finance their operation and also know about debt held by company that is useful in evaluation of whether it can pay its debt.also assesses the ability of company to meets the financial duties.

Liquidity ratio:

liquidity ratio also helps the company to ability to pay debt obligation and its profit level through the calculation of current ration and quick ratio .

liquidity ratio are financial metrics used to determined ability to pay off current debt obligation.

Solvency ratio:

how to calculate such types of ratio

Net income +depriciation/short time liabilities +long term liabilities .

note: net income shall be after tax.

Efficiency ratio:

Efficiency ration shall calculated on the basis of turnover of receivables,repayment of liabilities,and use of inventory and machinery.the ratio can also used to track and analyze the performance of commercial society and banks.efficiency ratio also used to analyze how well the company uses its assets and liabilities.

profitability ratio:

so much of this types of ratio having higher value relatives to the same ratio from a previous period indicates that the company is doing good. The ratio also used to asses a business ability.

Leverage ratio:

The ratio is financial measurements that look capital flow in the form of loans.and also assess ability of person to meets all financial obligation.The leverage ratio is important to company that rely of mixture of debt and equity.


Related Solutions

Select two public companies in the same industry, obtain their most recent published financial statements, and...
Select two public companies in the same industry, obtain their most recent published financial statements, and perform financial ratio analysis for both. Write a report to summarize your findings and conclusion. Your report should include: Balance sheet ratio analysis Income statement ratio analysis Statement of cash flow ratio analysis Credit rating of both companies by Standard & Poor’s and Moody’s Ratio comparative analysis Clear conclusion and opinion about which company you prefer to invest in, and why.
Research two (2) publically traded U.S. companies, and download their financial statements. Assume that you are...
Research two (2) publically traded U.S. companies, and download their financial statements. Assume that you are the CEO of one of the selected companies. You are responsible for gaining control over the other company. You have three (3) choices, either of which you believe that the Board of Directors will support. Choice 1: Your company acquires 35% of the voting stock of the target company. Choice 2: Your company acquires 51% of the voting stock of the target company. Choice...
You are a financial analyst and are comparing financial ratios of two competing companies in the...
You are a financial analyst and are comparing financial ratios of two competing companies in the consumer packaged goods sector: Kellogg’s company and General Mills. The 2018 turnover ratios for the two companies are summarized in the following table:                   K                 G Days sales outstanding 37.24 36.11 Days inventory outstanding 52.72 55.32 Days payable outstanding 97.16 86.11 By comparison, which company has better cash conversion cycle? What conclusions do you get regarding the two companies’ management in accounts receivable,...
Summary information from the financial statements of two companies competing in the same industry follows.   ...
Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense 7,900 13,000 Merchandise inventory 84,440 132,500 Income tax expense 14,800 24,300 Prepaid expenses 5,000 6,950 Net income 162,200...
Assignment 2: Choose TWO public listed companies of Bursa Malaysia and access their financial statements for...
Assignment 2: Choose TWO public listed companies of Bursa Malaysia and access their financial statements for the year ended 2019. 1. Write the introduction of the selected companies. 2. Discuss the disclosure of the capital structure of both companies in their financial statements. 3. Analyse how the capital structure affects the performance of both companies. 4. Write a summary of the assignment.
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Benatar and Jett, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) Benatar Jett Assets: Cash $ 18,143 $ 12,398 Short-term investments 6,390 12,646 Accounts receivable (net) 9,184 11,385 Inventory 6,016 10,135 Other current assets 6,100 5,965 Current assets 45,833 52,529 Property, plant, and equipment (net) 16,254 24,695 Intangibles and other assets 20,030 73,355 Total...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 810,000 $ 923,200 Cash $ 20,000 $ 35,000 Cost of goods sold 589,100 636,500 Accounts receivable, net 35,400 51,400 Interest expense 9,300 11,000 Current notes receivable (trade) 9,000 8,400 Income tax expense 15,569 25,487 Merchandise inventory 84,940 140,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 790,000 $ 927,200 Cash $ 18,500 $ 37,000 Cost of goods sold 588,100 642,500 Accounts receivable, net 36,400 59,400 Interest expense 8,200 16,000 Current notes receivable (trade) 10,000 7,800 Income tax expense 15,185 25,597 Merchandise inventory 84,340 140,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 800,000 $ 926,200 Cash $ 18,500 $ 34,000 Cost of goods sold 594,100 642,500 Accounts receivable, net 39,400 53,400 Interest expense 8,400 15,000 Current notes receivable (trade) 9,700 7,400 Income tax expense 15,377 25,570 Merchandise inventory 84,540 134,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 780,000 $ 919,200 Cash $ 21,000 $ 37,000 Cost of goods sold 588,100 642,500 Accounts receivable, net 39,400 54,400 Interest expense 8,100 19,000 Current notes receivable (trade) 9,200 7,200 Income tax expense 14,992 25,376 Merchandise inventory 84,340 132,500 Net income...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT