Question

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). PepsiCo’s 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-Cola’s 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).

Answer 1

Computation of Current Ratio
Current Ratio	=	Current Asset
		Current Liabilities
Pepsico	=	31,027,000.00	=	1.51	=	1.51:1
		20,502,000.00		1
Coca-Cola	=	36,545,000.00	=	1.34	=	1.34:1
		27,194,000.00		1

Relevant Charts:

Particulars	Current Asset	Current Liabilities	Current Ratio
Pepsico	31,027,000.00	20,502,000.00	1.51
Coca Cola	36,545,000.00	27,194,000.00	1.34