The purpose of this assignment is to calculate asset ratios, analyze them, and compare them between two competitors in the same industry.
Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories.
Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel:
Inventory turnover
Average days in inventory
In a Word file, include the following:
Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio.
Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet.
Submit the Excel file that contains your ratios and the Word file memo to your instructor.
1. (Endowment Economies) When will countries trade? Assuming 2 goods, food and clothing, and two countries with homothetic preferences, determine whether these two countries will trade in each of the following situations: (a) Countries have identical preferences and identical endowments. (b) Countries have identical preferences, their endowments differ, and their endow- ments are not in the same ratio of food to clothing. (c) Countries have identical preferences, their endowments differ, but the ratio of food to clothing is the same in both countries. (d) Countries have identical endowments but different preferences. (e) Countries have both different preferences and different endowmentsQuestion 2: Consider a country producing milk and cookies using labor and capital as inputs described by a Heckscher-Ohlin model. The following table provides outputs for goods and factor endowments before and after a change in the endowments. Output and Endowments Initial After Endowment Change Milk Output, QM 100 gallons 1 10 gallons Cookie Output, Qc 100 pounds 80 pounds Labor Endowment, L 4000 hours 4200 hours Capital Endowment, K 1000 hours 1000 hours a) Calculate and rank the magnification effect for quantities in response to the endowment change. b) Which product is capital intensive? Show why. c) Which product is labor intensive? Show why.23 Which of the following is true of an accounts receivable subsidiary ledger? In the general ledger. A) The total of the accounts in the accounts receivable subsidiary ledger must equal the accounts receivable balance subsidiary ledger. B) Companies keep an accounts payable subsidiary ledger that is entirely different than the accounts receivable C It does not include a receivable account for each customer, but includes a cumulative account for all customers. D) It contains information about the amount each customer purchased on credit, but excludes the customer name. 24) Which of the following is true of an accounts payable subsidiary ledger? A) It does not indicate the amount owed to each vendor. B) Its format is entirely different from an accounts receivable subsidiary lodger. C) It shows only a single total for the amount owed on account. them. D) It lists vendors in alphabetical order, along with amounts paid to the vendors and the remaining amounts owed to 25) A check was written by a business for $507, but was recorded in the cash payments journal as $705. How would this error be included on the bank reconciliation A) a deduction on the book side By an addition on the book side C) a deduction on the bank side Dj an addition on the bank side 26) A company has a petty cash fund amount of 5300, When replenished, it has petty cash receipts of $30 for gas expense, $32 for postage expense, $16 for supplies expense and $10 for miscellaneous expenses. Assume the cash balance is not over or short. In the journal entry, Cash would be credited with: A) $72 B) 498 D) $78 27) A petty cash fund was established with a $600 balance. It currently has cash of 525 and petty cash tickets as shown below. Travel expense $13 Office supplies 530 Equipment rental expense Which of the following would be included in the journal entry to replenish the Petty Cash account? A) Debit Cash Short & Over for $55 B) Credit Petty Cash $55 C) Debit Petty Cash $55 D) Credit Cash Short & Over for $55 28) Under the net method of handling credit and debit card payments, A) the net amount of the sale is credited to the Sales Revenue account on the date of sale. B) the credit to the Sales Revenue account is the selling price less the transaction fee. C) the business writes a check to the credit and debit card processor for the processing fee. Dj the processing fee is debited to the Credit Card Expense account on the date of sale. 29) Under the gross method, when the credit card processor deposits the cash proceeds from credit and debit card sales in the bank account of the business A) there will be no fee charged for the transaction. B) the business will credit cash for the gross amount of the sale. C) the total sales plus the processing fee assessed equals the net amount of cash deposited. D) the processing fees are deducted from the company's bank account by the processor. 30) The entity that signs the promissory note and promises to pay the required amount is the A) holder of the note. B) maker of the note. () banker of the note. D) payee of the note.1. Restaurants do a large volume of business by credit and debit cards. Suppose Winter Retreats restaurant had these transactions on January 28, 2018: (Click the icon to view the transactions.) Read the requirements. Requirement 1. Suppose Winter Retreats' processor charges a 3% fee and deposits sales net of the fee. Journalize these sale transactions for the restaurant. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.} Journalize the credit sales net of the fee, first. Accounts and Explanation Debit Credit (1) 13) (4) (5) Now journalize the debit card sales net of the fee. Accounts and Explanation Debit Credit (6) (7) (9) (10 Requirement 2. Suppose Winter Retreats' processor charges a 3% fee and deposits sales using the gross method. Journalize these sale transactions for the restaurant. (For purposes of this problem, only record the sales revenue portion of these transactions using the gross method. Record debits first, then credits. Select the explanation on the last line of the journal entry table.) First journalize the credit sales using the gross method. Accounts and Explanation Debit Credit (11 121 (14 (15) Lastly, journalize the debit sales using the gross method.10202019 Chapter 7 Homework-Nickisha Lun Accounts and Explanation Dabit Credit 16 (17) (20) 1: Data Table National Express credit card sales $ 11,700 ValueCard debit card sales 7.000 2: Requirements 1. Suppose Winter Retreats" processor charges a 3% fee and deposits sales net of the fee. Journalize these sales transactions for the restaurant. Suppose Winter Retreats' processor charges a 3% fee and deposits sales using the gross method, Journalize these sales transactions for the restaurant. (1) O Credit Card Expense O Accounts Receivable-National Express O Sales Revenue O Accounts Receivable-ValueCard O Cash (2) O O Credit Card Expense O Accounts Receivable-National Express O Sales Revenue O Accounts Receivable-ValueCard O Cash (3) O O Credit Card Expense O Accounts Receivable-National Express O Sales Revenue O Accounts Receivable-ValueCard O Cash (4) 0 O Credit Card Expense O Accounts Receivable-National Express O Sales Revenue O Accounts Receivable-ValueCard O Cash (5) O O Recorded credit card sales. O Recorded credit card sales, net of fee. O Sold goods on account. (6) O O Credit Card Expense O Accounts Receivable-National Express O Sales Revenue O Accounts Receivable-ValueCard O Cash