Jump to content

credit card spreadsheet


breeze
 Share

Recommended Posts

  • 3 weeks later...

  • 2 weeks later...

After lurking on this site for several weeks, your SS is what made me decide to actually sign up. This thing is great, I'm going to have my weekend full of filling this thing out and seeing exactly where I stand.

 

For any improvements for the 2009 version I do like the "snow ball" that was mentioned before.

 

Also, did you end up making the sheet for installment loans?

Link to comment
Share on other sites

I'm glad everone still likes the sheet!

 

Like I said I am working on some inprovments but becasue I do it in my sapre time it does take some time. I hope to have a Beta version out (To some of you like I did last year) by 1st week of June.

Link to comment
Share on other sites

After lurking on this site for several weeks, your SS is what made me decide to actually sign up. This thing is great, I'm going to have my weekend full of filling this thing out and seeing exactly where I stand.

 

For any improvements for the 2009 version I do like the "snow ball" that was mentioned before.

 

Also, did you end up making the sheet for installment loans?

I do have an installment one that was not created by me; it's just a generic sheet. I working to incorporate it into the new sheet I do. My sheet will NOT have any option for doing snow ball calculations.
Link to comment
Share on other sites

  • 2 weeks later...
  • 3 months later...
  • 3 weeks later...
  • 4 weeks later...
  • 3 weeks later...

Thanks for creating and posting this great spreadsheet, but I have some questions.

 

Ones all the amounts are entered, does it update automatically? How do you do that?

For example, I've completed the spreadsheet few months ago, no card usage since then. How can I see the updated numbers on todays date?

 

Thanks

 

 

.

Link to comment
Share on other sites

Thanks for creating and posting this great spreadsheet, but I have some questions.

 

Ones all the amounts are entered, does it update automatically? How do you do that?

For example, I've completed the spreadsheet few months ago, no card usage since then. How can I see the updated numbers on todays date?

 

Thanks

 

 

.

No auto updates, info has to be entered manually.
Link to comment
Share on other sites

  • 4 weeks later...
  • 2 weeks later...
  • 2 weeks later...
  • 5 weeks later...
  • 5 months later...

It's been almost six months since anybody said "Thank You" for this spreadsheet. Thank you nyrfann!

 

@vickyrola (12-11-09) Most cards have a minimum payment of $20.00, so the sheet calculates your minimum for you.

 

If the amount in column D is less than $2,000, it shows a minimum payment of $20 is due. If the amount in column D is $2,000 or more, it shows what the minimum payments would be if your card requires 1%, 2% or 3% minimum payments.

 

 

Then I found an error nyrfann - Columns G, H and I read:

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*G$2))

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*H$2))

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*I$2))

 

They should read:

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*G$2))

=IF($D7=0,"",IF($D7*$H$2<20,20,$D7*H$2))

=IF($D7=0,"",IF($D7*$I$2<20,20,$D7*I$2))

 

That causes the the H and I columns to reflect the greater of 2% or 3% or $20.00. As it currently sits, column I's 3% of $1,999.99 is calculated at the minimum value of $20.

 

To further mess up columns G-I, if the amount in column D is <$20, it still shows $20 as the minimum payment. I don't know how to write that IF statement.

 

I'm not an Excel expert, I know just enough to be dangerous. If I'm wrong, please be gentle.

Link to comment
Share on other sites

  • 2 weeks later...
It's been almost six months since anybody said "Thank You" for this spreadsheet. Thank you nyrfann!

 

@vickyrola (12-11-09) Most cards have a minimum payment of $20.00, so the sheet calculates your minimum for you.

 

If the amount in column D is less than $2,000, it shows a minimum payment of $20 is due. If the amount in column D is $2,000 or more, it shows what the minimum payments would be if your card requires 1%, 2% or 3% minimum payments.

 

 

Then I found an error nyrfann - Columns G, H and I read:

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*G$2))

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*H$2))

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*I$2))

 

They should read:

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*G$2))

=IF($D7=0,"",IF($D7*$H$2<20,20,$D7*H$2))

=IF($D7=0,"",IF($D7*$I$2<20,20,$D7*I$2))

 

That causes the the H and I columns to reflect the greater of 2% or 3% or $20.00. As it currently sits, column I's 3% of $1,999.99 is calculated at the minimum value of $20.

 

To further mess up columns G-I, if the amount in column D is <$20, it still shows $20 as the minimum payment. I don't know how to write that IF statement.

 

I'm not an Excel expert, I know just enough to be dangerous. If I'm wrong, please be gentle.

I am not sure what you are referring to here, but there is no error. To formula is written correctly and everything calculates correctly.

 

The default $20 is the minimum payment for most c/c unit you reach the threshold where a % kick in. This is why the $20 is for any small balance.

Edited by nyrfann
Link to comment
Share on other sites

The default $20 is the minimum payment for most c/c unit you reach the threshold where a % kick in. This is why the $20 is for any small balance.

 

If my balance is $1,800, what is my minimum payment if the threshold is 3%? Is it $20 or $54?

 

I'm not trying to be argumentative, I'm an Excel geek wanna-be - someone who knows just enough to be dangerous but wise enough to know advanced stuff like formulas. That's why I'm so in awe of your spreadsheet.

Link to comment
Share on other sites

The default $20 is the minimum payment for most c/c unit you reach the threshold where a % kick in. This is why the $20 is for any small balance.

 

If my balance is $1,800, what is my minimum payment if the threshold is 3%? Is it $20 or $54?

 

I'm not trying to be argumentative, I'm an Excel geek wanna-be - someone who knows just enough to be dangerous but wise enough to know advanced stuff like formulas. That's why I'm so in awe of your spreadsheet.

That's the thing, I am not telling you what your minimum payment is or should be (the field listed is payment options), I am telling you what the payment is if you choose to pay 3%. Every c/c is different, there is no way for me to know when the minimum payment is $20 or when it kicks to a %. There is a big difference between "Payment Options" & "minimum payment"..

 

In this case if you choose to pay 3% then it's $54, I am sure that is significatly higher then what the actual minimum payment is.

Edited by nyrfann
Link to comment
Share on other sites

  • 1 month later...

First off let me say Thank you for your work on this spreadsheet. I love it, I have added a column for my own that shows what days are being reported to the bureaus so that I know when my payments are due.

 

Just something to consider if you ever update.

 

Thanks,

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

Guidelines