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. 👁 97
  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. Advance Accounting

    On January 1, 20X1, Parent Company acquired 80% of the common stock of Subsidiary Company for $560,000 On this. date Subsidiary had total owners' equity of $540,000, including retained earnings of $240,000. During 20X1, Subsidiary

    asked by carol on November 30, 2012
  2. accounting

    I am attempting to study for an exam for tomorrow and cannot figure out the equity method entries up to 2006 for this problem, can someone please help! Parent Corporation owns 80% of Subsidiary Corporation’s outstanding

    asked by Bob on April 5, 2010
  3. International business

    You are the chief executive officer of a multinational’s subsidiary in a developing host country. The subsidiary has been in business for about eight years, making electric motors for the host country’s domestic market, with

    asked by Tracy on May 29, 2007
  4. business

    o What are the advantages of the four different special journals? When would you use each type? o What is a subsidiary ledger and what purpose does it serve? o What is a control account and what purpose does it serve? o Which two

    asked by brit on April 16, 2010
  5. finance

    Parent, Inc. is contemplating a tender offer to acquire 80 percent of Subsidiary Corporation's common stock. Subsidiary's shares are currently quoted on the New York Stock Exchange at $85 per share. In order to have a reasonable

    asked by Anonymous on February 4, 2011
  6. government

    given that a major crisis facing the G20 is the value of the Euro in certain Euro zone countries, what role should the u.s. play? what is U.S. business exposure if the Euro zone collapses?

    asked by mary on October 25, 2011
  7. Civics

    Beginning in 1995, most countries in the European Union started to switch to a common currency. The values of different European currencies were linked to the euro. Countries in the European Union could then trade without

    asked by laura on May 18, 2016
  8. business

    What are the benefits to Britain, Sweden, and Denmark of staying out of the euro zone? What are the potential costs? Do you think these countries will eventually join the euro zone? Under what circumstances will they join?

    asked by Gregory on April 8, 2008
  9. business

    What are the benefits to Britain, Sweden, and Denmark of staying out of the euro zone? What are the potential costs? Do you think these countries will eventually join the euro zone? Under what circumstances will they join?

    asked by lisa on April 8, 2008
  10. History

    Which term most accurately defines the practice of seeing things from the European perspective and believing that European culture is preeminent? Eurocentrism Euro-eminence Euro-paramountcy Europrominence A??

    asked by Ryder C. on June 6, 2019

More Similar Questions