finance

The Acme Company has its European subsidiary based in the Euro zone. The subsidiary must solve a series of five problems that require you to apply the concept of "time value of money," or TVM. The five problems are listed below. Solving them will require the use of Microsoft Excel. Before you begin your work, each student is to select a unique nine-digit random number that contains no zeros, no "patterns," and should use most of the digits between one and nine. This value will be referred to as the student unique number (SUN). Further, digits within the SUN are read from left to right. For example, if the SUN = 123456789, the first digit = 1, the second digit = 2, etc. Please note that the interest rate used in all questions represents an annual rate and all Euro figures are in whole Euros (not Euros and cents).

Acme plans to construct a new manufacturing facility in 14 years. If Acme estimates that today's cost of the new plant is SUN Euros (use all 9 digits) and annual inflation is A% (A = the first digit of SUN), how much will the manufacturing plant cost in 14 years?
Acme has decided to establish a sinking fund for its outstanding preferred stock issue. SUN (use all 9 digits) represents the amount of the issue that will be retired in 26 years. At the beginning of each of these 26 years, Acme will deposit an equal amount into an account that earns B% (B = the second digit of SUN). What is the value of this periodic deposit?
One of Acme's new projects will generate the following cash flows at the end of each of the stated years: year 2 = SUN digits 1-3; year 4 = SUN digits 4-6; year 7 = SUN digits 7-9. If these cash flows are discounted at 12%, what is the sum of their present values?
Acme is assessing its employee pension fund. At the end of each of the next 25 years Acme will have to pay its retirees (use the first 4 digits of your SUN). If the fund is estimated to earn D% (D = the fourth digit of SUN), how much does Acme need to have set aside today to ensure that it can meet its future obligations? (At the end of the 25th year, the balance should be drawn down to zero.)
As part of a new labor contract, Acme has agreed to make a one-time contribution of Euros 1,000,000 to the construction of a new physical fitness facility for its employees. This amount will be placed in an account earning E% (E = the fifth digit of SUN). When the account grows to Euros 1,850,000, construction will commence. How long must employees wait until construction of their new gym begins?

  1. 👍 0
  2. 👎 0
  3. 👁 198
  1. Very creative way to learn to use EXCEL for typical financial calculations. This is more of a "how to use" EXCEL problem than a finance problem. And would be quite difficult to to here in Jishka.
    Repost if you have a specific question.
    Hint: put your SUN in A1
    In B1 put @int($A$1/100000000) which should produce the 1st digit in SUN
    In C1 put @mod(@int($A$1/10000000),10) which should produce the 2nd digit in SUN. Repeat the method in C1 to produce the rest of the digits in SUN

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. social studies

    Which does the European Council do in the government of the European Union? A.passes laws and adopts budgets B.resolves disputes among members C.ensures legislation is applied fairly D.represents the EU globally A recent challenge

  2. Science

    Select the three terms that belong together. To do this, pick one term from each of the three sets. Set 1: intertidal zone, neritic zone, deep zone Set 2: moderate light levels, freshwater, temperature fluctuations Set 3: clams,

  3. social studies

    Because of (blank) , some countries using the euro faced bankruptcy and threatened the value of the euro. A. the refugee crisis B. a lack of ability to elect leaders in the EU C. the financial crisis of 2008 D. britain leaving the

  4. science

    A car has a crumple zone that is 0.80 m (80 cm) long. In this car, the distance from the dummy to the steering wheel is 0.50 m. The car has a mass of 1,600 kg and the dummy has a mass of 75 kg. At the time of the crash, the car

  1. History

    How did New Imperialism impact the political development of Africa? African tribes began to follow the European lead and create empires of their own. Rival African tribes were sometimes placed in the same colony by European-drawn

  2. Social studies

    A recent challenge to the European Union created by a member state is A. Migration B. Free trade C. Brexit D. The euro I want to say C but I am not sure. I'm trying to get help ASAP

  3. Science

    1. Water bubbles up through a hot spring in Yellowstone National Park. What method of heat transfer is this? A. Conduction B. Radiation C. Solar D. Convection 2. Heat transferred between two substances in direct contact with each

  4. Business law

    Ashley sees a maintenance crew from Acme Co. beginning to resurface her driveway, a service she has not contracted for. Ashley thinks a new driveway would be good, so she doesn’t say anything. If Acme sues Ashley for the value

  1. Science.

    2. Select 3 terms that belong together. To do this, pick one term from each of the 3 sets. Set 1: intertidal zone, neritic zone, deep zone Set 2: moderate light levels, freshwater, temperature fluctuations Set 3: clams, squid,

  2. Economcis

    I need some help on the following question, thanks. e = euros Suppose quotes for the dollar-euro exchange rate, E$/e, are as follows: in New York $1.50 per euro, and in Tokyo $1.55 per euro. Describe how investors use arbitrage to

  3. History

    How is Vatican City different from all other European countries? Answers: A: It is located entirely inside another country. B: It is a theocracy. (My Answer) C: It has a Catholic majority. D: It does not use the euro. My Answer: I

  4. English

    Complete the sentences by putting the verb in brackets into the Past Simple or Past Progressive. 1. I saw a light in your window as I ___________________ (pass) by. 2. The student ________________ (answer) the question when the

You can view more similar questions or ask a new question.