2. Solve for the missing parameters "?" using Excel; show spreadsheet work:

a)

Market Price: ?

Rate of Return: 10%

Periods: 10

Coupon Rate: 6%

Face Value: $40,000.00

b)

Rate of Return: ?

Periods: 5

Coupon Rate: 10%

Market Price: $2,000

Face Value: $1,000

c)

Coupon Rate: ?

Rate of Return: 4%

Periods: 20

Market Price: $150,000

Face Value: $300,000