Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fiscal Year Ending Aug-2 Historicals 2013A 2014A 2015A Projections 2016E $4,026.0 $4,134.0 $4,041.0 $3,980.0 2,383.0 2,539.5 2,495,5 2,428,0 Sales Cost of goods sold (excluding depreciation)

image text in transcribed
image text in transcribed
Fiscal Year Ending Aug-2 Historicals 2013A 2014A 2015A Projections 2016E $4,026.0 $4,134.0 $4,041.0 $3,980.0 2,383.0 2,539.5 2,495,5 2,428,0 Sales Cost of goods sold (excluding depreciation) Current assets Accounts receivable, net Inventories Other current assets Total non-cash current assets: Current liabilities Accounts payable Accrued liabilities Other current liabilities Total non-debt current liabilities Net Working Capital (Increase)/decrease in Net Working Capital $317.5 462.5 164.0 $944.0 $335.0 508.0 910 $934.0 $323.5 496.5 99.5 $919.5 Q5 Q6 Q7 $903.5 $260.0 308.5 59.5 $628.0 $263.5 276.5 69.0 $609.0 $272.0 294.5 65.0 $631.5 $288.0 Q2 Q8 Q9 Q 10 $613.0 $290.5 $316.0 $325.0 Q1 Assumptions Numbers of days in the period 365 Accounts receivable (days collection period) Inventories (days outstanding) Accounts payable (days outstanding) Other current assets (as % of sales) Accrued liabilities (as % of sales) Other current liabilities (as % of sales) Cash Conversion Cycle cell is named "Days" 28.8 29.6 70.8 73.0 Q3 37.9 4.1% 2.2% 7.7% 6.7% 1.5% 1.796 29.2 72.6 39.8 2.5% 7.39 1.69 29.5 72.5 39.5 2.5% 7.3% 1.5% 59.8 Q4 62.0 62.5 Calculate accounts payable for 2016 $267.0 2 Assumptions Numbers of days in the period 365 Accounts receivable (days collection period) Inventories (days outstanding) Accounts payable (days outstanding) Other current assets (as % of sales) Accrued liabilities (as % of sales) Other current liabilities (as % of sales) Cash Conversion Cycle cell is named "Days" 28.8 29.6 70.8 73.0 Q3 37.9 29.2 72.6 39.8 4.1% 7.7% 1.5% 2.2% 6.7% 1.7% 2.5% 7.3% 1.6% 2 7. 1. 59.8 Q4 62.0 62 Calculate accounts payable for 2016. A $267.0 . $277.0 c. $262.8 D. $257.8

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

Sports Finance And Management Real Estate Entertainment And The Remaking Of The Business

Authors: Jason A. Winfree, Mark S. Rosentraub, Brian M Mills

1st Edition

1439844712, 9781439844717

More Books

Students also viewed these Finance questions