Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

PJ is considering investing in a new plant in Mexico to produce dog biscuits. PJ has provided you with the following information: Full price of

PJ is considering investing in a new plant in Mexico to produce dog biscuits. PJ has provided you with the following information:

Full price of machine is 150,000,000 MXN. $/MXN = 0.05. Production costs = 90,000,000 MXN each year for the life of the project. PJ can transport the dog biscuits back to the USA for $1,000,000 per year where you can sell them for $7,500,000. The plant falls into the MACRS 3-year class and will require an increase in net working capital of 1,000,000 MXN. PJ has a 30% marginal tax rate. PJ will use the machine for 6 years and then plans to sell it for 20,000,000 MXN at the end of year 6. PJ has a WACC of 10%.

Your group has been hired by PJ to create a spreadsheet (50 points) that can be used by the PJ managers to assist them in making the investment decision and will calculate the NPV and IRR of the project. The spreadsheet should be set up to allow for sensitivity analysis to be conducted. The cells to input the full price, the exchange rate for each year over the life of the project, the production costs, the transportation costs, the sales revenue, the increase in net working capital, the tax rate, the sale price for the machine at the end of year 6 and the WACC should be easily identified and allow the PJ managers to change their values.

What type of financial contract that could mitigate the effect of a depreciating dollar (approximately 25 words total, 10 points)?

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_2

Step: 3

blur-text-image_3

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

Introduction To The Financial Management Of Healthcare Organizations

Authors: Michael Nowicki

6th Edition

1567936695, 9781567936698

More Books

Students explore these related Finance questions