Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

sitivity Analysis: Use the following information to answer questions 5, 6, 7, and 8, below (Hint: Using Excel will be helpful): A three-year project requires

image text in transcribed

sitivity Analysis: Use the following information to answer questions 5, 6, 7, and 8, below (Hint: Using Excel will be helpful): A three-year project requires an initial investment (i.e. at t=0) in equipment of $100,000. At t-3, the company plans to sell the equipment for $10,000. The equipment can be depreciated according to the three year schedule, which allows depreciation of 33.33% at t=1, 44.45% at t=2, 14.81% at t=3, and 7.41% at t=4. Depreciation will be based solely on the initial cost of the equipment (i.e. , when calculating depreciation, ignore any salvage value) . This project is expected to produce sales revenue of $400,000 per year for each of the three years of the project (i.e., sales revenue will be $400,000 for t-1, t-2, and t-3) Manufacturing costs are estimated to be $300,000 per year. The corporate tax rate is 35%. The company's tax situation is such that it can make use of all applicable tax shields and deductions. The opportunity cost of capital is 20%. 5. Calculate the Net Present Value (NPV) of the project 6. How will the project NPV change if the revenue is 20% higher than estimated? How will the project NPV change if the revenue is 20% lower than estimated? 7. How will the project NPV change if the manufacturing costs are 10% higher than estimated? How will the project NPV change if the manufacturing costs are 10% lower than estimated? 8. Based on your answers to questions 5, 6, and 7, prepare a sensitivity table for this project. Is the project decision to accept or reject more sensitive to the revenue estimate or to the cost estimate

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

Financial Management Theory And Practice

Authors: Eugene F. Brigham, Michael C. Ehrhardt

17th Edition

0357714482, 9780357714485

More Books

Students also viewed these Finance questions