Subject  Business 
Due By (Pacific Time)  11/11/2017 07:00 pm 
Q2. Comment on the following quote:
“Compound interest is the eighth wonder of the world. He who understands it, earns it ... he who doesn't ... pays it.” â€• Albert Einstein
Q3. Compounding
Your parents have discovered a $1000 bond at the bottom of their safedeposit box. The bond was given to you by your late greataunt Hilda on your second birthday. The bond pays interest at a rate of 5% per annum, compounded annually. Interest accumulates and is paid at the time the bond is redeemed. You are now 27 years old. What is the current worth of the bond (principal plus interest)?
Using excel: FV(rate = ?, nper = ?, pmt = 0, pv = ?, type = 0) = ?
Q4. Discounting
Determine the present value, discounted at 6 percent per year of $50,000 to be received five years from today if the interest rate is compounded:
Semiannually
Quarterly
Excel Hint:
PV(rate = ?, nper = ?, pmt = 0, fv = ?, type = 0) = ?
Rate = (Annual percentage rate) / (number of payments per year)
Q5. Financial planning
Carol Jenkins, a lottery winner, will receive the following payments over the next seven years. If she can invest her cash flow in a fund that will earn 10.5% annually, what is the present value of her winning.
discount rate = 


10.50% 




info 




cash flow 
# of year for discounting 
discounted cash flow 
0 



1 
200000 
?? 
?? 
2 
250000 
?? 
?? 
3 
275000 
?? 
?? 
4 
300000 
?? 
?? 
5 
350000 
?? 
?? 
6 
400000 
?? 
?? 
7 
550000 
?? 
?? 




present value = 
sum of all discounted cash flow 

?? 
Q6. Annuity and mortgage payment
Prepare an amortization schedule for a threeyear loan of $75,000. The interest rate is 8% per year, and the loan calls for equal annual payment.
How much interest is paid in the third year?
How much total interest is paid over the life of the loan? (Hint, see the example in slide).
Hint:
Fixed total payment per year = PMT(rate = ?, nper = ?, pv = ??, fv = 0, type = 0)
Interest expense = beginning principal * interest rate
Fixed total payment = interest expense + principal payment
Ending principal = beginning principal – principal payment
Q7: Uneven cash flow
James Street’s son, Harold, is 10 years old today. Harold, a studious young fellow, is already making plans to go to college on his 18^{th} birthday, and his father wants to start putting money away now for that purpose. Street estimates that Harold will need $18,000, $19,000, $20,000 and #21,000 for his freshman, sophomore, junior, and senior years, respectively. He plans on making these amounts available to Harold at the beginning of each of these years.
Street would like to make eight annual deposits (the first of which would be made on Harold’s 11^{th} birthday, one year from now, and the last on his 18^{th} birthday, the day he leaves for college) in an account earning 10 percent annually. He wants the account to eventually be worth enough to just pay for Harold’s college expense. Any balance remaining in the account will continue to earn the 10 percent.
How much will Street have to deposit in this “planning” account each year to provide for Harold’s education? Hints: Calculate the present value of all the yearend needs. The 8year deposit (yearend payment) is an annuity. The present value of the annuity should equal to the present value of the college expenses.
The present value of yearend needs (Y) = ?
Hint: the sum of the present value for each piece of withdraw.
The yearend payment (x) = ?
Hint: with the result of (Y) from previous step, you can transform the questions into an annuity problem, with Y as the present value of the annuity of x’s
Q7: Pricing and regular and callable bond
Dooley, Inc., has outstanding $100 million bonds that pay an annual coupon rate of interest of 11 percent. Par value of each bond is $1,000. The bonds are scheduled to mature in 10 years. Because of Dooley’s increased risk, investors now require a 13 percent rate of return on bonds of similar quality with 10 years remaining until maturity. The bonds are callable at 110 percent of par at the end of 10 years.
What price would the bonds sell for assuming investors do not expect them to be called?
What price would the bonds sell for assuming investors expected them to be called at the end of 10 years?
Hint: you can use the following template for the solution.
Tutor  Rating 

pallavi 
out of 1971 reviews 
amosmm 
out of 766 reviews 
PhyzKyd 
out of 1164 reviews 
rajdeep77 
out of 721 reviews 
sctys 
out of 1600 reviews 
sharadgreen 
out of 770 reviews 
topnotcher 
out of 766 reviews 
XXXIAO 
out of 680 reviews 