Formula to back into a fee

I feel like this should be easy, but I can't wrap my head around it.

A customer makes a payment of $14,752.40, which includes an interest payment of 1.5%. How would I write a formula that shows how much of this payment is principal and how much is interest?

Principle =A2*0.985
Interest =A2*0.015

Originally Posted by Raphaelp

Principle =A2*0.985
Interest =A2*0.015

Not that easy... by doing that, you come up with $14,531.11 and $221.29, but then if you take $14,531.11 x 1.5% = $217.97.

Thank you! This works, but I finally found the formula I was looking for.

=NPV(0.015,14752.4)