Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Argo's first quarter's 2020 financials are being prepared and the CFO wants you to use them to calculate days receivable, days inventory, operating cycle, days

Argo's first quarter's 2020 financials are being prepared and the CFO wants you to use them to calculate days receivable, days inventory, operating cycle, days payable, and cash cycle for each of the three months of 1Q20. The financials are below:

image text in transcribed

IMPORTANT: PLEASE SHOW FORMULAS USED TO CALCULATE INSIDE THE FORMULAS ( I ONLY NEED TO COMPLETE THE INFORMATION IN THE YELLOW CELLS)

image text in transcribed

1020 Income Statement (in M$) Sales Cost of Goods Sold Jan 202 108 Feb 261 133 Mar 264 139 Sales, General, and Admin. Interest Expense 22 13 23 12 22 12 Taxes 20 22 29 1020 Balance Sheet (in M$) Cash Receivables Inventory Jan 325 260 85 Feb 514 277 83 Mar 600 300 84 PP&E 976 997 988 110 121 121 Payables Notes Payable Accruals LTD 40 44 55 48 55 55 LTD Equity 310 1,131 310 1,341 330 1,418 D E | Mar. Mar. F G . 1Q20 Balance Sheet (in MS) Jan. Feb. Cash Receivables Inventory Curr. Assets PP&E Total Assets A B 1 1Q20 Income Statement (in MS) 2 Jan. Feb. 3 Sales 4 Cost of goods sold 5 Gross margin 6 Sales, general & admin. 7 Interest expense 8 Taxable income 9 Taxes 10 Net income 11 12 Key Ratios 13 Jan. Feb. 14 Days Receivable 15 Days Inventory 16 Operating Cycle 17 Days Payable 18 Cash Cycle Mar. Payables Notes Payable Accruals LTD Curr. Liabilities LTD Equity Total L&E

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions