Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Flamingo Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash flow cycle.

  

The Flamingo Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash flow cycle. Last year, Flamingo's sales (all on credit) were $180,000 and its cost of goods sold were 85 percent of sales. Inventory was turned over eight times during the year, and the accounts receivable turnover was 10. Flamingo's payables deferral period is 30 days. (a) Calculate Flamingo's cash conversion cycle (b) Compute the average balances in accounts receivable, accounts payable and inventory Identify your final answer with a proper label and double underline. Begin by identifying what you know: Sales $180,000 = Cost of goods sold = $153,000 Inventory turnover = 8 Accounts receivable turnover = 10 DPO 30 (a) Calculate Flamingo's cash conversion cycle Days per year (360), Inventory turnover ratio (8), Days sales outstanding (36), payable deferral period (30)= (360/8)+36-30 = 51 (b) Compute the average balances in accounts receivable, accounts payable and inventory Receivable turnover ratio= Credit sales during the year/Average accounts receivable. Average accounts receivable Credit sales during the year/Receivable turnover ratio Credit sales during the year - $180,000 Receivable turnover ratio- 10 Average accounts rec. - $18,000-($180,000/10) Payment deferral period=Days per year Average accounts payable/Cost of goods sold Average accounts payable - Payment deferral period Cost of goods sold/Days per year Payment deferral period - Cost of goods sold Days per year. 30 Average accounts pay.- $153,000 360 $12.750-30 (153,000/360) Inventory turnover ratio = Cost of goods sold / Average inventory Average inventory - Cost of goods sold / Inventory turnover ratio $153,000 Cost of goods sold. Inventory turnover ratio Average inventory bal. - $19.125.00-(153,000/8) 2) Stratosphere Wireless is examining its cash conversion cycle. The company expects its cost of goods sold, which equal 80 percent of sales, to equal $480,000 this year. Stratosphere normally turns over inventory 24 times per year, accounts receivable are turned over 15 time per year and the account payable turnover is 40. (a) Calculate the cash conversion cycle (b) Calculate the average balances in accounts receivable, accounts payable and inventory Identify your final answer with a proper label and double underline. Begin by identifying what you know: Sales: 600,000 Cost of goods sold = 480,000 Inventory Turnover = 24 Accounts Receivable Turnover = 15 Accounts Payable Turnover = 40 (a) Calculate Flamingo's cash conversion cycle Days per year (360), Inventory turnover ratio (24), Days sales outstanding (36), payable deferral period (40)= (360/24)+36-40= 11 Receivable turnover ratio = Credit sales during the year/Average accounts receivable. average accounts receivable = Credit sales during the year/Receivable turnover ratio Credit sales during the year - $600,000 Receivable turnover ratio- 15 Average accounts rec. - $40,000-($600,000/15) * Payment deferral period=Days per year Average accounts payable/Cost of goods sold Average accounts payable = Payment deferral period Cost of goods sold/Days per year 40 Payment deferral period - Cost of goods sold- Days per year Average accounts pay.- $480,000 360 $53.333.33-40 (480,000/360) Inventory turnover ratio= Cost of goods sold / Average inventory Average inventory Cost of goods sold / Inventory turnover ratio Cost of goods sold- $480,000 24 Inventory turnover ratio- Average inventory bal. - $20.000 (480,000/24)

Step by Step Solution

3.44 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Payables days 365 Payables turn over Payables days 365 COGS accounts payable 30 365 08518000... 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

Intermediate Financial Management

Authors: Brigham, Daves

10th Edition

978-1439051764, 1111783659, 9780324594690, 1439051763, 9781111783655, 324594690, 978-1111021573

More Books

Students also viewed these Accounting questions

Question

Describe four technical features of Darwins theory of evolution.

Answered: 1 week ago

Question

Determine a value index for 2013 using 1990 as the baseperiod.

Answered: 1 week ago