Calculate the present value

Assignment Help Case Study
Reference no: EM131157285

Case- The Time Value of Money and Financial Statement Analysis

Solving Present Value and Future Value Problems

You are the CFO (Chief Financial Officer) of ABC Golf Equipment Corporation, a small company that sells golf equipment. Mr. Hillbrandt, the new CEO (Chief Executive Officer) has a marketing background and is trying to learn more about the financial side of running a business. He wants your help and asks for an introduction to the concept of time value of money.

The value of a typical corporate bond is the present value of an annuity plus the present value of a lump sum. Thus, if an individual does not understand how to calculate the present value of a lump sum or the present value of an annuity, it is difficult to determine the value of a typical corporate bond. Thus, in this case assignment, you will work through a variety of time value of money problems to illustrate the idea to the CEO.

The following websites include a number of formulae and financial calculators, including Present Value, Future Value, and Annuity:

Financial calculators. (2015). Calculator Soup. Retrieved from https://www.calculatorsoup.com/calculators/financial/

Carther, S. (2015). Calculating the present and future value of annuities. Investopedia. Retrieved from https://www.investopedia.com/articles/03/101503.asp

Required:

Compute and show your work for the following scenarios:

Calculate the present value of the following lump sums:

  • $100,000 to be received five years from now with a 5% annual interest rate
  • $200,000 to be received 10 years from now with a 10% annual interest rate

Calculate the future value of the following lump sums:

  • $100,000 if invested for five years at a 5% annual interest rate
  • $200,000 if invested for 10 years at a 10% annual interest rate

Calculate the present value of these ordinary annuities:

  • $100,000 to be received each year for five years with a 5% annual interest rate
  • $200,000 to be received each year for 10 years with a 10% annual interest rate

Calculate the future value of these ordinary annuities:

  • $100,000 if invested each year for five years at a 5% annual interest rate
  • $200,000 if invested each year for 10 years at a 10% annual interest rate

Calculate the present value of these perpetuities:

  • $100,000 to be received each year forever with a 5% annual interest rate
  • $200,000 to be received each year forever with a 10% annual interest rate

Computations (use Excel).

1. Show the computations as required above.

2. Summarize the results in an easy to read table at the top of the spreadsheet or on a clearly labeled separate tab.

Memo (use Word).

Interpret the results from the computations and explain how the information is useful. Write a four or five paragraph memo to the CEO. Start with an introduction and end with a conclusion or recommendation. Each of the four or five paragraphs should have a heading.

Short Essay (use Word).

Do research and write a short essay to comment on the use of bonds by public corporations. The emphasis of the essay could be either

  • A discussion of different types of bonds; or
  • The use of bonds in different industries.

Start with an introduction and end with a summary or conclusion. Use headings. Don't forget to reference your sources. Maximum length of two pages.

Reference no: EM131157285

Questions Cloud

What is the dollar amount of income : Barbara purchased a piece of real estate last year for 85,000. The real estate is now worth 102,000. If Barbara needs to have a total return of 25 percent during the year then what is the dollar amount of income that she needed to have reached her..
What is the dollar amount of income : Barbara purchased a piece of real estate last year for 85,000. The real estate is now worth 102,000. If Barbara needs to have a total return of 25 percent during the year then what is the dollar amount of income that she needed to have reached her..
Plan and implement human resourcing : You are expected to deploy resourcing strategies to plan and implement - recruitment of four customer Service representatives plan entice recruitment process
What is the current yield : The 8 percent, $1,000 face value bonds of Sweet Sue Foods are currently selling at $1,084. These bonds have 16 years left until maturity. What is the current yield?
Calculate the present value : Compute and show your work for the following scenarios: Calculate the present value of the following lump sums: $100,000 to be received five years from now with a 5% annual interest rate
What do they say about current cultural values : What is the story and the symbolism involved with the elements in the visual message? What do they say about current cultural values?
Impact of your previous responses to your operations : Elaborate your own definition of production operations management, including manufacturing and service operations. Then, assess the implication of technology in your definition. Lastly, appraise the impact of your previous responses to your Operat..
Projected irrs and costs of capital : Harris Company must set its investment and dividend policies for the coming year. It has three independent projects from which to choose, each of which requires a $3 million investment. These projects have different levels of risk, and therefore d..
Calculating the expected profit : Do 100 simulations on a worksheet and determine the probability Hatch is successful with each of these choices and determine the best of these three by calculating the expected profit.

Reviews

Write a Review

 

Case Study Questions & Answers

  Case study - adobe systems incorporated

While answering the questions, please restrict yourselves to the information provided in the case. Also, try to imagine that this is the time when the case was written, and NOT 2015.

  Construct the nine element of the plan identified above

Construct the nine element of the plan identified above. Analyze the plan for potential problems. Analyze the plan for opportunities

  Case study- age and the workplace

Why is Matthew hesitant about giving Peter negative feedback? List at least three reasons and explain why and  Why was Peter so offended? How should Peter respond to this situation? Substantiate your answer.

  Why does the monument continue to be valued

Why was this monument built-why was it valued by the people at the time? Why does this monument continue to be valued? What is important about its architecture or purpose?

  How depressed demand affect health outcomes in the long run

Read A Case Study of Rural Healthcare in the Economic Downturn and reflect upon the issues identified in Ashe County. How do lack of access and depressed demand affect health outcomes in the long run?

  What impact did his decision have on patient safety

What impact did his decision have on patient safety, on the risk for litigation, on the organization's quality metrics, and on the workload of other hospital departments?

  Issues of the protection period for aboriginal people

Students are required to write a case study on this episode of SBS's First Australians - Episode 3 'Coranderrk'. This lesson is focusing on the period and issues of the Protection Period for Aboriginal people.

  What are the social determinants of health

What are the characteristics of the individuals in this case study - what are the social determinants of health that are evident in the case study?

  What were the factors that shaped indra nooyi as a leader

What were the factors that shaped Indra Nooyi as a leader? What are the factors that could make Nooyi change her decision about corporate sustainability?

  Deliberation of the two phases of emergency management

Definition and deliberation of the two phases of emergency management (pre event) and description of activities associated with each of them.

  What type of bankruptcy agreement would you recommend

What type of bankruptcy agreement would you recommend?  Why?  In your answer be sure to compare at least two types of bankruptcy and the pros and cons of each

  What questions would her sphr friend ask betty smith

What questions would her SPHR friend ask Betty Smith? Do you think it is a good idea for the CEO to bring a gun to work? Justify your response. Consider the Second Amendment

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd