assist w6

Week 6 - Assignment 2: Calculate Rate of Return

For this assignment, you will build a 1-page Excel spreadsheet to solve the following scenario:

Six years ago, Bradford Community Hospital issued 20-year municipal bonds with a 7% annual coupon rate. The bonds were called today for a $70 call premium—that is, bondholders received $1,070 for each bond. What is the realized rate of return for those investors who bought the bonds for $1,000 when they were issued?

The completed assignment should address all of the assignment requirements, exhibit evidence of concept knowledge, and demonstrate thoughtful consideration of the content presented in the course.

Length: 1 Excel workbook with a 1-page summary explaining your calculations and 3 scholarly/credible references.