Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain how to solve this problem with excel. United Technologies is considering building a new manufacturing plant to produce super energy efficient Home Climate

Please explain how to solve this problem with excel.

United Technologies is considering building a new manufacturing plant to produce super energy efficient Home Climate Control Systems through its Carrier division. The project would require an initial investment in new production facilities and equipment of $400 million in 2016 would fall in the 5-year MACRS depreciation class. United Technologies has already spent $20 million designing and developing these new systems and they will need additional net working capital of $50 million in 2016. The table following this paragraph contains sales, sale price, variable cost & fixed cost projections over the expected life of the project. The companys marginal tax rate is 40% and this project has a WACC of 9.5%. Year Expected Unit Sales Avg. Sales Price/unit Avg. Variable costs/unit Additional Fixed Costs 2017 100,000 $3000 $1800 $210,000 2018 120,000 $3000 $1800 $215,000 2019 130,000 $3100 $1900 $220,000 2020 135,000 $3100 $1950 $225,000 2021 130,000 $3100 $1950 $230,000 At the end of 2021, United Technologies will end the project and can sell their production facility & equipment for $85 million in addition to liquidating the extra net working capital that was needed for the project. Answer the following. 1. What is the initial cash flow for the project? 2. What are the annual operating cash flows for the project. 3. What is the projects terminal cash flow? 4. Calculate the NPV, IRR, and MIRR for the project. 5. Should UTC accept this project? Explain why.

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

The Handbook Of European Fixed Income Securities

Authors: Frank J. Fabozzi, Moorad Choudhry

1st Edition

0471430390, 978-0471430391

More Books

Students also viewed these Finance questions

Question

To solve p + 3q = 5z + tan( y - 3x)

Answered: 1 week ago