CREATE EXCEL SPREADSHEET TO CALCULATE CREDIT CARD PAYMENT

UPDATE: THIS PROJECT IS BASICALLY A CLONE OF <[login to view URL]> HOWEVER, THE MAIN DIFFERENCE IS THAT THE SPREADSHEET SHOULD BE ABLE TO CALCULATE WHAT IS THE IMPACT OF $ X AMOUNT OF MONEY i HAVE IN MY HANDS TO PAY MY TOTAL DEBT OVER A PERIOD OF TIME I SELECT. EXAMPLE, MY TOTAL DEBT IS $12,800 DOLLARS AMONG DIFFERENT CREDIT CARDS WITH DIFFERENT INTEREST RATE, ETC.? SO, IF I HAVE $300 IN MY HANDS, AND i WANT TO PAY MY DEBT IN (LET'S SAY, 8 MONTHS), WHERE WILL THE $300 BE MOST BENEFITIAL TO PUT INTO ?? CREDIT CARD 1, 2, 3, 4 ?? ORIGINAL POSTING: I need to have an Excel spreadsheet that will do the following: 1) Allow me to enter all my credit card names, amounts dues, dates due, percentage rate due and interest payment. The spreadsheet should be able to calculate the following: 1) The amount of time it wil take me to pay off a loan based on the minimum scheduled payments or if I make extra payments. 2) Calculate the total amount of interest to be paid over the period of time selected. It could be 1 month to 36 months.? ? ? Microsft has various template, but they all allow to enter years, not months.? ? If I want to pay acredit card in 5 months, the current templates won't allow me. 3) Let's say that I decide to pay ALL my credit cards in 8 months.? So, the question is the following. If I get in my hands $300 dollars, the spreadsheet should calculate where it will cause the biggest impact in terms of savings.? ? ? Example: If I owe $7,500 dollars in credit card 1 at 29% percentage rate,? and $12,800 in another card with a 10.6% percentage rate, where will the $300 have a better impact in the 8 month limit I choose to pay all my cards.? 4) When I enter the number of months I wish to pay ALL my cards, the system will calculate all principal charges and interest, so I have a global idea of how much I will pay in principal and interest on a per month and overall timeframe selected.? I can choose between 1, 2, 3, 4, or any number of months.? ? If I select 12 months, the results are somwhat like the one shown on this page: <[login to view URL]> ## Deliverables YOU CAN USE SOME OF THE MICROSOFT TEMPLATES AS REFERENCE, BUT THIS IS A UNIQUE PROJECT NOT FOUND ON MICROSOFT'S OFFICE TEMPLATES