Question: please help me answer #2. PLEASE do not send me an excel spreadsheet or some other type of word document. i need for your answer

please help me answer #2. PLEASE do not send me an excel spreadsheet or some other type of word document. i need for your answer to be in the same format as the exemplar work example (second image). PLEASE USE PEN AND PAPER to solve so that i can know what to do on a test.
please help me answer #2. PLEASE do not send me an excel
spreadsheet or some other type of word document. i need for your
answer to be in the same format as the exemplar work example

2. The industry inventory tumover ratio is 15. Collins plans to reduce the inventory level to equal the industry average. How much cash can the company free up from reducing inventories? Assume that the sales level & cost of goods sold will remain constant. (7.5 points) Example of how to show your work: FCF2014 = NOPAT2014 -(TNOC2014 - TNOC2013) NOPAT2014=EBIT2014 (1-t) = 60,884*(1-.4) = $36,530.40 NOW2014=OPCA2014-OPCL2014=(Cash+AR+Inv)2014-(AP+Accruals)2014 +(91,450+103,365+38,444) - (30,761+30,477) = $172,021 Therefore, TNOC2014=NOW2014+NFA2014=172,021+67,105 = $239,186 Balance Sheet: Cash AR Inventories Total current assets Net fixed assets Total assets $ 20 1,000 2.000 $ 3,020 2.980 $ 6.000 Income Statement: Sales Cost of goods sold EBIT Interest (10%) EBT Taxes (40%) Net Income $10,000 9.000 $ 1,000 600 $ 400 160 $240

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!