Reference no: EM133160069
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.
|
Case-donna diabetes
: For the past 2 or 3 years, Donna has always had fasting blood sugar levels in the 100-120 mg/dL range. When she presents in your clinic however, her fasting blo
|
|
What is the variable overhead spending variance
: In the most recent month, 180,000 items were shipped to customers using 7,700 direct labor-hours. What is the variable overhead spending variance
|
|
Annual-semiannual-quarterly and monthly compounding
: What is the future value of $1000 after 4 years under 10% annual compounding? Semiannual compounding? Quarterly compounding? Monthly compounding?
|
|
Compute the amount of baron pension expense
: Baron Company adopted a defined benefit pension plan on January 1, 2018. Compute the amount of Baron's pension expense for 2019 and 2020
|
|
Calculate asset ratios
: The purpose of this assignment is to calculate asset ratios, analyze them, and compare them between two competitors in the same industry.
|
|
Compute the amount of smith pension expense
: Smith contributed $330,000 and $350,000 to the pension fund at the end of 2019 and 2020, respectively. Compute the amount of Smith pension expense
|
|
Prepare a straight-line amortization table for the bonds
: They are issued at $571,310 when the market rate is 12%. Prepare a straight-line amortization table for the bonds' first two years
|
|
Characteristics of binomial experiment
: What are the 4 characteristics of a binomial experiment? Can we use a binomial distribution to model this process?
|
|
Develop a mini fraud risk assessment
: Develop a mini fraud risk assessment that identifies and analyzes relevant fraud risk factors, fraud risks, related fraud scheme(s)
|