CREATE EXCEL SPREADSHEET TO CALCULATE CREDIT CARD PAYMENT
$30-5000 USD
Cancelado
Publicado hace alrededor de 14 años
$30-5000 USD
Pagado a la entrega
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