custom writing services

Need help: Write an email to our support staff support@myprivatementor.com or


whatsapp us

order order
Average score 4.97 out of 5 based on 836 opinions

finance 654

Excel+ 1 page memo+2 page paper
100% original work needed and asap
 
Module 1 – Case

The Time Value of Money and Financial Statement Analysis

Case Assignment

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 fromhttp://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).

Show the computations as required above.

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.

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.

NEED TO MAKE AN ORDER? HERE IS HOW IT WORKS

order-process

Need an answer from similar question?Click here and get a solution now

order You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. banner We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school
Undergrad.(yrs 1-2)
Undergrad.(yrs 3-4)
Master’s
Doctoral
$10 / page
$10/ page
$12/ page
$15 / page
$17/ page

Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written? Myprivatementor.com  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at myprivatementor.com  for guaranteed  high grades. order download

we offer gifts to our paper help customersPayment Methods

you can request our services and pay via paypal

we offer gifts to our paper help customersOur Guarantees

  1. Zero plagiarism.
  2. 100% confidentiality.
  3. FREE Reference page
  4. High Quality papers
  5. 24/7 Customer support

Our Testimonials Testimonials

I ordered a 7 page college essay and was delivered on time. Thank you guys I will definitely order again!

9.5
, FL

Our statisticsOur Statistics

  • Orders Completed todate 72387

  • Number of writers 500

  • Satisfied customers 99.7%

  • Returning customers 92.3%

  • Orders placed today 87