Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Can you show me how to do this in excel all the cells, thank you so much image text in transcribed
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
image text in transcribed
image text in transcribed
image text in transcribed
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

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

IT And European Bank Performance

Authors: E. Beccalli

1st Edition

0230006949, 9780230006942

More Books

Students also viewed these Accounting questions

Question

=+b) Compute the SD for each decision.

Answered: 1 week ago

Question

Write a book report about the planting fast growing churches.

Answered: 1 week ago

Question

What makes Zipcar an attractive employer for which to work?

Answered: 1 week ago

Question

Evaluate Figure 6-9; what other questions would you ask, and why?

Answered: 1 week ago