Can you show me how to do this in excel all the cells, thank you so much
accounts rec without the project is 105,000 it is hard to read i keep taking pics on my end it is clear but then when i put it in it is blurred
ME 12-6 P State OS W 13 21 TV 22 D $35.0 AT ET . Work VI P12-8 Teowrong with come by. The company reason 200.000 de perto, the towing con Account SI 1300.000 LP IND What is the tower 5110000 S. 000 for Win Capital Without WE DT Change Brand 3824 AR - 23 an AP 21 Year Tears e 20 5 SAT.000 200.000 S42.000 300.000 505.000 27 23 THE BY Deaction Gh nd 14 deciding whether or not to introduce sun. 12-8. (Calculating changes in net operating working capital) (Related to Checkpoint 12.1 on page 378) Tetious Dimensions is introducing a new product that it expects will increase its net operating income by $475,000. The company has a 30 percent mar ginal tax rate. This project will also produce $200,000 of depreciation per year. In addition, it will cause the following changes: Without the Project With the Project Accounts receivable Inventory Accounts payable $ 105,000 200,000 90,000 $ 130,000 280,000 130,000 What is the project's free cash flow for Year 1? Inputs Working Capital Depreciation Tax Rate see pg. 381 (step 2) and pg. 382 (step 4) ($200,000) for Working Capital requirements (see page 381) Without With Change AR Iny AP Year 0 Year 1 Year 2 Year 3 Part 1: Revenues less: Cost of good sold less: Cash Expenses less: Depreciation Exp Operating Income Taxes Operating Profit AT plus: Depreciation Operating Cash Flow (S200,000) $475,000 (S200,000) $475,000 (S200,000) $475,000 less: Capital Expend less: Working Capital Free Cash Flow ME 12-6 P State OS W 13 21 TV 22 D $35.0 AT ET . Work VI P12-8 Teowrong with come by. The company reason 200.000 de perto, the towing con Account SI 1300.000 LP IND What is the tower 5110000 S. 000 for Win Capital Without WE DT Change Brand 3824 AR - 23 an AP 21 Year Tears e 20 5 SAT.000 200.000 S42.000 300.000 505.000 27 23 THE BY Deaction Gh nd 14 deciding whether or not to introduce sun. 12-8. (Calculating changes in net operating working capital) (Related to Checkpoint 12.1 on page 378) Tetious Dimensions is introducing a new product that it expects will increase its net operating income by $475,000. The company has a 30 percent mar ginal tax rate. This project will also produce $200,000 of depreciation per year. In addition, it will cause the following changes: Without the Project With the Project Accounts receivable Inventory Accounts payable $ 105,000 200,000 90,000 $ 130,000 280,000 130,000 What is the project's free cash flow for Year 1? Inputs Working Capital Depreciation Tax Rate see pg. 381 (step 2) and pg. 382 (step 4) ($200,000) for Working Capital requirements (see page 381) Without With Change AR Iny AP Year 0 Year 1 Year 2 Year 3 Part 1: Revenues less: Cost of good sold less: Cash Expenses less: Depreciation Exp Operating Income Taxes Operating Profit AT plus: Depreciation Operating Cash Flow (S200,000) $475,000 (S200,000) $475,000 (S200,000) $475,000 less: Capital Expend less: Working Capital Free Cash Flow
