Xacc 280 Week 7 Checkpoint

In: Business and Management

Submitted By wroldan
Words 450
Pages 2
Wilson Roldan
Week 7
Checkpoint
PepsiCo.
Appendix A:
Current ratio for 2005:
$10,454 (Current Assets)
$ 9,406 (Current Liabilities) $10,454 divided by $9,406 is equaled to 1.11%
Current ratio for 2004:
$8,639 (Current Assets)
$6,752 (Current Liabilities) $8,639 divided by $6,752 is equaled to 1.28%
Vertical analysis for 2005:
Current Assets divided by Total Assets 10,454 / 31,727 = .3294 or 32.9%
Vertical analysis for 2004:
Current Assets divided by Total Assets 8,639 / 27,987 = .3086 or 30.9%
Horizontal analysis:
Current Assets 2005 divided by Current Assets 2004 10,454 / 8,639 = 1.21 or 21%
Current Liabilities 2005 divided by Current Liabilities 2004 9,406 / 6,752 = 1.39 or 39%
These analysis shows that the PepsiCo has had an increase in assets by 21% from one year to the next, with an increase in liabilities of 39%. This is a result of the company obtaining more liabilities.

Appendix B:
Current Ratio for 2005:
$10,250 (Current Assets)
$ 9,836 (Current Liabilities) $10,250 divided by $9,836 is equaled to 1.04%
Current Ratio for 2004:
$12,281 (Current Assets)
$11,133 (Current Liabilities) $12,281 divided by $11,133 is equaled to 1.10%
Vertical analysis for 2005:
Current Assets divided by Total Assets 10,250 / 29,427 = .348 or 34.8%
Vertical analysis for 2004:
Current Assets divided by Total Assets 12,281 / 31,441 = .3906 or 39.1%
Horizontal analysis:
Current Assets 2005 divided by Current Assets 2004 10,250 / 12,281 = .8346 or 83.5%
Current Liabilities 2005 divided by Current Liabilities 2004 9,836 / 11,133 = .8834 or 88.3%
These analysis shows that the Coca Cola Company and Subsidiaries has had a decrease in assets by 83.5% from one year to the next, with a decrease in liabilities of 88.3%. This is a result of the company decreasing liabilities.
The three tools of financial statements analysis are…...

Similar Documents

Xacc/280 Week 1

...Week 1 Check point 2 There are three basic elements to an accounting equation and they are Assets, Liabilities, and Owners Equity. You simply need to remember A=L+OE (ALOE) for short. The first element is Assets and they are all the things that basically make up the business. The text reads that assets may include the following cash, property, plant, and equipment. The next element is Liabilities and liabilities are when you borrow money (loan), when you get something financed for example the purchase of a car. The last and final element is called the Owners (Shareholders) Equity. The Owners Equity is basically the money that is left after paying all of that companies bills, for example the employees’ wages, their electric bill, and mortgage/lease for their building etc. If the company is incorporated they can sell stock to people and that person would own small part of the business. If the company is private then that is when you would call this category Owners Equity. Financial Accounting Accounts Payable, this is a liability, because this is a financial obligation of the business. Cash, is an asset, this is the thing that makes up a business. Cleaning equipment, is an asset, this is what’s in the building. Cleaning supplies, is an asset, this is what’s in the building. Accounts receivable, Stockholders, this is money/assets left after owners pay their financial obligations. Notes Payable. Is a liability, this is the financial obligation of the business. Salaries......

Words: 268 - Pages: 2

Xacc/280 Week 8 Internal Controls

...INTERNAL CONTROLS JANINE LEWIS XACC/280 DECEMBER 8, 2013 JOSE RODRIGUEZ INTERNAL CONTROLS Internal controls are methods that companies put in place to protect themselves from errors, internal fraud or corruption. The methods consist of review, checks and balances, and procedures that make sure a company’s business is being conducted orderly and efficiently. They also ensure that the policies and procedures that are put in place are being adhered to. Internal controls are necessary for many reasons; however there are two primary goals. One is to protect the company and prevent theft, errors, fraud, and unauthorized use of resources and assets. The other is to detect and quickly reconcile any errors that may occur, and ensure that accounting and financial data is accurate and reliable. The Sarbanes-Oxley Act of 2002 was put in place as a result of the many corporate scandals that has happened. Under this act, companies are required to have an internal control system in place. If a random or scheduled audit discovers a company does not, they are subject to fines and possible jail time. SOX have affected internal controls in several different ways. In one way, it keeps a continuous watch over a company’s internal control system to ensure that the current methods continue to be reliable and effective. For example, over time, a company may change its computer system, its reporting method, or other ways pertaining to their...

Words: 1103 - Pages: 5

Xacc/280 - Week 8 - Internal Controls

...Internal Controls <Name> XACC/280 <Date> <Instructor> Internal Controls (a) Indicate the weaknesses in internal accounting control over the handling of collections. There are many weaknesses in the current process in which the church collects, documents, and secures the weekly collections. The first problem is that the finance committee, who prepares the annual budget and approves major disbursements, are not involved with the collection and record keeping process. How can a group which has that much power not be involved in the collection and security of such an important asset of the church which is the cash? Next, no internal audit of the finances has been done in 15 years because they trust the financial secretary who has been in the position for 15 years. Regardless of how long a person has been in charge of the collections, bad things happen to good people all of the time. And if this trusted person did mishandle the church funds, the church has no fidelity insurance to protect them from any losses. There are also problems with the collection process itself. Once collected, the ushers take it to the basement of the church where it is left with one person, the head usher, who counts the money alone, documents the amount, and places the collection in the safe. The head usher position is a three month volunteer position. The church is putting too much trust in these individuals. They are counting the money alone and they access to the safe...

Words: 740 - Pages: 3

Week 8 Checkpoint 1 Xacc/280

...CheckPoint Impacts of Unethical Behavior XACC/280 March 11, 2014 The company that I chose to research is Tyco International. Tyco International was involved in an unethical behavior many years ago. Suspicions came up about there being some wrongdoings being done in the accounting department, and there was. At this point an investigation began; after a few years of investigation, in 2002 it was announced that Dennis Kozlowski (Tyco’s former CEO) , Mark Swartz (Tyco’s former CFO), and Mark Belnick (Tyco’s chief legal officer )had taken a total of over $170 million in unauthorized loans from Tyco for their personal uses. These unauthorized loans were all noted as bonuses which the three men seemed to think that no one would ever notice this suspicious activity. If I had been an accountant for this company, I would have reported to whomever I would have had to about my suspicions as soon as I noticed that something indeed was not right about the numbers, because when it comes to business and in life in general I am all about being ethical and doing the right thing. I believe that the criminals in this scandal got the charges that they deserved overall. I am not sure if anything could have really been done to prevent this tragic scandal, but I would just give the company the advice to keep tabs on all of their employees including CEOs and the men and women who may be higher up in the company. I’m sure that this was done on computers so; I would say that keeping tabs on......

Words: 310 - Pages: 2

Week 7 Checkpoint Xacc 280

...Checkpoint: Ratio, Vertical, and Horizontal Analysis The current ratio shows the percentage of liabilities there is compared to the assets. It is the total current assets divided by the total current liabilities. The vertical analysis is the current assets divided by the total assets for that year. The result is shown in percentage. The horizontal analysis is the change in assets. The current assets of one year divided by another year will show the increase or decrease in assets for those years. The same thing applies to the liabilities. Each year’s current liabilities will be identified. The most recent year will be divided by the previous year. The result will show the increase or decrease in liabilities by percentage. PepsiCo, Incorporated Current ratio 2005: Current ratio 2004: Current assets = 10454 = 1.11% Current assets = 8639 = 1.28% Current liabilities 9406 Current liabilities 6752 Vertical Analysis 2005 Vertical Analysis 2004 Current assets = 10454 = 33% Current assets = 8639 = 31% Total assets 31727 Total assets 27987 Horizontal Analysis Total assets 2005 = 31727-27987= 3740 = 0.1336 = 13.4% Total assets 2004 27987 Total liabilities 2005 = 17476-14464 = 3012 = 0.2082 = 20.8% Total liabilities 2004 14464...

Words: 320 - Pages: 2

Xacc/290 Week 7

...Cost of Goods XACC/290 Cost of Goods The cost of goods sold is a category of expense for merchandising organizations. It is defined as the total amount of merchandise sold during an accounting period (Kimmel, Weygandt, & Kieso, 2011). To calculate the cost of goods sold, it would depend on which type of system the merchandising company is using. If they are using a perpetual system, which means that the organization uses daily detailed entries for the cost of their inventory’s purchase and sale, they would be journalizing each selling price of merchandise (Kimmel, Weygandt, & Kieso, 2011). For example, for inventory sold, an accountant would debit Accounts Receivable or Cash and Sales Revenue is credited for that merchandise’s selling total price (Kimmel, Weygandt, & Kieso, 2011). Subsequently, the accountant would also debit the Cost of Goods Sold and credit Inventory for the cost of that merchandise sold. The second system that can be used by a merchandising company would be the periodic system. In a periodic system, the organization does not keep a daily, detailed inventory record. They instead calculate the cost of goods sold at the end of their accounting period. To determine the cost of goods sold they use the equation – beginning inventory plus the cost of goods equals the cost of goods available for sale (Kimmel, Weygandt, & Kieso, 2011). They then take this total and minus it from their ending inventory. This will give the......

Words: 319 - Pages: 2

Xacc 280 Week 8 Assignment Internal Controls

...This archive file of XACC 280 Week 7 CheckPoint - Ratio, Vertical, and Horizontal Analyses shows the solutions to the following problems: The Calculations you perform for this CheckPoint form the basis of your analysis of your capstone project. Business - Accounting The calculations you perform for this CheckPoint form the basis of your analysis of your capstone project.   Write in 100 to 200 words an explanation of the three tools of financial statement analysis and the function of each.   Examine PepsiCo, Inc.’s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting , especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.   Calculate the following for PepsiCo, Inc. and show your work:   ·  The Current Ratio for 2005 ·  The Current Ratio for 2004 ·  Two measures of vertical analysis—for example, compute the current assets divided by total assets for each year, and express your result as a percentage ·  Two measures of horizontal analysis—for example, compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities   Examine TheCoca-Cola Company’s Consolidated Balance sheet on p. B2 in Appendix B of Financial Accounting , especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004. ......

Words: 330 - Pages: 2

Xacc/280

...Checkpoint Accounting Assumptions Principles, And Constraints Diana Michalak XACC/280 Sara Carpenter August 5, 2011 The basic assumptions of accounting consist of four assumptions. Monetary Unit Assumption, which states that “only transaction data that can be expressed in terms of money be included in the accounting records(Ch 7.).” Economic Entity Assumption, which states that “the activities of the entity be kept separate and distinct from the activities of the owner and of all other economic entities. (Ch 7)” The Time Period Assumption which is an assumption that “the economic life of a business can be divided into artificial time periods (Ch 7).” The Going Concern Assumption which states that “the company will continue in operation long enough to carry out it’s existing objectives (Ch 7.).” The Principles of accounting consist of 4 principles. The first principal is The Revenue Recognitions Principle. This principle “dedicates that companies should recognize revenue in the accounting period which it is earned (Ch 7).” The second one is The Matching Principle which dedicates “that companies match expenses with revenues in the period in which efforts are made to generate revenues (Ch 7).” The third is the Full Discloser Principle which requires that companies disclose certain circumstances and events that make a difference to financial statement users (Ch 7).” The fourth one is the Cost Principle which “dedicates that companies record assets at their......

Words: 322 - Pages: 2

Xacc 280 Week 7 Assignment Ratio, Vertical, and Horizontal Analyses

...XACC 280 Week 7 Assignment Ratio, Vertical, and Horizontal Analyses To Buy This material Click below link http://www.uoptutors.com/XACC-280/XACC-280-Week-7-Assignment-Ratio-Vertical-and-Horizontal-Analyses Write in 125 to 250 words an explanation of the three tools of financial statement analysis and the function of each. Examine PepsiCo, Inc.’s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004. Calculate the following for PepsiCo, Inc. and show your work: ·         The Current Ratio for 2005 ·         The Current Ratio for 2004 ·         Two measures of vertical analysis—for example, compute the current assets divided by total assets for each year, and express your result as a percentage ·         Two measures of horizontal analysis—for example, compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities Examine The Coca-Cola Company’s Consolidated Balance sheet on p. B2 in Appendix B of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004. Calculate the following for Coca-Cola and show your work: ·         The Current Ratio for 2005 ·         The Current Ratio for 2004 ·         Two measures of vertical analysis—for example, compute the current assets divided by......

Words: 287 - Pages: 2

Week 8 Assignment Xacc 280

...Internal Controls xxxxxx Accounting 280 April 8, 2012 xxxxxxxx Internal controls ensure that all public companies follow a standard set of rules to operate and report finances in business. It is required by law to monitor the different models of internal controls. According to Renee O'Farrell (2012), "'internal controls' can be defined as actions and procedures by which a company monitors itself". The two primary goals of internal controls are to safeguard assets from theft and unauthorized use, and to enhance the accuracy and reliability of company accounting records to avoid errors and irregularities in the accounting process. The establishment of responsibility, the use of physical, mechanical, and electronic controls, the segregation of duties, and the independent internal verification are internal control principles. Establishing responsibility is necessary to hold all employees responsible for the records reported. If a company successfully reports records inaccurately, the scandals that occurred in the early 2000s could be repeated. By holding employees, management, the board of directors, and auditors responsible, it helps control that documents and records are truthful when reported. This allows the shareholders' of the company to make the best financial decisions with the information given (Internal Control", 2012). The physical control of the company is established as a safeguard for records. This includes physical safeguards and IT Security...

Words: 941 - Pages: 4

Xacc 280 Week 7 Checkpoint

...If I were an accountant two business sectors that I would be interested in would be in management accounting or forensic accounting. Management accounting is being available to management within companies to provide them with information that will overall help them manage and control the business more efficiently. Business recovery is helping businesses in financial distress to recover financially. While I am not interested in the accounting field, these were two sections that really caught my eye. I currently run three Subway stores as a General Manager, so the management accounting is a sector that I know from experience would be very helpful to a business. Personal experience is what would peak my interest into this field. Forensic accounting is investigative accounting or auditing that is suitable for a court of law. Law has always been a big interest for me. I think that auditing and investigation would be a very interesting and fulfilling job. The company that I chose and researched was Feely and Driscoll. This is a company that provides forensic accounting and auditing services. I imagine that working for this company would be very interesting. I imagine that as a CPA I would be handed files and company information that I would have to audit to look for fraud or other issues. There may also be cases of profit analysis. Once the investigations are complete, I imagine that compiling the information suitable for court would be very tedious and time consuming. However...

Words: 273 - Pages: 2

Xacc/280 Week 5

...Accounting Assumptions, Principles, and Constraints Hcemac XACC/280   ·         There are three major guidelines that are used in the conceptual framework of accounting also known as assumptions, principles, and constraints. Assumptions provide a foundation for the accounting process (Weygandt, Kimmel & Kieso, 2008, p. 297).These include monetary unit assumption which states that only monetary data can be reported, economic entity assumption which states that entities such as the owner’s personal finances and the business must be reported separately and the same rule applies to more than one enterprise, the time period assumption states that a businesses economic life can be divided into time periods such as monthly, quarterly, or annually, and going concern assumption works on the basis that a company will operate long enough to complete its given objectives (Weygandt, Kimmel & Kieso, 2008) . The basic principles of accounting include revenue recognition which states that organizations should recognize revenue with-in the time period that it is earned. The matching principle state that expenses should be match to revenue in the time frame in which effort were made to generate the revenue. The full disclosure principle requires organizations to disclose pertinent information from financial statements to users (including investors) and the cost principle states the organizations must record assts...

Words: 390 - Pages: 2

Xacc 280 Week 5 Cp

...Running Head: Reversing Entries CheckPoint: Reversing Entries XACC280 Week 5 Writer’s Name Course Name, Semester No, Class Level Supervisor Name February 10, 2010 ANSWER KEY BE4-12  At October 31, Nathan Company made an accrued expense adjusting entry of $1,400 for salaries. Prepare the reversing entry on November 1, and indicate the balances in Salaries Payable and Salaries Expense after posting the reversing entry. Nov. 1 Salaries Payable .......................................................... 1,400 Salaries Expense ................................................. 1,400 The balances after posting the reversing entry are Salaries Expense (Cr.) $1,400 and Salaries Payable $0. What do you consider might happen if: 1. Revenue accounts are not closed? Explain why. At the end of the accounting period, closing entries are made to prepare the accounts for the next accounting period. During this step, Temporary Accounts (All Income Statement Accounts as well as the Dividend Account) are closed. Therefore if the Revenue account is not closed, the company’s net income will be overstated for the next accounting period which would give an incorrect picture of the company’s operations in the period under examination. 2. Expense accounts are not closed? Explain why. The same logic applies as in number 1 above; only in this case expenses for the next accounting period would be overstated and net income would......

Words: 316 - Pages: 2

Xacc 280 Week 7 Checkpoint

...Wilson Roldan Week 7 Checkpoint PepsiCo. Appendix A: Current ratio for 2005: $10,454 (Current Assets) $ 9,406 (Current Liabilities) $10,454 divided by $9,406 is equaled to 1.11% Current ratio for 2004: $8,639 (Current Assets) $6,752 (Current Liabilities) $8,639 divided by $6,752 is equaled to 1.28% Vertical analysis for 2005: Current Assets divided by Total Assets 10,454 / 31,727 = .3294 or 32.9% Vertical analysis for 2004: Current Assets divided by Total Assets 8,639 / 27,987 = .3086 or 30.9% Horizontal analysis: Current Assets 2005 divided by Current Assets 2004 10,454 / 8,639 = 1.21 or 21% Current Liabilities 2005 divided by Current Liabilities 2004 9,406 / 6,752 = 1.39 or 39% These analysis shows that the PepsiCo has had an increase in assets by 21% from one year to the next, with an increase in liabilities of 39%. This is a result of the company obtaining more liabilities. Appendix B: Current Ratio for 2005: $10,250 (Current Assets) $ 9,836 (Current Liabilities) $10,250 divided by $9,836 is equaled to 1.04% Current Ratio for 2004: $12,281 (Current Assets) $11,133 (Current Liabilities) $12,281 divided by $11,133 is equaled to 1.10% Vertical analysis for 2005: Current Assets divided by Total Assets 10,250 / 29,427 = .348 or 34.8% Vertical analysis for 2004: Current Assets divided by Total Assets 12,281 / 31,441 = .3906 or 39.1% Horizontal analysis: Current Assets 2005 divided by Current Assets 2004 10,250 / 12,281...

Words: 450 - Pages: 2

Xacc 280 Week 1 Checkpoint

...There are four basic assumptions in financial accounting. The first is the monetary unit assumption which states that a company can only report transaction information in financial records that can be expressed in a monetary amount. The next assumption is the economic entity assumption. This assumption states that the company’s financial information and activities need to be recorded separate from the owners and other entities. Next, the time period assumption tells companies to divide the economic life of their business into artificial time periods. And last, the going concern assumptions is an assumption that a company will stay afloat long enough to carry out all existing objectives (Weygandt, Kimmel, Kieso, 2008). Financial accounting also consists of 4 principles; revenue recognition, matching, full disclosure, and the cost principle. These principles are “rules” of sorts that accounting must follow in their records. They state that companies should recognize their revenue during the time period that it was earned, they must match their expenses with their revenues during the period in which the effort to generate the revenue was made, they must disclose any circumstance or events that would make a difference to those using the reports, and they must record their assets at the price that it cost them (Weygandt, Kimmel, Kieso, 2008). There are also constraints that allow the company some leeway with the principles as long as it does not affect the usefulness of the...

Words: 399 - Pages: 2