Homework answers / question archive / Use a spreadsheet as needed to complete the items below

Use a spreadsheet as needed to complete the items below

Business

Share With

---

Use a spreadsheet as needed to complete the items below.

a) Compute the present value of a revenue stream of 10 payments (starting next period) of 100,000 when the interest rate is 10% and the depreciation rate on the capital investment is 3%.

b) You might want to copy the original sheet before continuing. Compute the present value of a bond that pays 10,000 at the end of ten years (t = 10) while also paying 500 each year (including the tenth, so t = 1 through 10) if the interest rate is 3%. Note that depreciation does not apply.

c) We can reverse this problem. If the market price for the bond in item b is 9500, what is the interest rate (to at least two decimal places)? Play around with the interest rate values to find out (or try Goal Seek in Excel).

d) Keep in mind that one might be able to buy as many bonds as you want at the market price. In fact, at least for the purposes of this question, even fractional amounts are possible! Assuming the bonds in part b are available for a price of 9500, what is the most a profit motivated investor should spend upfront for the project in part a?

e) How might liquidity concerns influence an investor’s answer to part d? Does it matter if the project in part a is also funded by issuing bonds?

Only part d and e