Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I need help with the following question, I will need the excel file with the calculations in it so I can understand the steps...

Hi, I need help with the following question,

I will need the excel file with the calculations in it so I can understand the steps... (no copy and paste from other websites....)

I NEED THIS ANSWER IN ONE HOUR FROM NOW, PLEASE ANSWER ONLY IF YOU CAN UPLOAD THE FILE IN THE NEXT HOUR!!!!!

The Wheel Deal Inc., a company that produces scooters and other wheeled non-motorized recreational equipment is considering an expansion of their product line to Europe. The expansion would require a purchase of equipment with a price of $1,200,000 and additional installation of $300,000 (assume that the installation costs cannot be expensed, but rather, must be depreciated over the life of the asset). Because this would be a new product, they will not be replacing existing equipment. The new product line is expected to increase revenues by euro 600,000 per year over current levels for the next 5 years, however; expenses will also increase by euro 220,000 per year. (Note: Assume the after-tax operating cash flows in years 1-5 are equal, and that the terminal value of the project in year 5 may change total after-tax cash flows for that year.) The equipment is multipurpose and the firm anticipates that they will sell it at the end of the five years for euro 500,000. The firm's required rate of return is 12% and they are in the 40% tax bracket. Depreciation is straight-line to a value of euro 0 over the 5-year life of the equipment, and the project also expects an increase in NWC of euro 10,000 per year for the next 5 years (to be recovered at the sale of the equipment at the end of five years). The current spot rate is $0.95/euro, and the expected inflation rate in the U.S. is 4% per year and 3% per year in Europe.

  1. What are the EBIT for the Wheel Deal project?
  2. What are the free cash flows for the Wheel Deal project?
  3. What is the initial investment for the Wheel Deal project?
  4. What is the NPV and IRR of the European expansion from the project viewpoint?
  5. What are the forecasts of future exchange rates using the purchasing power parity?
  6. If all the free cash flows are remitted to the parent, what is the NPV and IRR of the European expansion from the parent viewpoint?
  7. The Wheel Deal Inc. ask you for advise on the investment. What is your recommendation? Explain your recommendation.

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

Principles Of Finance

Authors: Besley, Scott Besley, Eugene F Brigham, Brigham

4th Edition

0324655886, 9780324655889

More Books

Students also viewed these Finance questions