• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Car Payment Calculator Using Excel

A

austin316

Diamond Member
Ok, could someone point me in the direction on how to set up Excel so I can state the amount of payments for my car loan, the interest rate, and the amount being financed and be shown how much of each payment goes towards the interest and how much towards the principal?

I know how to set it up using the PMT financial function to see how much in total I will be paying towards interest, but not a breakdown of each month.

Thanks in advance.
 
PPMT give the principal portion of the payment. Subtract from total payment to get interest amount? IPMT does the same thing for the interest portion.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top