The background information and instruction of the question is provided below, and i only asked for solving the table 4 and table 5, thank you

Scenario 2:

Considering the calculations you have done so far, you need to attend to a number of import and export transactions for goods that companies in the United States expressed interest in.

The first transaction is for the import of good quality wines from France, since a retail liquor trading chain customer in the United States, for who you have been doing imports over the past five years has a very large order this time. The producer in France informed you that the current cost of the wine that you want to import is €2,500,000. The wine in France can be shipped to the United States immediately but you have three months to conduct payment.

The second transaction is for the export of 3d printers manufactured in the U.S.A. The country where it will be exported to is Britain. The payment of £2,500,000 for the export to Britain will be received twelve months from now.

You consider different transaction hedges, namely forwards, options and money market hedges.

You are provided with the following quotes from your bank, which is an international bank with branches in all the countries:

Forward rates:

Bank applies 360 day-count convention to all currencies (for this assignment apply 360 days in all calculations).

Annual borrowing and investment rates for your company:

Bank applies 360 day-count convention to all currencies. Explanation – e.g. 3 month borrowing rate on $ = 2.687%. This is the annual borrowing rate for 3 months. If you only borrow for 3 months the interest rate is actually 2.687%/4 = 0.67175% (always round to 5 decimals when you do calculations). Furthermore, note that these are the rates at which your company borrows and invests. The rates are not borrowing and investment rates from a bank perspective.

Option prices:

Bank applies 360 day-count convention to all currencies. (Students also have to apply 360 days in all calculations). Option premium calculations should include time value calculations based on US $ annual borrowing interest rates for applicable time periods e.g. 3 month $ option premium is subject to 2.687%/4 interest rate.)

Please solve only table 4 and table 5

Table 4: France import cost with option hedge:

Table 5: France: Exchange rate hedges compared:

Which hedging technique should be applied? ________________________________

During the final week of the course, you will submit a paper that will be written as if you were making recommendations to a member of Congress. Imagine that the United States Congress was considering sweeping legislation that would provide intensive regulation of nonprofit fundraising, including the imposition of more filing requirements to the Internal Revenue Service for nonprofits, as well as more active obligations on the part of nonprofit leaders to explain in detail their fundraising strategies, marketing, and fundraising efforts. Imagine also that such legislation would provide greater public oversight of the nonprofit fundraising process, but would also burden nonprofits with significant paperwork and accountability requirements. In your paper, discuss your views on whether or not the federal government should play a much larger role in regulating nonprofits and especially how nonprofits identify donors, collect funds, and spend fundraising dollars. Remember that there are only forty states that have state regulations while ten states have no state regulations at all. For example, there was a significant controversy after 9/11 regarding the American Red Cross because they collected fundraising monies and did not use those funds for the victims of 9/11 -- they instead diverted those funds to other projects of the Red Cross. Here are four questions to help frame your discussion. • Do you believe that government has a strong role to play in the regulation of nonprofit fundraising? • Do you think that states should play a role in regulating nonprofit fundraising? • Should there be a Sarbanes-Oxley-type legislation regarding nonprofit fundraising? • If so, what values should guide politicians as they attempt to set up regulatory systems to ensure that nonprofit fundraising is done in an ethical fashion? Would stronger regulation of nonprofits have a chilling effect by decreasing contributions to nonprofits and diminishing the willingness of individuals to create nonprofits to address serious public crises and controversies?

Moving at its maximum safe speed, an amusement park carousel takes 12 s to complete a revolution. At the end of the ride, it slows down smoothly, taking 3.5 rev to come to a stop. What is the magnitude of the rotational acceleration of the carousel while it is slowing down?

Dr. Pepper, a manufacturer of beverages, is planning to purchase Canada’s Wonderland theme park. Should Dr. Pepper use its own WACC as the discount rate to evaluate the business of Canada’s Wonderland or should it use Canada’s Wonderland’s WACC? Explain your answer

Imagine that patient satisfaction surveys at your hospital criticize overall appearances and attitudes of employees. What lessons in hospitality might you learn from the hotel industry that would be applicable to your organization, and how would you go about learning these lessons?

Which development do you feel was more critical to British success in standing alone during 1940: radar or the work at Bletchley Park? Remember to limit your responses to only the standing alone period and not the entire war. Remember to Cite your work!

whats the extent of search quality, experience quality, and credence quality for each of the following situations:

a. Buying a personal computer

b. Applying to graduate school

c. Setting up a retirement program

d. Dining at a local restaurant e. Visiting a theme park