Financial Decision

Only available on StudyMode
  • Download(s) : 216
  • Published : December 9, 2012
Open Document
Text Preview
Contents

1) Find the distribution and report the mean and the standard deviation of the uncertain revenue in $1

2) What is the probability that this revenue will exceed $ 2,250,000?1

3) What is the probability that this revenue will exceed $ 2,500,000?1

4) What is the probability that this revenue will be less than $ 2,150,000?1

5)What is the probability that this revenue will be less than $ 2,000,000?1

6)HSBC offers to pay a sure sum of $2,150,000 in return for the revenue in local currencies. What do you think, is this a good offer for Corvette or not?2

7)In Corvette, the Sales manager is willing to accept HSBC’s offer, but the CEO is not. Who is more risk-averse?2

8) What other risks the bank is taking apart from the uncertainty in the exchange rates?2

9) If the offer is to pay the sure sum in three months’ time rather than in twelve months’ time, would that make any difference? When would the bank and when the company would prefer the payment to be made, and why?3

10) Corvette has accepted HSBC’s offer. Now consider the bank’s risk, assuming the bank will convert all currencies into US dollars at the prevailing exchange rates. What is the probability that the bank will incur a loss?3

11) The bank defines its Value-at-Risk as the loss that occurs at the 5th percentile of the uncertain revenue (5% left tail of the distribution). What is the bank’s Value-at-Risk and what is the bank’s expected profit?3

12) What other options does the bank has if they decide not to convert all/some of the currencies in twelve months’ time?4

13) Collect monthly and weekly data for the four exchange rates into consideration in this exercise for the last (DD+YY) months/weeks up to November 2012 (where DDMMYY is your date of birth). Graph those eight time series, and fit two different linear regressions model into each of them. Comment on which you would prefer and why in each of the eight time series.5

14) With the sixteen models you constructed in Question 13 prepare forecasts for the next MM months/weeks (where DDMMYY is your date of birth).13

Reference List14

Appendix 115

Appendix 216

Appendix 319

1) Find the distribution and report the mean and the standard deviation of the uncertain revenue in $ Then we find the distribution of these 5 kinds of worldwide orders, which are 0.45, 0.29, 0.07, 0,11, 0.08. Then Through the excel, we can use the Formula STDEV, then we can get the standard deviation answer that is $358465.5135, and use the AVERAGE formula, we can get its mean is $435,079.61. 2) What is the probability that this revenue will exceed $ 2,250,000?

The probability that total revenue will exceed $2,250,000 is 1. In this topic, author use the Excel to calculate it. The formula is NORMS. DIST. In the calculation process of the probability, Excel plays an important function for author. Because of this total revenue large than the actual revenue which is $2,175,398.05. Thus its cumulative is true. 3) What is the probability that this revenue will exceed $ 2,500,000?

The probability that total revenue will exceed $2,500,000 is 1. Then author use the same way to get this result. 4)What is the probability that this revenue will be less than $ 2,150,000?

Because this still to calculate probability, but this assumption result that is smaller than the total actual revenue. Then it cumulative time is false. Thus, the probability that total revenue will be less than $2,150,000 is 0. 5)What is the probability that this revenue will be less than $ 2,000,000?

The probability that total revenue will be less than $2,000,000 is 0. This method should be same as the question 4, even about its cumulative, because its revenue also smaller than the actual revenue.

Notes: All the answers from 1) to 5) are...
tracking img