Credit Card Calculation
Hi
I was wondering if anyone could help me with a minimum payment calculation on my spreadsheet for my Credit card I have the following Cells Credit Limit (L2) £3500 Credit Card Amount Owed (L4) £3200 Credit Card APR (L6) 17.9% Minimum Amount (L8) 2% And then I have a cell (L10) Minimum Payment and it is in this Cell I want it to say what my minimum payment will be if you could help with this that would be great Regards Joel -- N/A |
Credit Card Calculation
Hi,
Not sure if this is it but try this: =ROUNDDOWN((ROUND((L6/12)*L4,2)+L4)*L8,0)-ROUND((L6/12)*L4,2) I don't know anything about finances but from what I was read on the net I got this: 3200 *(17.9%/12) =47.73 (3200+(17.9%/12))*3%=64 ...( 64.9546 rounded down) minimum payment: 64-47.73=16.27 HTH Jean-Guy "Joel" wrote: Hi I was wondering if anyone could help me with a minimum payment calculation on my spreadsheet for my Credit card I have the following Cells Credit Limit (L2) £3500 Credit Card Amount Owed (L4) £3200 Credit Card APR (L6) 17.9% Minimum Amount (L8) 2% And then I have a cell (L10) Minimum Payment and it is in this Cell I want it to say what my minimum payment will be if you could help with this that would be great Regards Joel -- N/A |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com