7A) Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset...

70.2K

Verified Solution

Question

Finance

7A) Quad Enterprises is considering a new three-year expansionproject that requires an initial fixed asset investment of $2.9million. The fixed asset will be depreciated straight-line to zeroover its three-year tax life, after which time it will beworthless. The project is estimated to generate $2,190,000 inannual sales, with costs of $815,000. If the tax rate is 35percent, what is the OCF for this project? Suppose the requiredreturn on the project is 12 percent. What is the project'sNPV?
7B. In the previous problem, suppose the project requires aninitial investment in net working capital of $300,000, and thefixed asset will have a market value of $210,000 at the end of theproject. What is the project's Year 0 net cash flow? Year 1? Year2? Year 3? What is the new NPV?
7C. Suppose the fixed asset actually falls into the three-yearMACRS class. All the other facts are the same. What is theproject's Year 1 net cash flow now? Year 2? Year 3? What is the newNPV?
Please answer with Excel formulas included.

Answer & Explanation Solved by verified expert

4.2 Ratings (544 Votes)

See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

7A) Quad Enterprises is considering a new three-year expansionproject that requires an initial fixed asset investment of $2.9million. The fixed asset will be depreciated straight-line to zeroover its three-year tax life, after which time it will beworthless. The project is estimated to generate $2,190,000 inannual sales, with costs of $815,000. If the tax rate is 35percent, what is the OCF for this project? Suppose the requiredreturn on the project is 12 percent. What is the project'sNPV?7B. In the previous problem, suppose the project requires aninitial investment in net working capital of $300,000, and thefixed asset will have a market value of $210,000 at the end of theproject. What is the project's Year 0 net cash flow? Year 1? Year2? Year 3? What is the new NPV?7C. Suppose the fixed asset actually falls into the three-yearMACRS class. All the other facts are the same. What is theproject's Year 1 net cash flow now? Year 2? Year 3? What is the newNPV?Please answer with Excel formulas included.