Corporate Finance problem set

profileewagker0ku
week_2_problem_set.docx

Week 2 Problem Set

Prepare a spreadsheet that shows your calculations for the following problems for time value and bonds.

Part 1:  Time Value of Money

1.  The value of a house is estimated to be $180,000 today.  (a) If it has increased in value by 4.5% per year for the past 10 years, what was the value 10 years ago? (b) If the house had increased in value by 40% over the entire 10-year period, what would have been the annual percentage increase?

· (a) = 115,907

· (b) = 3.422%

 

2.  Mr. and Mrs. Smith are considering the purchase of a house.  They can budget a mortgage payment (P&I) of $1,400 per month.   (a) If the current mortgage rate is 4.25% for a 30-year mortgage and they make a down payment of 20% of the purchase price, can they buy a house costing $300,000?  (b) What is the maximum amount they can borrow?

· (a) = 1180.66 --> Yes

· (b) = 284,587

 

3.  Mr. Jones bought a car 2.5 years ago and borrowed 25,284.72 from the credit union.  The interest rate was 3.49% for a 5 year loan.  (a) what is the monthly payment on the car?  (b)  What is the current outstanding principal balance on the car loan?

· (a) = 459.86

· (b) = 13,192.73

 

4.  After graduation, you plan to work for Mega Corporation for 10 years and then start your own business.  You expect to save $5,000 a year for the first 5 years and $10,000 annually for the following 5 years, with the first deposit being made a year from today.  In addition, your grandfather just gave you a $20,000 graduation gift which you will deposit immediately.  If the account earns 8% compounded annually, what how much will you have when you start your business 10 years from now?

· 144,944

 

5. You are interested in buying a duplex as an investment.  Your discount rate for evaluating cash flows is 12%.  A property you are considering is expected to produce the following cash flows:

Year

Cash Flow

1

5,500

2

6,500

3

8,500

4

12,500

5

179,000

 What is the present value of these cash flows?

· 125,655

 

6.  An income stream that has a negative flow of $200 per year for 2 years, a positive flow of $300 in the 3rd  year, and a positive flow of $500 per year in Years 4 through 6.  The appropriate discount rate is 4% for each of the first 3 years and 5% for each of the later years.  Thus, a cash flow accruing in Year 6 should be discounted at 5% for some years and 4% in other years.  All payments occur at year-end.  Calculate the present value of the income stream. 

· 1,099.96

 

7.  Prepare an amortization schedule based on the following information:   

You are purchasing a car for $19,500 and you are getting a loan for the entire amount.  The interest rate from Honda Motor Finance Corporation is 9.9% per year.  Your loan in a unique one in that you only have to pay twice per year (at the end of every 6 months).  The loan has a 3-year term, but you plan to make a lump sum payment after 2 years in order to pay off the loan.  Find out what the ending balance on the loan will be after 2 years and complete an amortization table with the following columns filled in for periods 1-4:  Beginning Balance, Payment, Interest, Principal, Ending Balance.

· Ending Balance = 7,137.20

 

8.  Upon graduation, you’ve decided you won’t accept a job unless the total compensation you receive has a present value of at least $90,000.  You have determined that the appropriate interest rate is 6% per year (nominal).  You receive an offer from CBA Inc. where you get paychecks at the end of every 2 weeks (26 times per year).  The offer includes a signing bonus of $5,000 that is paid immediately and a bonus of $7,500 that is paid along with your final (26th) regular paycheck of the year.    How much must your regular paycheck be in order for you to accept CBA’s offer?

· $3,091.83

 

Part 2:  Bond Valuation

1 What is the price of a bond that pays $40 every six months, matures in 20 years and has a yield to maturity of 6.65%? $1,148.14

 

2.  What is the price of a bond that pays $20 every three months, matures in 20 years and has a yield to maturity of 6.65%? $1,148.73

 

3.  What is the coupon rate for a bond that is priced at $917.87, has 5 years to maturity, has an interest rate of 7.5% and pays coupons semiannually ? 5.0%

 

4.  How long until maturity for a bond that is priced at $556.84 with a yield to maturity of 5% and a $1000 face value. The bond makes no interest payments (zero-coupon bond).  Assume annual compounding.  12 years

 

5. What is the yield to maturity for a bond priced at 1106.95 that pays coupons of $13.75 every six months for the next 12.5 years? 1.79%

 

 

6.  Bond X is a premium bond making annual payments. The bond has a coupon rate of 9%, a YTM of 7% and has 13 years to maturity.  Bond Y is a discount bond making annual payments.  The bond has a coupon rate of 7%, a YTM of 9% and has 13 years to maturity. 

 What are prices of the bonds today?

· X=1167.15, Y=850.26

 

If interest rates remain unchanged, what will the bond prices be in 1 year?  3 years? 5 years? 10 years? 13 years?  Discuss what is happening with the bond prices over time.

· X=1158.85, 1140.47, 1119.43, 1052.49 after 1,3,5, and 10 years respectively.

· Y=856.79, 871.65, 889.30, 949.37 after 1,3,5, and 10 years respectively.

 

7.  There are two bonds that have identical 7% coupons, make semi-annual payments and are priced at par. Bond A has 4 years to maturity; Bond B has 20 years to maturity. 

 

What are interest rates today?  7%

If interest rates increase by 2%, what will be the new price of the two bonds?  What is the percentage change in the prices? 

· A=934.04, -6.6% change

· B=815.98, -18.4% change

 

Now assume that interest rates decrease by 2% from where they were originally.  Now that are the prices for the two bonds and what are the percentage changes in their prices?

· A=1071.7, +7.17% change

· B=1251.03, +25.10% change

 

Interest rate risk is a measure of how much a bond’s value changes when interest rates change.  Which of these bonds has the highest interest rate risk?

 

 

8.  There are two bonds that both have 10 years to maturity and have a YTM of 8%. Bond Alpha has a 4% coupon rate (with semi-annual payments) and Bond Beta has a 12% coupon rate (with semi-annual payments).

 

What are prices of the bonds today?

Alpha=728.19; Beta=1271.81

 

If interest rates increase by 2%, what will be the new price of the two bonds?  What is the percentage change in the prices?

Alpha=626.13; Beta=1124.62

 

Now assume that interest rates decrease by 2% from where they were originally.  Now that are the prices for the two bonds and what are the percentage changes in their prices?

Alpha=851.23; Beta=1446.32

 

Interest rate risk is a measure of how much a bond’s value changes when interest rates change.  Which of these bonds has the highest interest rate risk?