You have just taken out a $15,000 car loan with a 8% APR, compounded monthly. The loan is for five years. When you make your first payment in one month, how much of the payment will go toward the principal of the loan and how much will go toward interest?

When you make the first payment, $ ________ will go toward the principal of the loan and $ _________ will go toward the interest.

I NEED an EXCEL FUNCTION or FORMULA (with a table- if needed)