In: Finance
For purposes of this exercise, assume that UPS issues a new ten-year bond for $100,000 (Face Value) that will mature in 2027 (10-Years). The Future Value of this bond is therefore $100,000. The bond was issued in December 2017 at a market interest rate of 5.0% fixed for 10 years, with interest payments made semi-annually (Note: The payment never changes even if the original rate of 5% increases or decrease). What is the Present Value of this bond using the three scenarios in
Part II: Bond Issuance.
Note: The PMT of interest remains constant at 5% semannually in dollars. The Interest Rate of 5% annually is what increases by 2% annually in Q1. and decreases by 2% annually in Q2.
| 
 PART II: BOND ISSUANCE  | 
|||||
| 
 Newly issued 10-year bond  | 
 Calculate the Present Value in the three scenarios below  | 
||||
| 
 Present Value at Issuance  | 
|||||
| 
 Present Value  | 
 PV  | 
||||
| 
 Periods  | 
 N  | 
 Semi-annual payment: 2017-2027  | 
|||
| 
 Interest  | 
 I  | 
 Interest paid semi-annually  | 
|||
| 
 Payments  | 
 PMT  | 
 This bond make regular semi-annual payments of interest (entered in $ dollars semiannually).  | 
|||
| 
 Future Value  | 
 FV  | 
 Future Value in 10 years = Bonds Original Face Value  | 
|||
| 
 1. The new value of the bond if overall rates in the market increased by 2%  | 
|||||
| 
 Present Value  | 
 PV  | 
||||
| 
 Periods  | 
 N  | 
 Semi-annual payment: 2017-2027  | 
|||
| 
 Interest  | 
 I  | 
 Please adjust interest  | 
|||
| 
 Payments  | 
 PMT  | 
 This bond make regular semi-annual payments of interest (entered in $ dollars semiannually).  | 
|||
| 
 Future Value  | 
 FV  | 
 Future Value in 10 years = Bonds Original Face Value  | 
|||
| 
 2. The new value of the bond if overall rates in the market decreased by 2%  | 
|||||
| 
 Present Value  | 
 PV  | 
||||
| 
 Periods  | 
 N  | 
 Semi-annual payment: 2017-2027  | 
|||
| 
 Interest  | 
 I  | 
 Please adjust interest  | 
|||
| 
 Payments  | 
 PMT  | 
 This bond make regular semi-annual payments of interest (entered in $ dollars semiannually)  | 
|||
| 
 Future Value  | 
 FV  | 
 Future Value in 10 years = Bonds Original Face Value  | 
|||