Suppose you have a car loan for $15,000 over 30 months from the auto dealer that charges no interest, but if a monthly payment is missed you will be charged 18% interest on all previous and future monthly payments. A new credit card offer says you can transfer any existing balance on a loan into your new card and will be charged only 15% interest, compounded daily, with a minimum monthly payment of only $200. Explain whether the new card would result in less interest paid by you, showing your calculations.

if you can show me how its done in excel that would be great