Green company has accepted a note in the amount of $2,300,000. The note is due in fifteen years and has an annual coupon rate of 8%, paid quarterly. Market interest has been fluctuating in recent weeks, and the treasurer or the company would like to know the present value of the note.

Determine the present value of the note assuming market interest rates for similar notes are:

9%

5%

(extra explanation: I want to know if tables are needed like present value of 1, future value of 1, present value of ordinary annuity 1, future value of ordinary annuity 1, or is it only based on calculations of the given problemjQuery22406694186349897231_1588205219839)

Use excel to make an amortization schedule for the note both scenarios using the effective interest method.

Assume that the present value of the note is $1,600,000 . Using excel, calculate the annual effective interest rate for the bond. (round to 4decimal points)