Attached are two example problems and the problme worksheet itself.
Complete the following problems. For assistance, you may want to refer to these examples. The Excel spreadsheet shows the calculations for two parts of the problem listed in the Word document. use the weeks 07 problem excel spreadsheet to answer the below issues
Download the Week 07 Problems Excel spreadsheetto use in completing your problems.
Which should he buy, if the yield and tax consequences are the only variables?
Principal amount $1,000 Semi-annual interest $50 Maturity 10 years
(When asked for a % yield, round yields to nearest tenth of a percent, such as 10.1 %.)
How much will you have when the bond is retired after 12 years? What was the annual return you earned on this investment?