Purchase Solution

Finance problems:present value,future value,payments etc

Not what you're looking for?

Ask Custom Question

Global Finance

DELIVERABLE: Excel spreadsheet

Details: 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).

1) 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?

2) 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?

3) 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?

4) 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.)

5) 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? (Your answer should be accurate to two decimal places, e.g., 1.57 years).

Prepare for Acme's CFO an analysis that contains solutions for all five problems. Be sure to clearly present and label all values and variables, provide Excel TVM formulas, and conclude each question with a brief interpretation of your results. Your entire submission must be contained within an Excel document. (Note: You must use Excel TVM functions to complete this assignment; using a hand calculator or website and plugging values into a template is not acceptable.) Note: The books of the subsidiary being held in Euros, the exchange rate Euro/US dollars has no influence on the result of the exercise.

Purchase this Solution

Solution Summary

The problem set deal with issues in finance: future value, present value,periodic payments for annuity etc.

Solution provided by:
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution

Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.