Computation of Future Value, Present Value, and Bond Valuation

PRESENT VALUE AND BOND VALUATION

Assignment Overview

https://static(dot)pexels(dot)com/photos/53621/calculator-calculation-insurance-finance-53621.jpeg

This assignment is in a different direction than your Module 1 Case in that it is mostly computational in nature. Before starting this assignment, work through some of the examples in the background readings to make sure you understand all of the steps involved in future value and present value, including use of present value formulas to compute the value of a bond.
Case Assignment

Please download the Case 2 Template. You will type your answers into this document. Save the document with your last name and submit to the dropbox. Note that you will get partial credit if you show your work even if the answers are incorrect.

1. Compute the future value for the following:

A) $2,000 after being invested for two years in a savings account with 3% interest rate

B) $5,000 after being invested for ten years in a savings account with a 1% interest rate

C) $3,500 after being invested for nine years in a savings account with an 11% interest rate

2. Compute the present value for the following:

A) $3,000 to be paid in one year with a 9% discount rate

B) $3,000 to be paid in three years with a 9% discount rate

C) $4,000 to be paid in ten years with a 5% discount rate

3. Compute the present value for the following:

A) An investment that will pay you $1,000 in one year, another $1,000 in two years, and a third payment of $1,000 in three years (e.g., three payments of $1,000 to be paid once a year for three years). The discount rate is 4%.

B) The same three $1,000 payments as in part a) above, but with a 6% discount rate

C) An investment that will pay you $2,000 in one year, another $1,500 in two years, and a third payment of $3,000 in three years. The discount rate is 4%.

4. Compute the value of the following bonds assuming a 3% discount rate (required rate of return):

A) A zero-coupon bond that pays $1,000 in five years

A bond that pays $1,000 in five years, with five annual coupon payments of $20 each

B) What is the coupon rate if coupon payments are $20 per year? At what discount rate would the value of the bond be “at par” (e.g., be worth $1,000?). Explain your reasoning.

5. This part of the assignment is purely conceptual with no computations required. Explain the following with references to the required readings:

A) What is likely to happen to interest rates if the rate of inflation suddenly increases?

B) Suppose there are two bonds each with coupon payments of $50. The first bond pays $1,000 in five years, and the other one pays $1,000 in ten years. If interest rates increased, would the value of the bonds increase or decrease? Which of the two bonds would have their value change more after the increase in interest rates? Explain your reasoning.

These questions are all included on the template.

https://youtu(dot)be/q97vdwIkSR8 - Please watch this video.

Please make sure you show your work!

Davis, J. (2013, January 5). Present value of a single amount in Excel [Video]. YouTube.

https://www(dot)youtube(dot)com/watch?v=ruIfnNoe1Co&t=85s

Moy, R. (2014, May 22). Present value of multiple cash flows in Excel [Video]. YouTube. https://www(dot)youtube(dot)com/watch?v=kDOIuJbHpLc

Moy, M. (2014, May 29). Bond valuation in Excel [Video]. YouTube. https://www(dot)youtube(dot)com/watch?v=H-_NP0UxX_U

Trident University International. (2021, October 28). Module 2: Present value and bond valuation: Case 2 [Video].

Copy and paste into search engine

https://tridentu(dot)sharepoint(dot)com/_layouts/15/stream.aspx?id=%2FSupport%20Resources%2FTLC%20Course%20Assets%2FTLC%20course%20assets%2Dlive%2FFIN301%20Case%202%2Emp4&ga=1