Required:

Part 1 (15 pts)

Based on the table below set up a schedule/table in Excel and solve the missing component. Use a financial formula in Excel to solve. Make sure to LINK all the information. (Label your sheet - Prob 1 Part 1) Part 2 (10 pts) In Excel in the same workbook copy and paste your schedule completed from part (1) to a new sheet (Label the sheet Problem 1

Description Bond 1 Bond 2 Bond 3 Bond 4

Face Value $200,000.00 $200,000.00 $400,000.00 400,000.00

Coupon Rate/stated rate 5.00% 4.00% 3.00% 4%

Interest payments paid per year 2 1 2 4 Maturity (Years) 15 20 30 25

Effective rate 7% 5% 2% 5%

Periodic interest payment $5,000.00 $8,000.00 $6,000.00 $4,000.00

Bond Sale Price (Carrying Value) ? ? ? ?