Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am supposed to provide verbiage (shown below) and a chart to support the verbiage. I need your help in making a chart that I

I am supposed to provide verbiage (shown below) and a chart to support the verbiage. I need your help in making a chart that I can paste into my word document from the current ratios from PepsiCo and Coca-Cola provided below. I know very little about excel or charts and hope you can assist me in learning this process. It will definitely be worth a 5-star rating for you. Thank you for your time and support.

The current ratio is enumerated from the balance sheet and is a comparison of the current assets to current liabilities which is calculated by dividing the two numbers (Law, 2016). PepsiCos total current assets for 2017 were $31,027,000 and the total current liabilities for the same period was $20,502,000. When these two numbers are divided, the current ratio is 1.51: 1 (PepsiCo, 2019). Coca-Colas total current assets for the same time frame were $36,545,000 and their total current liabilities in 2017 equaled $27,194,000. The partition of the statistics is equivalent to the current ratio of 1.34: 1 (Coca-Cola, 2018).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions