I need assistance with the attached formulation. Please just type cell reference in a separate solution document. Thanks kindly.

Problem 26-4 The Greek Connection had sales of $32 million in 2009, and a cost of goods sold of $20 mil balance sheet for the firm appears below: THE GREEK CONNECTION Balance Sheet As of December 31, 2009 (000) Assets Cash Accounts receivable Inventory Total current assets $2,000 3,950 1,300 $7,250 Net plant, property and equipment Total Assets $8,500 $15,750 a. Calculate The Greek Connection's net working capital in 2009. b. Calculate the cash conversion cycle of The Greek Connection in 2009. c. The industry average days sales outstanding ratio is 30 days. What would the cash co Greek Connection have been in 2009 had it matched the industry average days sales o Sales (000) Cost of Goods Sold (000) $32,000 $20,000 a. Calculate The Greek Connection's net working capital in 2009. Net working capital (000) b. Calculate the cash conversion cycle of The Greek Connection in 2009. Accounts receivable days Inventory days Accounts payable days Cash conversion cycle (days) c. The industry average days sales outstanding ratio is 30 days. What would the cash co Greek Connection have been in 2009 had it matched the industry average days sales o Industry accounts receivable days 30 Cash conversion cycle (days) Requirements 1. In cell D31, by using cell references, calculate the company's net working capital (1 p 2. To calculate the cash conversion cycle, you need to calculate accounts receivable day days, and accounts payable days. In cell D35, by using cell references, calculate the accounts receivable days(1 pt.). 3. In cell D36, by using cell references, calculate the inventory days (1 pt.). 4. In cell D37, by using cell references, calculate the accounts payable days (1 pt.). 5. In cell D38, by using cell references, calculate the cash conversion cycle (1 pt.). 6. In cell D44, by using cell references, calculate the cash conversion cycle based on the accounts receivable days (1 pt.). nd a cost of goods sold of $20 million. A simplified CONNECTION e Sheet ber 31, 2009 0) Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities Common equity Total liabilities and equity $1,500 1,000 1,220 $3,720 $3,000 $6,720 9,030 $15,750 ital in 2009. Connection in 2009. s 30 days. What would the cash conversion cycle for The d the industry average days sales outstanding? Days in a year ital in 2009. Connection in 2009. 365 s 30 days. What would the cash conversion cycle for The d the industry average days sales outstanding? company's net working capital (1 pt.). calculate accounts receivable days, inventory accounts receivable days(1 pt.). nventory days (1 pt.). accounts payable days (1 pt.). cash conversion cycle (1 pt.). cash conversion cycle based on the industry