Determine the dollar net cash

Reference no: EM13999775

Assume that you invested equity to establish a project in Portugal in January of about 7 years ago. At the time the project began, you could have supported it with a 7- year loan either in dollars or in euros. If you bor- rowed U.S. dollars, your annual loan payment (includ- ing principal) would have been $2.5 million. If you borrowed euros, your annual loan payment (including principal) would have been 2 million euros. The project generated 5 million euros per year in revenue.

1. Use an Excel spreadsheet to determine the dollar net cash ?ows (after making the debt payment) that you would receive at the end of each of the last 7 years if you partially ?nanced the project by bor- rowing dollars.

2. Determine the standard deviation of the dollar net cash ?ows that you would receive at the end of each of the last 7 years if you partially ?nanced the proj- ect by borrowing dollars.

3. Reestimate the dollar net cash ?ows and the stan- dard deviation of the dollar net cash ?ows if you partially ?nanced the project by borrowing euros. (You can obtain the end-of-year exchange rate of the euro for the last 7 years at https://www.oanda. com or other websites.) Are the project's net cash ?ows more volatile if you had borrowed dollars or euros? Explain your results.

Reference no: EM13999775

Questions Cloud

Protozoa desires to obtain secret recipe for lobster patty : Protozoa desires to obtain the secret recipe for a lobster patty that is known by Lobster who is Protozoa's biggest competitor. Protozoa has attempted to steal the recipe for years. What can Lobster do to protect his secret recipe

Produce after-tax cash flows : Zappe Airlines is considering two alternative planes. Plane A has an expected life of 5 years, will cost $100 million, and will produce after-tax cash flows of $30 million per year. Plane B has a life of 10 years, will cost $132 million, and will ..

Trade flows between european union and major trading partner : Discuss an overview of Slovenia's international trade flows between the European Union (EU) and its major trading partners. Potential gains from specialization and international trade among Romania, Portugal, and Slovenia. Include opportunity cost di..

Evaluate a policy aimed at limitingthe use of a pesticide : Suppose you are using risk-benefit analysis to evaluate a policy aimed at limitingthe use of a pesticide applied to grain crops. Describe the risks and benefits that would have to be estimated to conduct this analysis properly.

Determine the dollar net cash : Use an Excel spreadsheet to determine the dollar net cash ?ows (after making the debt payment) that you would receive at the end of each of the last 7 years if you partially ?nanced the project by bor- rowing dollars.

Calculate the returns to scale and marginal productivity : Calculate the returns to scale, marginal productivity, and state which of the functions defines a convex feasible region over their entire usage?

How to improve their current marketing and sales management : Select a sales organization within your community and schedule an interview with their marketing manager (the interview can be done by phone or in person)

Calculate the total benefit to society of the optimal : A society has two people: 1 and 2. Person 1's true demand (marginal benefit) for a public good is given by P= 60 - 2G and 2's true demand is given by P = 120 -G. the total cost of providing G is TC = G^2. Calculate the total (net) benefit to society ..

What is the average net force exerted on the ball : A high speed movie film determines that the racket and ball are in contact for 0.05 seconds. What is the average net force exerted on the ball by the racket?

User Account

All Pages