Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you show how to solve this without excel? been asked to complete the capital budget for this project. So far, you have compiled the

can you show how to solve this without excel?
image text in transcribed
image text in transcribed
been asked to complete the capital budget for this project. So far, you have compiled the following information: The project will last for four years. The initial investment in equipment is $10 million. The salvage value of the equipment will be $2 million. The equipment will be depreciated to 0 over the next four years using straight-line depreciation. The project needs an initial investment in net working capital of $0.5 million. The corporate tax rate is 30%. The cost of capital is 10%. Assume that the firm's other projects yield a positive income before tax. Additionally, you receive the following project-related information from the accounting and marketing departments in $ million): 1 0 (now) 0.5 4 0.8 0 Year Net working capital Sales Cost of goods sold Depreciation 6 3 2.5 2 1.2 8 4 2.5 3 0.8 10 5 2.5 9 4 2.5 17. What's the net cash flow NCF in year 0 in 9 million)? 18. What's the NCF in year 1 in S million)? 19. What's the NCF in year 3 (in million)? 20. How do you account for the change in net working capital in year 4 in 9 million)? A) I subtract 0.8 from the after-tax operating income B) I add 0.8 to the after-tax operating income C) I add 0.8 to the operating income before tax D) I don't account for the change in net working capital since the networking capital in year 4 is zero 21. What's the after-tax salvage value in year 4 (in S million)? 22. What's the depreciation tax shield in year 4 (in million), i.e. what's the tax savings due to depreciation in year 4? 23. Suppose Sound Inc. decides to depreciate the equipment straight-line to $2 million over the next four years instead of depreciating the equipment to zero as in the base case). How does this new depreciation plan change the project's NPV, assuming everything else remains constant (in 9 million)? A) NPV increases B) NPV decreases C) NPV is unaffected since the sum of tax payments is the same for both plans D) Unable to decide since not enough information 24. Assume that if you undertake this project, operating income before tax of Sound Inc.'s other products will go up by S3 million in the first year. How do you account for this positive side effect in year 1 (in S million)? A) I add 0.9 to the before-tax operating income B) I add 2.1 to the before-tax operating income C) I add 2.1 to the after-tax operating income D) I add 3.0 to the after-tax operating income

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

HSBA Handbook On Ship Finance

Authors: Schinas

2015th Edition

3662434091, 978-3662434093

More Books

Students also viewed these Finance questions

Question

In most cases, medication is prescribed by physicians.

Answered: 1 week ago

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago