Aerotron Electronics has just bought a used delivery truck for $15,000. The small business paid $1,000 down and financed the rest, with the agreement to pay nothing for the entire first year and then to pay $546.83 at the end of each month over years 2, 3, and 4 (first payment is in 13th month).

a) what nominal interest rate is Aerotron paying the loan? (please try to show me with goal seek and Excel)

b) what effective interest rate are they paying?

c) how much of the 14th month's payment is interest? how much is principal?

d) how much of the 18th month's payment is interest? how much is principal?

e) how much of the 22nd month's payment is interest? how much is principal?