I'm not sure this answer is corecct or not. Could you check it ?

Bond Discount Problem:On January 1, 2017, Waterfall Lodge & Amusement Park issued $6,000,000 of 6% bonds, due in 10 years. The market interest rate for bonds of similar risk and maturity is 7%. Interest is paid semiannually on June 30 and December 31 each year.

Face amount

$ 6,000,000.00

Class hour:

On-Line

Interest payment

$ 105,000.00

Blue cells can be typed in, yellow cells must be formulas or functions.

Market interest rate per period

3.5%

Note: Hover your mouse to any cell with a red flad in the upper right hand corner to read the hint.

Number of periods

20

The data for this bond can be found in the word document "instructions" in the lab 2 modules in Canvas

Issue price

$ 4,507,697.65

Note: All cells in the table should be formulas or functions ( dont just enter text) except the date column. You can type those in if you want.