Present Value and Future Value

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION

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 http://www.calculatorsoup.com/calculators/financial/

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

Required:

1.Compute and show your work for the following scenarios:

2.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

3.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

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

5.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

6.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)***.

Show the computations as required above.
7.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)***.

8.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*.

**Assignment Expectations**
Each submission should include two files: (1) An Excel file; and (2) A Word document. The Word document shows the memo first and short essay last. Assume a knowledgeable business audience and use required format and length. Individuals in business are busy and want information presented in an organized and concise manner.

Sample Solutions

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution

Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.

Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.

Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services