Determine the dollar net cash flows

Reference no: EM131001678

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 flows (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 fows that you would receive at the end of each of the last 7 years if you partially ?nanced the project by borrowing dollars.

3. Reestimate the dollar net cash ?ows and the stan- dard deviation of the dollar net cash flows 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: EM131001678

Questions Cloud

Find flow rate in mmscf/day : Given Schedule 20 pipe Diameter of 14" Length of 100 miles Inlet Pressure of 1300 psia Outlet pressure 300 psia AVG temp 40 degrees F Gas consists of 75% CH4. 21% C2H6 and 4% C3H8 Find flow rate in MMscf/day

Solve the two problems with the topic of dynamics : Solve the two problems with the topic of Dynamics.

What is comprehensive income : What is comprehensive income? How does it differ from net income? Where is it reported in a balance sheet? Why does Cisco's 2009 other comprehensive income not reconcile with the beginning ($728 million) and ending ($435 million) balances of accumula..

What causes stall on an aircraft : What causes stall on an aircraft and why do different planes reach stall at different positions?

Determine the dollar net cash flows : Use an Excel spreadsheet to determine the dollar net cash flows (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.

Cu metallizaton in 3d ic packaging technologhy : CU Metallizaton in 3D IC packaging technologhy

Find the expectation and variance of the present value : Find the expectation and variance of the present value of the benefits. A single premium for the contract is found by adding a 20% relative risk loading to the present value.

How should alcoa account for the cash dividend : What are the two primary courses of action Alcoa has in accounting for the stock split, and how would the choice affect Alcoa's shareholders' equity? Why?

How much leniency should people get : How much leniency should people get when they file claims to the EEOC but there is not a specific cause of action? In this instance the woman file a claim based on discrimination because of her weight but that is not a protected class under the EE..

User Account

All Pages