Financial Analysis Coca-Cola and PepsiCo Essay

We bring down out be comparing dickens companies some(prenominal) ar strong and have bang-up credibility. Ideally with a solid competitor we call for to show differentials and make a solid contrast. In this case we want to comp are at least two years of financial data. A great way to exemplify this is to compare Coke to Pepsi. To say which matchless is better to drink is debatable, but what we are tone at is which is better to invest in. We leave analyze the study provided in the appendixes and make a conscience decision as to which company is stronger, therefore a smarter investment choice. After all, I wouldnt want you to throw your money down the drain. The cardinal main characteristics used to determine a companys success are liquidity, solvency, and of course profit. The aspects, when analyzed, send packing help you decide which is to a greater extent successful and financially honored as a better investment.This can also help someone decide which is more successful and financially stable. While we look at these statements I would same(p) to keep in mind how sizeable it is to look at trend all everywhere time. This opens our next concept which is vertical and horizontal synopsis. By taking a step back and going all over the ratio digest which is composed of the three main characteristics, we are able to see what has happened during the time period we compare with. Hence us making our intelligent investment decision. Going back, ratio analysis is where we set out two numbers game in order to move a percentage which we will compare to the competitor. First characteristic is liquidity. This is where we see the company paying(a) their debts, and on time. This is very similar to an individual persons credit score. Are they paying their bills?This shows financial responsibility and that is a very important dowry in investments. The information is typically shown as a ratio or percentage of the liquid pluss. The superiorer the ratio the bigger the safety margin is in which the mess will fulfill their debts. You wouldnt rent a home to someone with bad credit. Nor would you loan someone money if they had a bad trend to not be responsible with money. Going back to business mind state, we can look at the potential dexterity to turn a good or service into profit. This is crucial to investing. Its also crucial to compare companies within the same industry. It seems logical initially but there are ratios and formulas that are used that operate most efficiently when comparison is done within similarities. So, lets get on with the fun stuff alreadyPepsiCos offset Sheet and Liquid Ratio(Remember, we are dividing the current asset with the liabilities for both years, not dividing the annual comparison. Meaning do not set apart the two numbers next to each other. This is the essential difference between horizontal and vertical analysis. ) Current ratio 2005=10,4549406=1.11Current ratio 2004= 86396752=1.28Just to make a qu ick observation before we move on the ratio of 2005 is 1.111 and in 2004 it is 1.281. We now have the ratios lets get the percentage of measure assets from silver and equivalents. Then we will do Coca-Colas and compare. Percentage of cash for 2005=1716 (cash and equiv)10454 ( contribute assets)= .1641 Percentage of cash for 2004=12808639= .1481Thats 16.41% for 2005 and 14.81% for 2004. This is solid statistic and I dont rightfully see much room for improvement based on the information found. It seems to be a solid bet, but we are far from done.Coca-Colas Balance Sheet and Liquid Ratio(Again, remember to divide the total asset with total liability.) Current ratio 2005=10,2509,836=1.042Current ratio 2004=12,28111,133=1.103So the ratio is 1.0421 for 2005 and 1.1031 for 2004. Dont feel discouraged, we will take this information and further discuss. I would like to mention that liability ratio lowering isnt a bad thing and can mean potential growth. That being said, I sense improvemen t. instanter that we have our ratio numbers for both companies and both years we will determine the percentage of total assets from cash and the equivalents. Now we will get the percentages of total assets and compare with PepsiCo. Percentage of cash for 2005=4701 (cash and equiv)29427(total assets)= .1598 Percentage of cash for 2004=670731441= .2133Thats 15.98% for 2005 and 21.33% for 2004. Im not sure about you, but if my percentage of cash went down 5.35% I would fret. Now, thats not to say I wouldnt invest just yet, but it does raise concern. Unless this cash is being used to pay off debts or re-invest into the company however, one should raise concern. Now that we have our calculations lets make our comparison. In 2004 PepsiCos ratio was 1.281 then in 2005 it was 1.111. Whereas Coca-Cola had 1.1031 for 2004 and 1.0421 in 2005. We can divide the total current assets and of the liabilities for the two years giving us the append or decrease for the same company. Simply divide th e total current asset or liabilities for the two different years. We can find the increase or decrease for asset or liabilities. This furthers our comparisons.Lets get back to solvency. It is a comparison of current assets and current liabilities. It is determined by dividing one with some other. This gives an investor a ratio, which is explained earlier, that provides the investor with good information. That being, how does the company do with long-term responsibility? Also how likely will it act in the future with obligations and goals? The lower the ratio is, the less likely they are to have the follow through we are looking for. A high ratio provides the investor with an imminent outlook on the corporation being free of debt and how the company chooses to re-invest its profit. Profitability can allow an investor to monitor the corporations ability to produce assets in comparison to the expenses they must(prenominal) pay off. To put it bluntly, if a company has a higher(prenomi nal) profit ratio or margin than another company than they are doing better. We can do the same thing with profit that we did with liquidity as far as percentages and ratios go.When looking at salary we must be sure to compare annually because many companies have a season where they are selling more product. What the intended affect would be is to get the average and avoid the fluke statistics. When investing, it is a good idea to take a good step back. Like looking through the window of a candy shop. One candy might look good but you take a step back you can admire the entire unwrap and see what is really going on. The big picture. Horizontal analysis can be utilized to provide the investor with the corporations financial data over a monthly or annual progression. It can be expressed using a balance sheet, an income statement, or retained earnings statement.When an investor evaluates the horizontal analysis they can determine the stability of the corporation, giving them solid in sight. First we will apply horizontal analysis to PepsiCos assets and liabilities. We start by dividing the difference of total current assets between 2004 and 2005. As I have provided the spreadsheet earlier with the information it wont be necessary to repeat. We are still dealing with those highlighted numbers this will make it easier to locate the correct statistics. 10454 assets of 2005 8639 (assets of 2004)8639 (assets of 2004) = .210 We can then turn this into percentage which would be 21% (technically 21.01%) total current asset increase from one year to the next. Now well do the same with liabilities. 9406 liabilties of 2005- 6752 (liabilties of 2004)6752 (liabilties 2004)= .393Lets do this in percentage form, 39.3%. Thats increase of liabilities during the time span of 2004 to 2005. By analyzing this information we are provided with the fact that there is an increase in current assets. This can be done by obtaining loans and gaining credibility as a corporation. On the di ffer here there is a possibility that debt has increased. Keep in mind that while numbers are increasing and numbers dont lie, its the person analyzing them that puts things in perspective. Lets make a comparison now with Coca-Cola. 10250 assets of 2005- 12281 (assets of 2005)31441 assets 2004= -.064 We made the horizontal analysis to see if Coca-Cola has gone through increase or decrease with assets and liabilities between the two years of information we were given.When we translate our answer from decimal to percentage we get -6.4% which is a decrease. Lets divide liabilities for Coca-Cola now. 9836 liabilities of 2005- 11133 (liabilities of 2004)11133 (liabilties of 2004)= -.116 This gives us -11.6% decrease in liabilities from 2004 to 2005. Translating that to English, this means that while assets were low it seems they were clearly paying off debts. This is a responsible and promising thing for a corporation to act on. A good investor will recognize debts being paid off and see that they are making profits and creating a solid buttocks for the future. By judging the companys percentage of growth we can easily separate the stronger competitor. Now, lets do PepsiCos vertical analysis. twelvemonth 2005=1716(cash and equiv)31727 (total asset)= .054Year 2004=1280 (cash and equiv)27987 total asset= .046In 2005 the percentage is 5.4% while in 2004 it was only 4.6%. Lets now figure out how much of the assets are currently in possession of the company, first with 2005. Oh, and imagine how nice it would be if we could do that with people weve loaned money to. Year 2005=10454 (current asset)31727 (total asset)= .3295Year 2004=8639 (current asset)27987 (total asset)= .3087So, we have 32.95% in 2005 and 30.87% in 2004. Meaning that PepsiCos assets in possession went up 2.08% in a year. Promising, right? Well, what about Coca-Colas? Year 2005=4701 (cash and equiv)29427 total asset= .160Year 2004=6707 (cash and equiv)31441 (total asset)=.213In 2005 the percentage is 16 % while in 2004 it was 21.3%. Interesting, huh? Lets figure out the assets Coca-Cola owned in possession. This is where investors ears perk up and we can get to some real solid numbers that will eventually define our final decision. Year 2005=10250 (current asset)29427 (total asset)= .348Year 2004=12281 (current asset)29427 (total asset)= .391In 2005 the percentage is 34.8% while in 2004 it was higher with a 39.1%. One can easily come to the conclusion that Coca-Cola may have fewer assets in possession, but keep debts in mind. Investors are looking for exactly this. Sure, they own less but they are also being financially responsible. In conclusion with all that has been said and analyzed I would like to conclude this intense and considerate examination. Many statistics were provided by the appendix and several calculations were made to come to a logical and sound conclusion. By viewing over the ratios and percentages we can determine that Coca-Cola is a stronger company. With the fa ct they do have low assets, we consider how many debts are being paid off due to the profits that are made. The CEO clearly had a strong head on their shoulders and even though these numbers are but six years old, I can only imagine their consistence has stayed the same. Reason being, the corporation has remained out of debts and re-invested their profits into future proceedings which allow a positive outlook for investors.ResourcesHill, M.G (2009). financial Accounting