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.

Part 1 (02 pt) 0 Feedback Q See Hint A consumer receives an endowment of $200.00 this period and $800.00 next period. Currently the interest rate is 11.00%. The present value of the endowment is $ 0 222 . (Give your answer to two decimals.) Part 2 (0,4 pt) % Feedback Q See Hint Suppose that instead, the endowment is $240.00 this period and $1040.00 next period. Suppose that the interest rate is still 11.00%. Now the present value of the endowment is $ 9 1394.40 . (Give your answer to two decimals.) With the new endowments, the consumer is oEealthier v Part 3 (0.4 pt) % Feedback 0 See Hint Now suppose that the endowment is $150.00 in the rst period and $775.00 in the second period. The interest rate is still 1 1.00%. Now the present value of the endowment is $ 9 1010.25 . (Give your answer to two decimals.) With the new endowments, the consumer is opoorer v 64-475091194124319148610021576 MINDTAP ST 260-002 Homework #2 &Dun Today In 11 PM CST Activity Information Q What is the lots endowment at these 10 universities? (to 1 decimal) They union represent 2:3%% of the 435 colleges and universities surveyed. What peromage of the total Mil] billion is endow ments is held by Base 10 um i. The Wal Street Journal reported that over a recent five-month period, a downturn in the moonging how arup Baller amount of the decing in the total endow ints held by Pose 10 universites (to the seerest billor]? of the reps you would mapact price The isput in the box baice see proded, but may be me 10 MacBook Pro2.) (20 points total) Suppose there are two consumers with different utility functions but the same initial endowments. Consumer 1: u1 (91, 92) = 9192 Consumer 2: U2 (q1, 92) = 9192 Initial endowment for consumer 1 = (10,10) = initial endowment for consumer 2 a. (10 points) Given this information, draw the Edgeworth box with correct height and length, draw the initial endowment point E, and accurate IC curves for both consumers that go through the initial endowment. Label everything! b. (5 points) Is the initial endowment Pareto efficient? Why or why not? Show your work. c. (5 points) What prices p, and p2 would result in a competitive equilibrium at the initial endowment?Which of the following accounts has a normal credit balance? Accounts Receivable O Sales O Merchandise Inventory Delivery ExpenseRestaurants do a large volume of business by credit and debit cards. Suppose Cityside Collection restaurant had these transactions on January 28, 2016: National Express credit card sales $ 10,800 ValueCard debit card sales 6,000 Requirements 1. Suppose Cityside Collection's processor charges a 3% fee and deposits sales net of the fee. Journalize these sales transactions for the restaurant. 2. Suppose Cityside Collection's processor charges a 3% fee and deposits sales using the gross method, Journalize these sales transactions for the restaurant. Requirement 1. Suppose Cityside Collection's 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 Now joumalize the debit card sales net of the fee. Accounts and Explanation Debit Credit