Present_Value,_Homework_Exercises_using_Excel_Answers -...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Economics 466/566 Bruce C. Dieffenbach University at Albany Present Value—Homework Exercises Using Excel 1. a) The spreadsheet shows the computations. One spreadsheet shows the numerical results, whereas the other shows the underlying formulas. In the formulas, a dollar sign $ signifies an absolute reference to a column or a row. For the commands Copy or Edit Fill, an absolute reference is not changed; but, without the dollar sign, the row or column reference adjusts. b) When R = .10, the present value is 1000. This result is intuitive. If one pays 1000 for the bond and holds it to maturity, evidently the rate of return is 10 per cent per year. The yield to maturity is thus 10 per cent . It follows that the present value of the payments discounted at R = .10 must be 1000. c) When R = .09, the present value is 1064.18. When R = .11, the present value is 941.11. As the interest rate rises, the present value falls; future payments are discounted more heavily, so the pre- sent value is less. Interest Rate 0.10 0.09 0.11 Discount Present Discount Present Discount Present Year Payment Factor Value Factor Value Factor Value 1 100 0.91 90.91 0.92
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/20/2008 for the course ECO 466y taught by Professor Dieffenbach during the Spring '08 term at SUNY Albany.

Page1 / 3

Present_Value,_Homework_Exercises_using_Excel_Answers -...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online