Reply
Valued Contributor
Pupeitmeister
Posts: 1,161
Registered: ‎11-11-2013
0

Re: The GREAT CC Payoff Challenge!!

Thank you for the algorithm. It looks like greek to me, but i am learning slowly!!

OFFICIAL GARDEN START DATE: 10-05-2014... TARGET GARDEN END DATE: 06-01-2016 Lets Git 'r' dun
Established Contributor
titanofold
Posts: 558
Registered: ‎11-13-2013
0

Re: The GREAT CC Payoff Challenge!!


Pupeitmeister wrote:
Thank you for the algorithm. It looks like greek to me, but i am learning slowly!!

Hmm... I should probably explain it.

 

=IFERROR(ROUNDUP(-(LOG10(1 - ((E11/12 * B11)/H11))/LOG10(1 + E11/12))), IF(AND(B11 > 0, F11 >= 0),"∞",0))

 

Column E holds the interest rate, column B holds the current balance, column H holds the payment you're going to make, and column F holds the minimum required payment. So, E11 references the interest rate in column E on row 11.

 

I've gussied it up a bit so that instead of showing an error when there aren't any payments to be made it'll show 0, or if the payments you're making are insufficient to overcome the interest, the infinity symbol. Still, it could probably use a little more work to be bullet proof, but I'm not writing accounting software here. Just estimations.

Scores2013-09-21Current
Equifax630 (LP)621 (Quizzle)
Experian640 (FCR)682 (FCR)/673 (CS)
TransUnion588 (CK)664 (CK)
Regular Contributor
credit_challenged09
Posts: 185
Registered: ‎01-15-2009
0

Re: The GREAT CC Payoff Challenge!!

going to  transfer my usaa balance to discover - 14 months 0% interest.  my plan is to pay off by July.

 

 

creditorcredit limitcredit balanceutilization
USAA$2,500$1,15546.2%
Wells Fargo$1,000$666.6%
Cap One$300$3010.0%
walmart$400$307.5%
nordstrom$500$448.8%
discover$2,000$57528.8%
macys furniture$3,200$1,80556.4%
    
 Total Debt$3,705 
FICO Scores: (EX-735-11/12) EQ-746-12/03 (TU-750-11/12)
Discover FICO: 750 - 11/17 Walmart FICO: 750 -11/08
USAA FAKO: EX-742 EQ-761 TU-743

Macys $2.5k - USAA Secured $2.5k - NFCU $20k - Discover $2.5k - Cap One $2000 - Nordstrom $3.5k - Wells Fargo $1k - Walmart $2.3k- The Limited $700 - Victoria's Secret $1.5k- Bloomingdales $2k- JCP $700
Established Contributor
titanofold
Posts: 558
Registered: ‎11-13-2013
0

Re: The GREAT CC Payoff Challenge!!


credit_challenged09 wrote:

going to  transfer my usaa balance to discover - 14 months 0% interest.  my plan is to pay off by July.

 

 

creditorcredit limitcredit balanceutilization
USAA$2,500$1,15546.2%
Wells Fargo$1,000$666.6%
Cap One$300$3010.0%
walmart$400$307.5%
nordstrom$500$448.8%
discover$2,000$57528.8%
macys furniture$3,200$1,80556.4%
    
 Total Debt$3,705 

If you don't have a BT fee with Discover, that's a good way to go. You'll probably save yourself a payment or two.

Scores2013-09-21Current
Equifax630 (LP)621 (Quizzle)
Experian640 (FCR)682 (FCR)/673 (CS)
TransUnion588 (CK)664 (CK)
Regular Contributor
credit_challenged09
Posts: 185
Registered: ‎01-15-2009
0

Re: The GREAT CC Payoff Challenge!!

just checking in..  5 months to go...will make an extra paymnt or two on the bigger balances.  good luck to those in the challenge!

FICO Scores: (EX-735-11/12) EQ-746-12/03 (TU-750-11/12)
Discover FICO: 750 - 11/17 Walmart FICO: 750 -11/08
USAA FAKO: EX-742 EQ-761 TU-743

Macys $2.5k - USAA Secured $2.5k - NFCU $20k - Discover $2.5k - Cap One $2000 - Nordstrom $3.5k - Wells Fargo $1k - Walmart $2.3k- The Limited $700 - Victoria's Secret $1.5k- Bloomingdales $2k- JCP $700
New Visitor
spt1224
Posts: 4
Registered: ‎02-08-2014
0

Re: The GREAT CC Payoff Challenge!!

Challenge Accepted! And boy what a challenge it will be, lol.

Seemed like the perfect thread for this longtime lurker to come out of the shadows :smileyhappy:

My wife and I are currently in the middle of paying down our mountain of debt aggressively while we are in the position of not having a mortgage or rent or other housing-related expenses to pay. We live with my parents currently, but buy our own groceries, and pay the cable/internet bill every month, as well as the occasional water or electric bill to help my parents out (not consistently).

I have variable income and my wife isn't making anything currently, so it is hard to plan ahead. However, as a freelance Web Application Developer, I am in the lucky position to have as many hours of work available to me as I can possibly handle... so at the end of 2013 I decided to step up my game and not waste the opportunity. Paying this all off is just a matter of me staying as focused as possible for as long as possible.

Most of the debt was accumulated 4-5 years ago when we had much less income than we do now. We both very much look forward to the day when we don't have all this debt hanging over our heads any longer, and I see that day coming very soon. My ambitious goal is to have everything paid off by July, but as always taxes are going to make that difficult.

 

As you'll see, much progress has been made in the new year. I am working on my credit score first since I'm the one with the income. Next step: Paying Capital One down to $0. (I hope they don't balance chase us!)

 

We are opening an account with NFCU next week; fingers crossed for a useful limit for BTs. Then, I am hopeful that my other creditors will be generous with CLIs once they see my higher scores and some responsible use out of me.

Following are tables of all our credit cards as of 2013-12-31, and then as of today... first my cards, then my wife's.

My Credit Cards as of 2013-12-31

#CardLimitBalanceUtilAPRInt./Month
1Capital One Platinum$2,000$2,006100.3%18.90%$31.59
2Walmart Discover$2,500$2,38495.4%22.90%$45.49
3Capital One (Household Bank)$500$43887.6%19.99%$7.30
4Zales$1,600$31519.7%0% (28.99%)$0.00
5CareCredit$2,500$2469.8%26.99%$5.53
6BillMeLater$825$77994.4%19.99%$12.98
7Citi Diamond Preferred$1,000$98998.9%19.99%$16.48
8Discover More$1,700$1,69299.5%22.99%$32.42
  $12,625$8,84970.1% $151.78

 

Wife's Credit Cards as of 2013-12-31

#CardLimitBalanceUtilAPRInt./MonthAU - On My Credit Reports
1Capital One$15,200$15,18899.9%15.80%$199.98Yes
2Fifth Third Platinum$1,000$93893.8%12.99%$10.15 
3Amazon Store Card$3,500$3,28893.9%25.99%$71.21 
4Newegg Preferred$5,600$5,27994.3%25.99%$114.33 
5BillMeLater$1,649$1,60797.5%19.99%$26.77 
6VS Angel$1,700$1,64796.9%24.99%$34.30 
7Capital One (5/3 Optimum)$500$46192.2%20.24%$7.78Yes
8David's Bridal$1,500$0 0%26.99%$0.00 
9Discover More$1,000$97797.7%0%$0.00Yes
10AAA Financial$8,000$2,35029.4%0%$0.00 
11Chase Slate$500$46492.8%0%$0.00 
12Kohl's$300$25886.0%23.99%$5.16 
  $40,449$32,45780.2% $469.68 

 

As of 2014-02:
EX 686, TU 670
Wife's TU: 709
New Visitor
spt1224
Posts: 4
Registered: ‎02-08-2014
0

Re: The GREAT CC Payoff Challenge!!

To conclude my prior post...

 

My Credit Cards as of 2014-02-08

#CardLimitBalanceUtilAPRInt./Month
1Capital One Platinum$2,000$00%18.90%$0.00
2Walmart Discover$2,500$00%22.90%$0.00
3Capital One (Household Bank)$500$00%19.99%$0.00
4Zales$1,600$29018.1%0% (28.99%)$0.00
5CareCredit$2,500$2218.8%26.99%$4.97
6BillMeLater$825$75491.4%19.99%$12.56
7Citi Diamond Preferred$1,000$00%19.99%$0.00
8Discover More$1,700$00%22.99%$0.00
  $12,625$1,29010.0% $17.53

 

Wife's Credit Cards as of 2014-02-08 (Changes only)

#CardLimitBalanceUtilAPRInt./MonthAU - On My Credit Reports
7Capital One (5/3 Optimum)$500$00%20.24%$0.00Yes
9Discover More$1,000$00%0%$0.00Yes

 

As of 2014-02:
EX 686, TU 670
Wife's TU: 709
Frequent Contributor
aubie1kenobie2
Posts: 293
Registered: ‎12-16-2013
0

Re: The GREAT CC Payoff Challenge!!


spt1224 wrote:

To conclude my prior post...

 

My Credit Cards as of 2014-02-08

#CardLimitBalanceUtilAPRInt./Month
1Capital One Platinum$2,000$00%18.90%$0.00
2Walmart Discover$2,500$00%22.90%$0.00
3Capital One (Household Bank)$500$00%19.99%$0.00
4Zales$1,600$29018.1%0% (28.99%)$0.00
5CareCredit$2,500$2218.8%26.99%$4.97
6BillMeLater$825$75491.4%19.99%$12.56
7Citi Diamond Preferred$1,000$00%19.99%$0.00
8Discover More$1,700$00%22.99%$0.00
  $12,625$1,29010.0% $17.53

 

Wife's Credit Cards as of 2014-02-08 (Changes only)

#CardLimitBalanceUtilAPRInt./MonthAU - On My Credit Reports
7Capital One (5/3 Optimum)$500$00%20.24%$0.00Yes
9Discover More$1,000$00%0%$0.00Yes

 


Congrats on getting your credit cards balances down! Great job!  Guess your next project is your wife's Cap One (#1)?


Starting Score: No credit history in July 2013, 663 in August (lender pulled)
Current Score: 721 (Discover FICO), 704 (DCU EQ)
Ultimate goal: Buy a house in 2016!
Gardening until December 2014 :-)
New Visitor
spt1224
Posts: 4
Registered: ‎02-08-2014
0

Re: The GREAT CC Payoff Challenge!!

[ Edited ]

aubie1kenobie2 wrote:
Congrats on getting your credit cards balances down! Great job!  Guess your next project is your wife's Cap One (#1)?

Yep. It's not our highest interest card, but it will feel great to have it out of the way and be halfway to our goal. Will help both our utilization ratios greatly.

As of 2014-02:
EX 686, TU 670
Wife's TU: 709
Valued Contributor
newmomnewme
Posts: 1,305
Registered: ‎09-30-2013
0

Re: The GREAT CC Payoff Challenge!!


Pupeitmeister wrote:

newmomnewme wrote:

Ok, I am in. I wish I could have used the NFCU balance transfer....can't pay my NavCheck with a BT to cashRewards right?? lol...

 

Due 8th- NavCheck- 4.5k/7.5k 15%

Due 2nd- Barclays MC- 400/500 0% until 4/14

Due 7th- Cap1 QS Visa- 0/1k 19.8%

Due 3rd- Victorias Secret- 0/300 28%?? I just know its high....

Due 17th- NFCU Visa- 0/20k 12% 10k CLI 2/11/14

 

Due 15th- Cap1 QS MC- 0/750 22%

Due Not Sure- Macys 0/400 ??

Due 2nd- Target 0/200 ??

 

I just planned on paying about $500 monthly on the NavCheck, I may boost it up to $700 and have it paid off before 2014 holidays. I use the Barclays and QS for groceries and gas (rewards)....so should I be using them for rewards and PIF each month?  Maybe I could switch out the QS Visa for MC to give me more time to pay? I could use a different paycheck for each...Barclays stinks because the limit is so low....I can't get all of my shopping and gas done with it. 

 

Help!!!!


Welcome in Newmomnewme!.. Ok.. Lets see here.. It is too bad you couldn't take advantage of the 2.9 on NFCU.. That would help a bunch.. either way.. this is still doable. I would PIF the Visa, along with the Barclays and the Capone, or leave a small balance if you need a statement to cut for possible CLI on that VS.. (by small I mean less then 5 bucks, let it roll, go pick up the 6 for 20 deal next month if they have it, and pay off again to like 3 bucks. don't give them any more then the minimum interest, just so you can get the Statement cut for possible CLI.. (if you want that after 4 statements)...

 

Which NFCU Visa is that? If you aren't using it for rewards, go ahead and PIF that one too... and let it sit while you steady push on that Navcheck.

 

Are you planning any additional apps for now or are you gardening?

 

We can knock out a TON of debt if we use each other for motivation and support!.


I had to search high and low to find this discussion....Pup, I just wanted to say "Thanks" for starting this challenge. Since my last post, I paid off three small balances on NFCU, QS Visa, and VS. I also paid 1k of the NavCheck down. Barclays is 0% for a few more months, I just wish the CL was a little higher so I could actually USE the card. BUT, since then I have also acquired two new Amex's (PRG and BCE).  I plan to SD all cards except the BCE and QS Visa....and I will be PIF each month. 

 

I am hoping to get a decent bonus from work mid March and I should be able to pay off NavCheck. I still have a personal loan with another CU and my auto loan that was just refi with NFCU, so I will be stalking this thread to check-in and provide support for others. 



Starting Score: May 2013 EQ: 577 TU: 537 EX: 555
Current Score: EQ: 600 TU: 644 EX: ??
Goal Score: ALL 720+

In the Garden Until August 2015 Last App Sept 2014
border="0"Take the myFICO Fitness Challenge

myFICO is the consumer division of FICO. Since its introduction 20 years ago, the FICO® Score has become a global standard for measuring credit risk in the banking, mortgage, credit card, auto and retail industries. 90 of the top 100 largest U.S. financial institutions use the FICO Score to make consumer credit decisions.

>> About myFICO
FICO Score - The Score that matters
Click to Verify - This site chose VeriSign SSL for secure e-commerce and confidential communications.
Fair Isaac Corporation is a BBB Accredited Financial Service in San Rafael, CA
FOLLOW US Social Media Facebook Twitter Pinterest Google+
}